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
    67,170
    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.3]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  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
    67,170
    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.3]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  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
    67,170
    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.3]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  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
    67,170
    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.3]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  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
    67,170
    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.3]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Fatal error: mysql error (1064 error) -- v1.0-alpha
    By Dale Schibbelhut in forum General Questions
    Replies: 9
    Last Post: 18 Nov 2010, 08:08 PM
  2. Paypal error 10002 misconfigured mixed live and sandbox
    By azwli in forum Addon Payment Modules
    Replies: 13
    Last Post: 27 Nov 2009, 04:55 AM
  3. %00 Internal server error when adding music clip
    By benjames in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 31 Aug 2006, 03:34 AM
  4. Error: 1036 Table 'db_cache' is read only
    By namasa in forum General Questions
    Replies: 1
    Last Post: 26 Jul 2006, 07:06 PM

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
  •