Warning: Table 'dhuha_drpl1.cache_page' doesn't exist query: SELECT data, created, headers, expire FROM cache_page WHERE cid = 'https://dhuha.net/en/content/computer/tutorial/drupal-repairing-MySQL-tables' in /home/dhuha/public_html/includes/database.mysql.inc on line 174

Warning: Cannot modify header information - headers already sent by (output started at /home/dhuha/public_html/includes/database.mysql.inc:174) in /home/dhuha/public_html/includes/bootstrap.inc on line 569

Warning: Cannot modify header information - headers already sent by (output started at /home/dhuha/public_html/includes/database.mysql.inc:174) in /home/dhuha/public_html/includes/bootstrap.inc on line 570

Warning: Cannot modify header information - headers already sent by (output started at /home/dhuha/public_html/includes/database.mysql.inc:174) in /home/dhuha/public_html/includes/bootstrap.inc on line 571

Warning: Cannot modify header information - headers already sent by (output started at /home/dhuha/public_html/includes/database.mysql.inc:174) in /home/dhuha/public_html/includes/bootstrap.inc on line 572

Drupal : Repairing MySQL Table

  • warning: Cannot modify header information - headers already sent by (output started at /home/dhuha/public_html/includes/database.mysql.inc:174) in /home/dhuha/public_html/includes/common.inc on line 141.
  • : Function ereg() is deprecated in /home/dhuha/public_html/includes/file.inc on line 646.
  • : Function ereg() is deprecated in /home/dhuha/public_html/includes/file.inc on line 646.
  • : Function ereg() is deprecated in /home/dhuha/public_html/includes/file.inc on line 646.
  • : Function ereg() is deprecated in /home/dhuha/public_html/includes/file.inc on line 646.
  • : Function ereg() is deprecated in /home/dhuha/public_html/includes/file.inc on line 646.
  • : Function ereg() is deprecated in /home/dhuha/public_html/includes/file.inc on line 646.
  • : Function ereg() is deprecated in /home/dhuha/public_html/includes/file.inc on line 646.
  • : Function ereg() is deprecated in /home/dhuha/public_html/includes/file.inc on line 646.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.
  • : Function split() is deprecated in /home/dhuha/public_html/modules/filter/filter.module on line 1206.

This morning, I got this message in one of my sites 'erakomputer':

Table './erakomp_drpl1/cache_menu' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_menu

erakomp

I don't know what's wrong with my site, there's nothing wrong when I open it last night but suddenly this morning that message has flooding my site pages. Thanks God Drupal Forum give a solution for this. They said it was problem with one of tables in MySQL database. They guess if the hosting machine crashes (i.e. does not get shutdown cleanly), this can happen. They suggesting I need to run the REPAIR command from mysql or phpMyAdmin.

How to repair it :

The table need to repair is cache_menu table.

  1. Login to phpMyAdmin. You can using your cPanel.
  2. Choose the affected database. I only have one database, so I don't need to do anything.
  3. In the main panel, I could see a list of my database tables. Then check the boxes by the tables that need repair. For me cache_menu tables.
  4. At the bottom of the window just below the list of tables, there is a drop down menu. Choose "Repair Table"
Table Op Msg_type Msg_text
erakomp_drpl1.cache_menu repair info Found block that points outside data file at 11733...
erakomp_drpl1.cache_menu repair status OK


Refreshing my site and now the problem fix :)



cxc

xcx's picture

I'm thankful to the one who wrote this passage. I always read and write this style of articles. video izle Also, as a daily writer, I present my respects to the all writers. Lately, I have watched a video resembling that in facebook. I research in all areas.

In my opinion, people should research first and write then.

Regards.