Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    45
    Plugin Contributions
    0

    Default HELP PLEASE! Repairing Database table

    Hi,

    I use Zen-Cart version 1.3.9a

    Today a customer informed me that my site is not working. I checked and though I can access the admin part, the who is online option when selected gives the following error on the screen:

    145 Table './*****_zc1/zen_whos_online' is marked as crashed and should be repaired
    in:
    [delete from zen_whos_online where time_last_click < '1327352018' or (time_entry=time_last_click and time_last_click < '1327352678')]
    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.

    Kindly advise what to do?

    Thanks!

  2. #2
    Join Date
    May 2010
    Location
    WA State
    Posts
    1,678
    Plugin Contributions
    3

    Default Re: HELP PLEASE! Repairing Database table

    Have you tried logging in to phpMyAdmin and repairing the table?

    BTW, it isn't necessary to post the same question in multiple forums.

  3. #3
    Join Date
    Jan 2010
    Posts
    45
    Plugin Contributions
    0

    Default Re: HELP PLEASE! Repairing Database table

    Thank you for your reply. I tried phpMyAdmin but the table could not be browsed as phpMyAdmin was showing it as 'in use'. I was not sure what effect 'dropping' the table and then copying a new one from whosonline would have so didn't try that. I later tried repairing the database from control panel and that did the job.

    I am sorry for posting the issue in the hacking forum but I was worried if I have finally been hacked.

    I would like to know why the problem occurred in the first place? Have I been hacked?

    Regards.

 

 

Similar Threads

  1. Accidently DELETED database table???? HELP
    By staceyx in forum General Questions
    Replies: 5
    Last Post: 24 May 2009, 06:31 AM
  2. HELP - Table and Database names forgotton
    By PJD in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 28 Apr 2008, 09:46 PM
  3. table error please help: "table 'sessions' doesn't exist"
    By ebydrc in forum General Questions
    Replies: 3
    Last Post: 6 Apr 2008, 06:13 AM
  4. Help about error 1146 Table.. SQL database Help
    By falerohydro in forum General Questions
    Replies: 2
    Last Post: 25 Feb 2008, 08:29 AM
  5. database table crash-- HELP
    By automan in forum General Questions
    Replies: 4
    Last Post: 11 Jan 2007, 07:20 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