Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2005
    Posts
    11
    Plugin Contributions
    0

    Default database table crash-- HELP

    when i go to my main store, the only thing displayed is:
    "1194 Table 'whos_online' is marked as crashed and should be repaired"

    so, i went into pMA, saved a backup of the database, and ran a repair... to no avail. i also tried to disable that module from showing at all, but that doesnt help either. anyone have an idea on how to correct this without having to redo the entire site?

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: database table crash-- HELP

    You need to talk to your Hosting Company about the problem happening in your database on their server.
    Tell them that you've run a repair and the problem persists.

    They are your first line of support for problems with database issues at that level.
    .

    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.

  3. #3
    Join Date
    Mar 2005
    Posts
    11
    Plugin Contributions
    0

    Default Re: database table crash-- HELP

    i spoke with them. they havent changed anything in mysql, php, or apache. they ran the repair that didnt work. any other ideas?

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: database table crash-- HELP

    You could remove and rebuild the whos_online table with:
    PHP Code:
    DROP TABLE IF EXISTS whos_online;
    CREATE TABLE whos_online (
      
    customer_id int(11) default NULL,
      
    full_name varchar(64NOT NULL default '',
      
    session_id varchar(128NOT NULL default '',
      
    ip_address varchar(15NOT NULL default '',
      
    time_entry varchar(14NOT NULL default '',
      
    time_last_click varchar(14NOT NULL default '',
      
    last_page_url varchar(255NOT NULL default '',
      
    host_address text NOT NULL,
      
    user_agent varchar(255NOT NULL default '',
      
    KEY idx_ip_address_zen (ip_address),
      
    KEY idx_session_id_zen (session_id),
      
    KEY idx_customer_id_zen (customer_id),
      
    KEY idx_time_entry_zen (time_entry),
      
    KEY idx_time_last_click_zen (time_last_click),
      
    KEY idx_last_page_url_zen (last_page_url)
    TYPE=MyISAM
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  5. #5
    Join Date
    Mar 2005
    Posts
    11
    Plugin Contributions
    0

    Default Re: database table crash-- HELP

    still the same issue. where can i find the code to disable the whos_online call altogether?

 

 

Similar Threads

  1. Database crash notice
    By y051313 in forum General Questions
    Replies: 4
    Last Post: 22 Jul 2012, 02:02 PM
  2. v139h Server Crash trying to restore site strange Customer table problem
    By cshart in forum General Questions
    Replies: 3
    Last Post: 6 Jun 2012, 03:48 AM
  3. Whos_Online Table Crash
    By zmoore89 in forum General Questions
    Replies: 2
    Last Post: 2 Sep 2011, 06:38 PM
  4. Database table crash + send newsletters problem
    By delia in forum General Questions
    Replies: 4
    Last Post: 7 Apr 2011, 12:43 PM
  5. 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

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