Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Join Date
    Jan 2006
    Posts
    13
    Plugin Contributions
    0

    application error Database error - site crashed!!! db_cache is marked as crashed and should be repair

    I need help... This is the error I am getting

    1194 Table 'zen_db_cache' is marked as crashed and should be repaired

    Does anyone know what this means and how to fix it.

    Thanks

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,762
    Plugin Contributions
    9

    Default Re: Database error - site crashed!!! db_cache is marked as crashed and should be rep

    If you are with a host that provides you with cPanel - there is a repair Db function that you could try. I would back it up first.

    As this is just a cache and only contains temp data you can uisng phpmyadmin select this table only and in a pulldown at the bottom you can select "empty" and go. This will clear the temp data data out if that is the issue
    Zen-Venom Get Bitten

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

    Default Re: Database error - site crashed!!! db_cache is marked as crashed and should be rep

    Tested both but fails. Db repair and phpmyadmin where the zen_db_cache is emptied but seems like nothing changes.

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,762
    Plugin Contributions
    9

    Default Re: Database error - site crashed!!! db_cache is marked as crashed and should be rep

    What is your most recent DB Backup date prior to this error?

    For a busy shop, you should take one daily
    Zen-Venom Get Bitten

  5. #5
    Join Date
    Nov 2005
    Posts
    165
    Plugin Contributions
    0

    Default Re: Database error - site crashed!!! db_cache is marked as crashed and should be rep

    There are several backups. For example one dates to April, 2006. While this time zen_db_cache is crashed and is void of content, the earlier backups show certain content like this:

    -- Table structure for table `zen_db_cache`
    --

    DROP TABLE IF EXISTS `zen_db_cache`;
    CREATE TABLE `zen_db_cache` (
    `cache_entry_name` varchar(64) NOT NULL default '',
    `cache_data` blob,
    `cache_entry_created` int(15) default NULL,
    PRIMARY KEY (`cache_entry_name`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    --
    -- Dumping data for table `zen_db_cache`
    --


    /*!40000 ALTER TABLE `zen_db_cache` DISABLE KEYS */;
    LOCK TABLES `zen_db_cache` WRITE;
    INSERT INTO `zen_db_cache` VALUES ('.................................. so on

    so on
    so on, and after many lines ending like this:

    UNLOCK TABLES;
    /*!40000 ALTER TABLE `zen_db_cache` ENABLE KEYS */;



    SHOULD THESE BE COPIED TO THE CRASHED DATABASE?
    Last edited by zenartman; 14 Oct 2008 at 05:35 AM. Reason: TO ACTIVATE notification

  6. #6
    Join Date
    Jan 2004
    Posts
    66,350
    Blog Entries
    7
    Plugin Contributions
    271

    Default Re: Database error - site crashed!!! db_cache is marked as crashed and should be rep

    You do not need to include the "Dumping data .... " section for the db_cache table.
    .

    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.

  7. #7
    Join Date
    Nov 2005
    Posts
    165
    Plugin Contributions
    0

    Default Re: Database error - site crashed!!! db_cache is marked as crashed and should be rep

    Thank you very much DrByte,

    How the database is copied?

    1) Thru phpmyadmin?
    2) Or the online shop backend should be be used to upload this part:
    DROP TABLE IF EXISTS `zen_db_cache`;
    CREATE TABLE `zen_db_cache` (
    `cache_entry_name` varchar(64) NOT NULL default '',
    `cache_data` blob,
    `cache_entry_created` int(15) default NULL,
    PRIMARY KEY (`cache_entry_name`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    BTW the backend login is crashed too when the above mistake happens.
    Googling on copying database brought some results written in quite technical jargon.

  8. #8
    Join Date
    Jan 2004
    Posts
    66,350
    Blog Entries
    7
    Plugin Contributions
    271

    Default Re: Database error - site crashed!!! db_cache is marked as crashed and should be rep

    The best and fastest thing to do when you get that problem is to go into phpMyAdmin and click on the SQL tab and enter the following statement, and click Go:
    Code:
    repair table zen_db_cache;
    .

    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.

  9. #9
    Join Date
    Nov 2005
    Posts
    165
    Plugin Contributions
    0

    Default Re: Database error - site crashed!!! db_cache is marked as crashed and should be rep

    Doing that shows this:

    import.php: Missing parameter: import_type (FAQ 2.8)
    import.php: Missing parameter: format (FAQ 2.8)

    Checking again zen_db_cache shows:
    Error

    SQL query: Edit

    SHOW INDEX FROM `zen_db_cache` ;

    MySQL said: Documentation
    #145 - Table './mydomain_zc1/zen_db_cache' is marked as crashed and should be repaired

  10. #10
    Join Date
    Jan 2004
    Posts
    66,350
    Blog Entries
    7
    Plugin Contributions
    271

    Default Re: Database error - site crashed!!! db_cache is marked as crashed and should be rep

    Then your phpMyAdmin has some problems with it.
    You could try doing the repair via your ZC Admin sql patch tool:
    Code:
    repair table db_cache;
    If that doesn't work, or you can't access it, you'll have to drop the table and recreate it, using what you posted in your 2nd point in your previous post.
    .

    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.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Table 'db_cache' is marked as crashed and should be repaired
    By Lara2911 in forum General Questions
    Replies: 5
    Last Post: 23 Sep 2015, 12:07 AM
  2. Replies: 2
    Last Post: 3 Nov 2012, 10:13 AM
  3. 1194 Table 'b' is marked as crashed and should be repaired
    By magibson in forum Installing on a Linux/Unix Server
    Replies: 6
    Last Post: 28 Aug 2012, 08:46 PM
  4. zen_db_cache' is marked as crashed and should be repaired
    By upollo in forum General Questions
    Replies: 14
    Last Post: 23 Jun 2010, 04:12 PM
  5. Urgent: whos_online' is marked as crashed and should be repaired
    By colorlens4less in forum General Questions
    Replies: 1
    Last Post: 11 Feb 2009, 07:34 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