Jamie, thanks. How would that happen normally? Just from the date being entered into it during the normal course of operations? Will emptying the table, as I've done, solve it permanently? Neil ----- Original Message ----- From: "Jamie Holly" <hovercrafter@earthlink.net> To: <support@drupal.org> Sent: Tuesday, April 21, 2009 8:38 PM Subject: Re: [support] Errors showing on 5.16 site, was fine this afternoon
One of the index files used my MySQL became corrupt. From PHPMyAdmin or the MySQL command line, run:
REPAIR TABLE cache;
That usually fixes it.
Jamie Holly http://www.intoxination.net http://www.hollyit.net
Neil Coghlan wrote:
I just went to my D5 site and everything looked perfect. I logged in and was confronted with this on a white sql error page: Warning: Incorrect key file for table './mysite_drupalENG/cache.MYI'; try to repair it query: UPDATE cache SET data = 'a:959:{s:13:\"theme_default\";s:7:\"mysite\";s:13:\"filter_html_1\";s:1:\"1\";s:18:\"node_options_forum\";a:0:{}s:17:\"menu_primary_menu\";i:2;s:19:\"menu_secondary_menu\";i:2;s:15:\"install_profile\";s:7:\"default\";s:17:\"node_options_page\";a:1:{i:0;s:6:\"status\";}s:12:\"comment_page\";s:1:\"0\";s:14:\"theme_settings\";a:1:{s:21:\"toggle_node_info_page\";b:0;}s:18:\"drupal_private_key\";s:64:\"fe2614ccf5c885bad6bc60bba920218c7b8de0e65a0ae6fef45fad4332c104cf\";s:19:\"file_directory_temp\";s:3:\"tmp\";s:9:\"cron_last\";i:1240350721;s:9:\"site_name\";s:7:\"mysite\";s:9:\"site_mail\";s:21:\"webmaster@mysite.com\";s:11:\"site_slogan\";s <mailto:webmaster@mysite.com%5C%22;s:11:%5C%22site_slogan%5C%22;s>: in /home/mysite/public_html/includes/database.mysql.inc on line 174 Warning: Cannot modify header information - headers already sent by (output started at /home/mysitec/public_html/includes/database.mysql.inc:174) in /home/mysitec/public_html/includes/bootstrap.inc on line 569 Warning: Cannot modify header information - headers already sent by (output started at /home/mysitec/public_html/includes/database.mysql.inc:174) in /home/mysitec/public_html/includes/bootstrap.inc on line 570 Warning: Cannot modify header information - headers already sent by (output started at /home/mysitec/public_html/includes/database.mysql.inc:174) in /home/mysitec/public_html/includes/bootstrap.inc on line 571 Warning: Cannot modify header information - headers already sent by (output started at /home/mysitec/public_html/includes/database.mysql.inc:174) in /home/mysitec/public_html/includes/bootstrap.inc on line 572 I went in the db and emptied accesslog, watchdog and all the cache_X tables. That allowed me to log in but the first page I saw, this was at the top: * warning: Cannot modify header information - headers already sent by (output started at /home/mysite/public_html/includes/database.mysql.inc:174) in /home/mysite/public_html/includes/common.inc on line 141. * warning: Cannot modify header information - headers already sent by (output started at /home/mysite/public_html/includes/database.mysql.inc:174) in /home/mysite/public_html/includes/session.inc on line 96. * warning: session_regenerate_id() [function.session-regenerate-id]: Cannot regenerate session id - headers already sent in /home/mysitec/public_html/includes/session.inc on line 99. * warning: Cannot modify header information - headers already sent by (output started at /home/mysite/public_html/includes/database.mysql.inc:174) in /home/mysite/public_html/includes/common.inc on line 141. * warning: Cannot modify header information - headers already sent by (output started at /home/mysite/public_html/includes/database.mysql.inc:174) in /home/mysite/public_html/includes/common.inc on line 141. the site is 5.16 and I was on it this afternoon and all was fine. It seems OK now, but I'm aware that there is a problem and want to get to the bottom of it. Any clues as to what this could be? Interpreting Drupal error messages was never my particular strong point. :-) any help appreciated regards Neil ------------------------------------------------------------------------
-- [ Drupal support list | http://lists.drupal.org/ ] -- [ Drupal support list | http://lists.drupal.org/ ]