Results 1 to 3 of 3
  1. #1
    Join Date
    May 2008
    Posts
    2
    Plugin Contributions
    0

    Default HELP Admin problem

    I tried to do something in my database but this went wrong. When i open my admin now and choose "configuration-my store" it is completely empty!!

    If i open my site the right column is gone and at the bottom it says:

    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 'EXPECTED_PRODUCTS_SORT limit 10' at line 7
    in:
    [select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '2' and p.products_date_available >=20080523 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit 10]


    PLEASE help me out here, my business is offline now!!!!

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

    Default Re: HELP Admin problem

    Almost sounds like you wiped out the configurations table ...

    Peek at your database in phpMyAdmin and browse the configuration table ...

    How many records do you have in there?
    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!]
    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
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: HELP Admin problem

    Sounds like you're using an older version of Zen Cart.
    Try this:
    http://www.zen-cart.com/forum/showth...357#post378357
    ... and plan an upgrade ...
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. Admin Login Problem, Need Help!
    By f1mktsol in forum General Questions
    Replies: 18
    Last Post: 23 Aug 2010, 01:17 PM
  2. admin problem help in configuring admin configure.php! help guys
    By harold_cpr in forum Basic Configuration
    Replies: 0
    Last Post: 4 Dec 2008, 09:58 AM
  3. Admin Problem Please help
    By cshart in forum General Questions
    Replies: 0
    Last Post: 13 Oct 2008, 03:50 PM
  4. Admin Login Problem PLEASE HELP
    By sparkiii in forum General Questions
    Replies: 23
    Last Post: 18 Jan 2008, 10:54 AM
  5. Problem wit Google Sitemap Admin HELP?
    By mfreund in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 13 Jun 2006, 09:46 PM

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