Page 1 of 2 12 LastLast
Results 1 to 10 of 13
  1. #1
    Join Date
    Feb 2007
    Posts
    20
    Plugin Contributions
    0

    Default 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

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Zencart error or Server error

    Check that your file is current and up to date for:
    /includes/classes/db/mysql/define_queries.php
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Feb 2007
    Posts
    20
    Plugin Contributions
    0

    Default 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.

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  5. #5
    Join Date
    Feb 2007
    Posts
    20
    Plugin Contributions
    0

    Default 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
    Last edited by Bridye; 31 Mar 2007 at 04:43 PM.

  6. #6
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  7. #7
    Join Date
    Feb 2007
    Posts
    20
    Plugin Contributions
    0

    Default 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.

  8. #8
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  9. #9
    Join Date
    Feb 2007
    Posts
    20
    Plugin Contributions
    0

    Default 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

  10. #10
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Zencart error or Server error

    Beyond Compare from scootersoftware.com is your friend ...

    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 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v150 Display 404 error page instead of 500 Internal Server Error
    By ShopVille in forum General Questions
    Replies: 1
    Last Post: 7 Dec 2012, 05:34 PM
  2. v139f Shopping Cart error: HTTP Error 500 (Internal Server Error)
    By Tulameen in forum General Questions
    Replies: 0
    Last Post: 15 Jan 2012, 01:48 AM
  3. Replies: 13
    Last Post: 4 Jun 2011, 02:31 PM
  4. Replies: 9
    Last Post: 30 Mar 2009, 06:50 AM
  5. Server error! ....server is overloaded or there was an error in a CGI script.
    By steely in forum Installing on a Linux/Unix Server
    Replies: 16
    Last Post: 29 Sep 2007, 08:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR