Results 1 to 10 of 13

Hybrid View

  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!

 

 

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