Omeka 2.6.1 Conflict with MYSQL 8?

Omeka Database Error

Variable ‘sql_mode’ can’t be set to the value of ‘NO_AUTO_CREATE_USER’.

Confirm that the information in your db.ini file is correct.

Is there a way to update db.ini to fix. Or is upgrade to 3.3 the only solution?

Also had a php error → downgrade to 7.4 fixed that temporarily

Upgrading Omeka to the latest Classic will fix that NO_AUTO_CREATE_USER problem with MySQL 8.

Specifically, that issue was fixed starting with Omeka Classic version 2.7.

1 Like