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

Check that your file is current and up to date for:
/includes/classes/db/mysql/define_queries.php

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.

Do a search on your configuration table in your database for:

SELECT * FROM configuration WHERE configuration_key LIKE '%SHOW_PRODUCT_INFO_MAIN%';

How many configuration_keys come up that start with SHOW_PRODUCT_INFO_MAIN

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

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

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.

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?

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

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:

Good Morning Linda,
Thank you so much for your help. You have truly been supportive since my first install. I'm really hoping that you like my tie dye work so I can send you something for your help. Please take a look at the site and pick something out if you'd like. Contact me here or through the site if you find something and I'll make it and send it to you. The site still has a couple issues, one I need help with, but the user side is functional.

What i'm having a problem with is logging into the admin page. I get the following error:

Warning: main(/home/bridyeco/public_html/includes/extra_configures/bmz_image_handler_conf.php): failed to open stream: No such file or directory in /home/bridyeco/public_html/admin/includes/extra_configures/bmz_image_handler_conf.php on line 12

Fatal error: main(): Failed opening required '/home/bridyeco/public_html/includes/extra_configures/bmz_image_handler_conf.php' (include_path='.:/usr/local/lib/php') in /home/bridyeco/public_html/admin/includes/extra_configures/bmz_image_handler_conf.php on line **12

**All the other similar errors I've seen on the forum have involved missing files or error in the configure.php. I've reloaded the bmz_ files and as far as I can tell my configure files look fine. Any ideas on this one for me?

BTW. 'beyond compare' has certainly been my friend.

Thanks in advance,
Brian
http://www.bridye.com
zen version 1.3.7

Try reloading the files in case they are missing, corrupted or loaded to the wrong location ...

This has been fixed. The site is up and running smoothly. I wish I had a clear understanding of what I did to make it so. What I beleive it was is that I had modified my tpl_modues_product_listing file on the old server and the new tpl_ file wasn't working with the new server for some reason. Like I said I'm not positive. I loaded a mix of fresh install files and backed up files to get my site running on the new server.

I;m very happy it's running, but I sure wish I new exactly what was wrong in case anything like it happens again.

Thanks for all the help,
Brian