Closed AmpedCanada closed 1 week ago
sql_require_primary_key
should be off by default: https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_sql_require_primary_key. I don't know why it is on in your case, but you need to turn it off. Fixing this in SeAT is in my opinion out of scope, since it is on an unsupported DB with a non-default configuration.What I suggest to do to fix this is to disable the sql_require_primary_key
setting.
Closing as we no longer support mysql and a fix has been given
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) 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