Post by p419 » 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.

Regards,

Paul


Active Member

Posts

Joined
Tue Nov 27, 2018 2:01 am
Location - Toronto

Post by JNeuhoff » Sun Feb 02, 2025 5:33 pm

Invalid DB_PREFIX, it shouldn't contain '!' . See you config.php and admin/config.php.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by p419 » Sun Feb 02, 2025 8:30 pm

JNeuhoff wrote:
Sun Feb 02, 2025 5:33 pm
Invalid DB_PREFIX, it shouldn't contain '!' . See you config.php and admin/config.php.
Thanks JNeuhoff! That was the problem and all's good now.

Regards,

Paul


Active Member

Posts

Joined
Tue Nov 27, 2018 2:01 am
Location - Toronto
Who is online

Users browsing this forum: No registered users and 10 guests