SQL error on product catalog after server update

[pcontreras1]

hello zencart fellas, im working witha a site built over zencart 1.2.7


here's the thing>


due to obvios reasons, we updated server software to PHP 5.3.7 and MySQL 5.1.x, so the site rised all kind of errors and warnings, mostly deprecated functions.

i installed the debug php module and replaced all deprecated functions one by one, and i got almost the site back online, but for a couple things>


on any product detail page, there's this error>

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*******select configuration_key, configuration_value from configuration where co' at line 1


and the CC integration is not working anymore.


i can crack my head with payment integration, but i can't find the solution for the SQL error....

any ideas?


site if you want to lurk around>


http://floralesvogue.com (try to get into any product details page )


i searched the forum for this kinda error, but couldn't find any thread (there are a couple stating similar errors, but the solution doesn't apply here)

thanks.

[pcontreras1]

hello zencart fellas, im working witha a site built over zencart 1.2.7


here's the thing>


due to obvios reasons, we updated server software to PHP 5.3.7 and MySQL 5.1.x, so the site rised all kind of errors and warnings, mostly deprecated functions.

i installed the debug php module and replaced all deprecated functions one by one, and i got almost the site back online, but for a couple things>


on any product detail page, there's this error>

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*******select configuration_key, configuration_value from configuration where co' at line 1


and the CC integration is not working anymore.


i can crack my head with payment integration, but i can't find the solution for the SQL error....

any ideas?


site if you want to lurk around>


http://floralesvogue.com (try to get into any product details page )


i searched the forum for this kinda error, but couldn't find any thread (there are a couple stating similar errors, but the solution doesn't apply here)

thanks.

[DrByte]

Your correct fix is to upgrade to a version of Zen Cart that is compatible with the PHP and MySQL version you're using on your server. The best choice for that as of today is v1.5.0