Help please: Cache table corrupted.
Hi Drupal fans !
Three months ago my older hosting were insuficient to my website, and backup my DB (before empty cache tables) and move a another web hosting, drupal friendly. Create a new drupal install, delete the new tables and add the old DB, and work fine and my website is ok.
Two days after restore, the system send me a warning from aggregator table, only empty from phpmyadmin and work ok.
A month ago the system send me the next error... I empty the tables from phpmyadmin and work a little, and show me the warning again and again. :-(
I use the repair option from mysql, works a little and again show me warnings.
Also I try to put another theme and have negative solution. Maybe I forget install a few innecesare modules after restore the DB, because i dont need spam module because I install mycapcha module.
¿Any have a solution guys ?
If I dont find a good solution, I think backup these tables from my drupal installation; taxonomy, nodes, comments, users and delete my entire website and restore in a new installation. If you have any idea please help me :-)
Thanks in advance.
Regards !
Table './huajher9_drpl1/cache' is marked as crashed and should be repaired query: UPDATE cache SET data = 'a:363:{s:21:\"update_watchdog_fixed\";b:1;s:13:\"theme_default\";s:8:\"alek_2_0\";s:14:\"allowed_html_1\";s:86:\"<a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd><img><blockquote><center>\";s:25:\"theme_bluemarine_settings\";a:10:{s:12:\"default_logo\";s:1:\"1\";s:9:\"
logo_path\";s:0:\"\";s:11:\"toggle_name\";s:1:\"1\";s:13:\"toggle_slogan\";s:1:\"1\";s:14:\"toggle_mission\";s:1:\"1\";s:20:\
"toggle_primary_links\";s:1:\"1\";s:22:\"toggle_secondary_links\";s:1:\"1\";s:24:\"toggle_node_user_picture\";s:1:\"0\";s:27:\
"toggle_comment_user_picture\";s:1:\"1\";s:13: in /home/huajher9/public_html/huajuapan/includes/database.mysql.inc on line 172
Warning: Cannot modify header information - headers already sent by (output started at /home/huajher9/public_html/huajuapan/includes/database.mysql.inc:172) in /home/huajher9/public_html/huajuapan/includes/bootstrap.inc on line 531
Warning: Cannot modify header information - headers already sent by (output started at /home/huajher9/public_html/huajuapan/includes/database.mysql.inc:172) in /home/huajher9/public_html/huajuapan/includes/bootstrap.inc on line 532
Warning: Cannot modify header information - headers already sent by (output started at /home/huajher9/public_html/huajuapan/includes/database.mysql.inc:172) in /home/huajher9/public_html/huajuapan/includes/bootstrap.inc on line 533
Warning: Cannot modify header information - headers already sent by (output started at /home/huajher9/public_html/huajuapan/includes/database.mysql.inc:172) in /home/huajher9/public_html/huajuapan/includes/bootstrap.inc on line 534
Warning: Table './huajher9_drpl1/cache' is marked as crashed and should be repaired query: SELECT data, created, headers, expire FROM cache WHERE cid = 'locale:es' in /home/huajher9/public_html/huajuapan/includes/database.mysql.inc on line 172
Warning: Table './huajher9_drpl1/cache' is marked as crashed and should be repaired query: LOCK TABLES cache WRITE in /home/huajher9/public_html/huajuapan/includes/database.mysql.inc on line 172
Warning: Table './huajher9_drpl1/cache' is marked as crashed and should be repaired query: UPDATE cache SET data = 'a:3657:{s:20:\"Weather: system-wide\";b:1;s:20:\"Weather: custom user\";b:1;i:917;b:1;i:916;b:1;i:915;b:1;i:914;b:1;i:913;b:1;i:912;b:1;i:911;b:1;i:910;b:1;i:909;b:1;i:908;b:1;i:907;b:1;s:31:\"administer custom weather block\";b:1;i:949;b:1;i:948;b:1;i:947;b:1;i:946;b:1;i:945;b:1;i:944;b:1;i:1258;b:1;i:943;b:1;i:941;b:1;i:940;b:1;i:
939;b:1;i:938;b:1;i:937;b:1;s:32:\"Enables the IE Destroyer banner.\";b:1;s:11:\"iedestroyer\";b:1;s:21:\"IE Destroyer settings\";b:1;s:26:\"Enable IE Destroyer banner\";b:1;s:18:\"IE Destroyer level\";b:1;s:23:\"Google AdSense settings\";b:1;s:36:\"Your AdSense Firefox referral button\";b:1;s:27:\"Specific page configuration\";b:1;s:22:\"Show on specific pages\";b:1;s:69:\"Show if the following PHP code returns TRUE (PHP-mode, experts onl in
A extra information..
huajher9_drpl1 is cheking now...
huajher9_drpl1.access OK
huajher9_drpl1.accesslog
warning : 7 clients are using or haven't closed the table properly
status : OK
huajher9_drpl1.adsense_clicks OK
huajher9_drpl1.aggregator2_feed OK
huajher9_drpl1.aggregator2_item OK
huajher9_drpl1.aggregator_category OK
huajher9_drpl1.aggregator_category_feed OK
huajher9_drpl1.aggregator_category_item
warning : 1 client is using or hasn't closed the table properly
status : OK
huajher9_drpl1.aggregator_feed
warning : 1 client is using or hasn't closed the table properly
status : OK
huajher9_drpl1.aggregator_item
warning : 1 client is using or hasn't closed the table properly
status : OK
huajher9_drpl1.authmap OK
huajher9_drpl1.banner OK
huajher9_drpl1.banner_term OK
huajher9_drpl1.blocks OK
huajher9_drpl1.blocks_roles OK
huajher9_drpl1.book OK
huajher9_drpl1.boxes OK
huajher9_drpl1.cache
warning : 1 client is using or hasn't closed the table properly
status : OK
huajher9_drpl1.cache_captcha
warning : 6 clients are using or haven't closed the table properly
status : OK
huajher9_drpl1.cache_filter
warning : 1 client is using or hasn't closed the table properly
status : OK
huajher9_drpl1.cache_menu OK
huajher9_drpl1.cache_page
warning : 2 clients are using or haven't closed the table properly
status : OK
huajher9_drpl1.chatevents OK
huajher9_drpl1.chatmembers OK
huajher9_drpl1.client OK
huajher9_drpl1.client_system OK
huajher9_drpl1.comments OK
huajher9_drpl1.contact OK
huajher9_drpl1.dashboard OK
huajher9_drpl1.file_revisions OK
huajher9_drpl1.files OK
huajher9_drpl1.filter_formats OK
huajher9_drpl1.filters OK
huajher9_drpl1.flatforum OK
huajher9_drpl1.flood OK
huajher9_drpl1.form_store_forms OK
huajher9_drpl1.forum OK
huajher9_drpl1.guestbook OK
huajher9_drpl1.history OK
huajher9_drpl1.locales_meta OK
huajher9_drpl1.locales_source OK
huajher9_drpl1.locales_target
warning : 1 client is using or hasn't closed the table properly
status : OK
huajher9_drpl1.menu OK
huajher9_drpl1.moderation_filters OK
huajher9_drpl1.moderation_roles OK
huajher9_drpl1.moderation_votes OK
huajher9_drpl1.node OK
huajher9_drpl1.node_access OK
huajher9_drpl1.node_comment_statistics OK
huajher9_drpl1.node_counter
warning : 6 clients are using or haven't closed the table properly
status : OK
huajher9_drpl1.node_revisions OK
huajher9_drpl1.node_type OK
huajher9_drpl1.old_revisions OK
huajher9_drpl1.permission OK
huajher9_drpl1.poll OK
huajher9_drpl1.poll_choices OK
huajher9_drpl1.poll_votes OK
huajher9_drpl1.profile_fields OK
huajher9_drpl1.profile_values OK
huajher9_drpl1.queue OK
huajher9_drpl1.role OK
huajher9_drpl1.search_dataset OK
huajher9_drpl1.search_index OK
huajher9_drpl1.search_total OK
huajher9_drpl1.sequences
warning : 1 client is using or hasn't closed the table properly
status : OK
huajher9_drpl1.sessions OK
huajher9_drpl1.shoutbox OK
huajher9_drpl1.shoutbox_moderation OK
huajher9_drpl1.spam_custom OK
huajher9_drpl1.spam_log OK
huajher9_drpl1.spam_reported OK
huajher9_drpl1.spam_tokens OK
huajher9_drpl1.spam_tracker OK
huajher9_drpl1.system OK
huajher9_drpl1.term_data OK
huajher9_drpl1.term_hierarchy OK
huajher9_drpl1.term_node OK
huajher9_drpl1.term_relation OK
huajher9_drpl1.term_synonym OK
huajher9_drpl1.troll_blacklist OK
huajher9_drpl1.troll_ip_ban OK
huajher9_drpl1.troll_ip_track OK
huajher9_drpl1.troll_whitelist OK
huajher9_drpl1.url_alias OK
huajher9_drpl1.users OK
huajher9_drpl1.users_roles OK
huajher9_drpl1.variable OK
huajher9_drpl1.vocabulary OK
huajher9_drpl1.vocabulary_node_types OK
huajher9_drpl1.watchdog
warning : 11 clients are using or haven't closed the table properly
status : OK
huajher9_drpl1.weather OK
huajher9_drpl1.weather_config
Have you tried emptying
Have you tried emptying (truncating) all the cache tables?
If so, and you are still having trouble, you might -- if I understand your question correctly -- want to delete the tables, then immediately replace them with new cache tables (create_table 'cache', etc).
----------------------------------------------------------------------
http://www.bwv810.com/
I am a writer and researcher. In my spare time I build websites with Drupal.
Je peux communiquer en français. / Я могу связывать на русском языке.
Yes I try to emptying..
Yes I try to emptying all cache tables, and deleting innecesary tables, and the problem still.
¿Can I delete the entire website, before backup only node, taxonomy, messages, users tables, and restore in a new "empty" installation?
Thanks in advance.
It might be worth trying...
It might be worth trying... I am not sure it will work, as the data in several tables (such as variable) interact with/depend on each other. But it cannot hurt.
----------------------------------------------------------------------
http://www.bwv810.com/
I am a writer and researcher. In my spare time I build websites with Drupal.
Je peux communiquer en français. / Я могу связывать на русском языке.
Thanks..
I setup a new drupal installation, backup the new cache tables, delete the old cache tables, and restore with new tables and work. A few hours it work, now again the cache table is corrupted.
:-(
Devel?
In my case, the devel module was the cause of the problem. Or so it seems.
Are you using that?
I m not using devel
I m to try disable the devel module, however in my old installation I have only one devel module without trouble.
The troubles still :(. Please check www.huajuapanweb.com, a later I move my website to the old hosting to try fix the new.
I m go back at the old installation in the old hosting... before I try to backup again the DB and install it in my new hosting, I hope so that solve my problem.
Any people have a manual to backup drupal DB with PHPMyadmin ?
I need to know what modules need to disable and what tables need to empty before backup. I read that need to empty cache table, but also have problems with the watchdog table.
Ok :)
Thanks for you help. I disable mycapcha module and the problem is gone. :-)
That's good news, but I
That's good news, but I wonder why captcha was interfering with your DB. What PHP and MySQL versions does your webhost use? I'm not sure that will make a difference, but I am curious, as I have never had problems with captcha corrupting my DB as you describe happened to yours. Thanks.
----------------------------------------------------------------------
http://www.bwv810.com/
I am a writer and researcher. In my spare time I build websites with Drupal.
Je peux communiquer en français. / Я могу связывать на русском языке.
My tables are getting currupted tooo
I am using a multisite configuration at http://arunraj.in/ The site dont even have much data in it.
But still it is getting corrupted all the time.
:-( My question is is this really an error in Drupal?
Visit ARaj.iN