Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    70
    Plugin Contributions
    0

    Default Cannot log into zencart admin, get a crash error

    Hello Everyone! I cannot seem to find this issue anywhere else, but forgive me if I missed something.

    Our sites runs an older version of ZenCart (v 1.3.7) which is going to be updated, but for one of our sites it is a rather large job that cannot be immediately done. We have had a few hack attempts the last couple weeks and it seems there are a lot of "holes" in our site.

    My initial problem beginning last week is that customers are unable to create an account, when they hit 'submit' this error code shows up:
    "1062 Duplicate entry '0' for key 4
    in:
    [INSERT INTO zen_customers (customers_firstname, customers_lastname, customers_email_address, customers_nick, customers_telephone, customers_fax, customers_newsletter, customers_email_format, customers_default_address_id, customers_password, customers_authorization) VALUES (...(personal customer info)...)"


    However now, I am unable to do the recommendation I found because our Zencart admin has crashed! This is the error I get when clicking submit at the login page for the admin area:
    "144 Table './chw/zen_admin_activity_log' is marked as crashed and last (automatic?) repair failed
    in:
    [insert into zen_admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '0', 'login.php ', '', '70.176.66.20')]
    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."

    Furthermore, in phpMyAdmin the Zen_admin_activity_log folder brings back a similar error:
    " MySQL said:
    #144 - Table './chw/zen_admin_activity_log' is marked as crashed and last (automatic?) repair failed

    I am in way over my head here and have no idea how to rectify this situation. I spoke with my hosting company and they informed me it is a zencart error and not anything they can do. If anyone has any idea how to maybe fix this, I'm all ears! I tried contacting the hired help we have for this, but alas no reply

    Thanks,
    Ryan H.
    CornerHardware.com

  2. #2
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,024
    Plugin Contributions
    3

    Default Re: Cannot log into zencart admin, get a crash error

    Have you tried manually repairing the database in CPanel ? Should be an option under 'mySQL databases'.

  3. #3
    Join Date
    Nov 2005
    Posts
    70
    Plugin Contributions
    0

    Default Re: Cannot log into zencart admin, get a crash error

    Thanks Steve, Our hosting company doesn't use Cpanel...I spoke with a rep there and they said they "fixed" the problem and should be no need for repair. I'll believe it when I see it!!! In the meantime I asked them to tell me how to repair a database if they don't use Cpanel for future reference.

 

 

Similar Threads

  1. Table crash: how do you get into Admin to fix
    By black68gtx in forum General Questions
    Replies: 8
    Last Post: 24 Jan 2011, 11:43 PM
  2. Fatal Error - Cannot log into Admin Panel
    By featured in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 14 Aug 2008, 10:18 PM
  3. Replies: 0
    Last Post: 6 Apr 2008, 01:33 PM
  4. Cannot get into Admin -receive parse error
    By fdalotto in forum Customization from the Admin
    Replies: 1
    Last Post: 30 Dec 2007, 05:56 PM
  5. Replies: 6
    Last Post: 7 Dec 2007, 03:42 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