Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010
    Location
    Stoke-on-Trent, Staffordshire. UK
    Posts
    131
    Plugin Contributions
    0

    red flag Please Help mySQL Emergency

    Please help me.....
    My zencart hit problems last night and got in such a mess that I simply delete all the files from my domain and uploaded a backup which was made literally minutes before i messed the files up.
    Everything seemed fine and i had no problems at all and everything works fine UNTIL a user logs in.
    After entering log in info users hit a blank screen with the following text:

    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 '), customers_info_number_of_logons = customers_info_number_of_' at line 2
    in:
    [UPDATE customers_info SET customers_info_date_of_last_logon = date_add(now(), INTERVAL HOUR), customers_info_number_of_logons = customers_info_number_of_logons+1 WHERE customers_info_id = 1]

    Im not techically minded in this way and have absolutely no idea of how to fix this error. The user can click back and will go back to the previouse screen and be logged in but there is obviously a problem and since this is a business site which is still relatively new i would rather start again now rather than later if this is unrepairable.

    PLEAS HELP ASAP

  2. #2
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: Please Help mySQL Emergency

    You've attempted to install the time-zone-offset addon, but you've not set the time interval value from within your admin yet as directed the installation instructions.
    .

    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. Emergency please help asap
    By Miff in forum General Questions
    Replies: 11
    Last Post: 26 Nov 2010, 03:29 PM
  2. Emergency - Please Help I Beg
    By hudda in forum General Questions
    Replies: 11
    Last Post: 15 Jun 2008, 01:24 PM
  3. I need help, very emergency,please....
    By g-life in forum General Questions
    Replies: 13
    Last Post: 19 Jan 2008, 11:03 PM
  4. Emergency- Help Please I Beg
    By hudda in forum General Questions
    Replies: 22
    Last Post: 10 Dec 2007, 12:40 AM
  5. EMERGENCY - Please Help
    By jumbuck2 in forum Basic Configuration
    Replies: 1
    Last Post: 12 Jun 2006, 02:16 AM

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