Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2010
    Posts
    2
    Plugin Contributions
    0

    Default Cannot access zencart admin

    Hi guys, need help here. I was trying to change the timezone in my store and I accidentally saved it as "+" instead of "+8". Now I can't enter my zencart admin and all I see is this error message.

    "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 '), '0', 'login.php ', '', '220.255.2.138')' at line 1
    in:
    [insert into zen_admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (date_add(now(), INTERVAL + HOUR), '0', 'login.php ', '', '220.255.2.138')]
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."

    How do I undo this error? Without zencart admin, my store will be suffering badly in terms of reputation. Hope some kind soul can offer some advice asap.

    Thanks a million. I'm quite desperate here.

  2. #2
    Join Date
    Mar 2011
    Posts
    3
    Plugin Contributions
    0

    Default Re: Cannot access zencart admin

    Hi,
    I wish I could help you with your problem...but, you might be able to help me? I need to edit my site and I can't remember how to get to the site where I can edit my settings. I put my page up a year ago for show basically and have not had any orders. Could you please help me? I asked for help in forums but nobody has replied.
    Thank you so much for your time.
    Kim

  3. #3
    Join Date
    Mar 2009
    Location
    Niagara Ontario
    Posts
    135
    Plugin Contributions
    0

    Default Re: Cannot access zencart admin

    clear your cache for starters.
    looks like mySQL is asking you to use phpmyadmin to access the ' admin_activity_log ' table and look for the last log entry and edit the fields as it says above "INTERVAL + HOUR), '0',"to correct the time
    Last edited by usr50; 12 Mar 2011 at 10:59 PM. Reason: updated

  4. #4
    Join Date
    Mar 2009
    Location
    Niagara Ontario
    Posts
    135
    Plugin Contributions
    0

    Default Re: Cannot access zencart admin

    in a web browser type http://www.yoursite.com/whatever_you..._admin_folder/ will take you to the admin login page

  5. #5
    Join Date
    Mar 2011
    Posts
    3
    Plugin Contributions
    0

    Default Re: Cannot access zencart admin

    omgosh... I feel so stupid. The whatever didn't make sense to me.
    I understand it to be...
    designsbykimmie.com/whatever_designsbykimmie_admin_folder/
    If this were my company name would this be correct? Please be patient. I read threw FAQ and couldn't find out this info.
    Sorry to bother you and greatful for your time and help.
    Kimmie

 

 

Similar Threads

  1. Cannot access admin
    By gamenet in forum General Questions
    Replies: 67
    Last Post: 25 Oct 2010, 05:26 PM
  2. Cannot access zencart over local network
    By bikerlee in forum Installing on a Mac Server
    Replies: 4
    Last Post: 16 Nov 2007, 12:11 AM
  3. Replies: 11
    Last Post: 4 Oct 2007, 06:53 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