DB error upgrading from 3.0.3.1 to 3.0.40 - WHERE `key` = 'config_timezone' AND store_id = '0'' at line 1
Posted: Sun Feb 02, 2025 10:03 am
Hello All,
We're upgrading to OC 3.0.4.0 and php 8.1 and had it running successfully and error free on a dev server. We've now copied the database and files to the live server and we're getting the following error on the front end and back end:
Warning: mysqli::query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '!_setting WHERE `key` = 'config_timezone' AND store_id = '0'' at line 1 in /home/pfm1967/public_html/system/library/db/mysqli.php on line 25
Can anyone point me in the right direction to correct this in the database?
Any help is appreciated.
We're upgrading to OC 3.0.4.0 and php 8.1 and had it running successfully and error free on a dev server. We've now copied the database and files to the live server and we're getting the following error on the front end and back end:
Warning: mysqli::query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '!_setting WHERE `key` = 'config_timezone' AND store_id = '0'' at line 1 in /home/pfm1967/public_html/system/library/db/mysqli.php on line 25
Can anyone point me in the right direction to correct this in the database?
Any help is appreciated.