Zencart error or Server error
I just moved to a secure server and I now get this error after uploading the site to the new server and resoring the database.
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 'SQL_SHOW_PRODUCT_INFO_MAIN' at line 1
in:
[SQL_SHOW_PRODUCT_INFO_MAIN]
Any ideas on how to fix this. I have moved the site before with no problems. I checked with my host, there were no php or mysgl updates. I can log into admin and everything is there. I have re-insatlled Zencart and my database several times with no luck.
Thanks in advance for any help,
Brian
V 1.3.7
Re: Zencart error or Server error
Check that your file is current and up to date for:
/includes/classes/db/mysql/define_queries.php
Re: Zencart error or Server error
It is current. I have uploaded fresh copy from install package with no help. As for up to date. If there is something in that file that needs to be changed since I've moved servers then, No. It's not up to date. But in moving Zencart in the past I haven't had to change anything.
Re: Zencart error or Server error
Do a search on your configuration table in your database for:
PHP Code:
SELECT * FROM configuration WHERE configuration_key LIKE '%SHOW_PRODUCT_INFO_MAIN%';
How many configuration_keys come up that start with SHOW_PRODUCT_INFO_MAIN
Re: Zencart error or Server error
SELECT `configuration_key`
FROM `DB_configuration`
WHERE configuration_key LIKE '%SHOW_PRODUCT_INFO_MAIN%';
SHOW_PRODUCT_INFO_MAIN_FEATURED_PRODUCTS
SHOW_PRODUCT_INFO_MAIN_NEW_PRODUCTS
SHOW_PRODUCT_INFO_MAIN_SPECIALS_PRODUCTS
SHOW_PRODUCT_INFO_MAIN_UPCOMING
That's what comes up
Re: Zencart error or Server error
And if you delete this file from the server and reload a clean one from a clean Zen Cart v1.3.7 ...
/includes/classes/db/mysql/define_queries.php
Re: Zencart error or Server error
Downloadednew Zencart 1.3.7, unzipped,deleted file from server,uploaded new file and no difference.
I've moved Zencart before with no issues. I'm really wondering if it's a server issue. I have my host checking, but so far no luck.
Re: Zencart error or Server error
How about if you make a temp directory with a temp database and load the files fresh from v1.3.7 then load the demo products on the install ...
Does a clean, virgin copy of Zen Cart work on this server?
Re: Zencart error or Server error
Yes. I tried that this morning and made some progress. I wiped the DB and everything in my public_html folder. Then did a clean install, imported the DB and it worked. This narrows it down to one of the mods or added components. I think it's something in the template, but havn't had time to upload each mod one at a time and find the one thats failing. That's going to be tommorrow afternoon. The only additions I've made are mostly grey template and pop-up on attributes. And since the only place I can find Show_product_info_main is in the templates folders, something must have gone wrong there. Maybe I'll just try a fresh template download.
Thanks for helping to get me thinking in the right direction,
Brian
Re: Zencart error or Server error
Beyond Compare from scootersoftware.com is your friend ... :cool:
This can help you compare different versions of Zen Cart or the default files against the overrides etc.
Very helpful in finding pesky little nuances that have changed ...
Also very good if you purchase it in that it does a FTP compare from files on your computer to those on your web site as well ... :smile: