Thread: Database error

Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005
    Location
    Australia
    Posts
    110
    Plugin Contributions
    1

    Default Database error

    My sites homepage is down and giving this error;
    1194 Table 'zen_whos_online' is marked as crashed and should be repaired
    in:
    [delete from zen_whos_online where time_last_click < '1272358601']
    I can still access the admin and I'm not sure what to do from here.

    I can get access to MyPHP admin but I am very nervous to play arounf in there.

    I have done a backup using the backup tool and it seems to have created a backup even though it reported an error and said the whos online table was not backed up.

    Can anybody tell me how to repair the table?

    My site status is this:
    Zen Cart 1.3.7
    Database Patch Level: 1.3.7
    I hope somebody can help because this is a live site and I'm losing business.
    Cheers all,

    Gruntre69

    WayCool
    Zen is Way Cool too!

  2. #2
    Join Date
    Aug 2005
    Location
    Australia
    Posts
    110
    Plugin Contributions
    1

    Default Re: Database error

    OK sorry about the panic post.

    I found the solution and here it is for anybody else who get this error.

    Select the table in MyPHP admin and in the dropdown box "with selected" select repair.

    This fixed it and all is good. I have no idea what caused this though.... Any body know what causes a MYSQL table to crash?

    I hope it wasn't a hacking attempt....
    Cheers all,

    Gruntre69

    WayCool
    Zen is Way Cool too!

 

 

Similar Threads

  1. Database error 1030 Got error 127 from storage engine
    By kdlklm in forum General Questions
    Replies: 4
    Last Post: 9 Jul 2014, 04:55 PM
  2. Error importing old database to the new database
    By wmorris in forum Upgrading to 1.5.x
    Replies: 1
    Last Post: 3 Jan 2012, 08:27 AM
  3. Replies: 4
    Last Post: 15 Oct 2010, 07:18 AM
  4. 500 Error - FastCGI error message after database installation page.
    By hungoveragain in forum Installing on a Windows Server
    Replies: 8
    Last Post: 24 Sep 2010, 03:37 PM
  5. Replies: 2
    Last Post: 12 Aug 2008, 05:22 PM

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