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
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
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
Tested both but fails. Db repair and phpmyadmin where the zen_db_cache is emptied but seems like nothing changes.
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
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
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.
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.
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.
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
Then your phpMyAdmin has some problems with it.
You could try doing the repair via your ZC Admin sql patch tool: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.Code:repair table 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.
Bookmarks