Database update from 2.0.5 on MySQL

felix

When updating the database through CLI from 2.0.5 to 2.0.6 while using MySQL the following error occurs

"PHP Fatal error: Uncaught mysqli_sql_exception: Invalid default value for 'record_updated_at' in /home/helpdesk-jhuh1/helpdesk.isqu.net/database_updates.php:3369"

Solution: If you've been using ITFlow on MySQL, you likely have the following line in your config file:

$mysqli->query("SET SESSION sql_mode = 'TRADITIONAL'");

Change it to:

$mysqli->query("SET SESSION sql_mode = ''");

Basically just remove the word traditional. No need to change it back after the update, everything still works (so far)

wrongecho

Thanks for sharing.

For anyone new looking at this post, we no longer support or encourage the use of MySQL due to the subtle and weird differences from MariaDB.