You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Problem: Fresh install using mysql database throwing error when running the below command.
Run the database migrations with: sudo -H -u www-data bash -c 'php /var/www/seat/artisan migrate'
Expected: Create the table password_resets but instead fails with error no primary_key set.
Error Message: SQLSTATE[HY000]: General error: 3750 Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set. Add a primary key to the table or unset this variable to avoid this message. N
ote that tables without a primary key can cause performance problems in row-based replication, so please consult your DBA before changing this setting. (Connection: mysql, SQL: create table password_resets (email varchar(255) no
t null, token varchar(255) not null, created_at timestamp not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')
Version Info: Seat V5.0
The text was updated successfully, but these errors were encountered:
Using mysql is not officially supported. SeAT is designed for MariaDB and PostgreSQL. That being said, it will probably also work with mysql, but you might need to tweak a few things here and there.
Problem: Fresh install using mysql database throwing error when running the below command.
Run the database migrations with: sudo -H -u www-data bash -c 'php /var/www/seat/artisan migrate'
Expected: Create the table password_resets but instead fails with error no primary_key set.
Logs / Screenshots / Proof: Screenshot: https://i.imgur.com/uI5f0RC.png
Error Message: SQLSTATE[HY000]: General error: 3750 Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set. Add a primary key to the table or unset this variable to avoid this message. N
ote that tables without a primary key can cause performance problems in row-based replication, so please consult your DBA before changing this setting. (Connection: mysql, SQL: create table
password_resets
(email
varchar(255) not null,
token
varchar(255) not null,created_at
timestamp not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')Version Info: Seat V5.0
The text was updated successfully, but these errors were encountered: