By FatPitchFinancials on
I just finished upgrading the version of MySQL on my server from version 4.1 to 5.1. All the installations of Drupal on my VPS stopped working. I just get the following error:
Warning: Incorrect key file for table 'system'; try to repair it query: SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC in /home/vin/public_html/includes/database.mysql.inc on line 128
Warning: Cannot modify header information - headers already sent by (output started at /home/vin/public_html/includes/database.mysql.inc:128) in /home/vin/public_html/includes/bootstrap.inc on line 726
Warning: Cannot modify header information - headers already sent by (output started at /home/vin/public_html/includes/database.mysql.inc:128) in /home/vin/public_html/includes/bootstrap.inc on line 727
Warning: Cannot modify header information - headers already sent by (output started at /home/vin/public_html/includes/database.mysql.inc:128) in /home/vin/public_html/includes/bootstrap.inc on line 728
Warning: Cannot modify header information - headers already sent by (output started at /home/vin/public_html/includes/database.mysql.inc:128) in /home/vin/public_html/includes/bootstrap.inc on line 729
Fatal error: Call to undefined function user_access() in /home/vin/public_html/includes/theme.inc on line 1776
I opened up the database using phpMyAdmin and ran a Check DB. It reported errors so I ran Repair DB. I got the following errors:
cc.menu_links
Error : Incorrect key file for table 'menu_links'; try to repair it
error : Corrupt
cc.menu_router
Error : Incorrect key file for table 'menu_router'; try to repair it
error : Corrupt
cc.system
Error : Incorrect key file for table 'system'; try to repair it
error : Corrupt
cc.users
warning : Found row where the auto_increment column has the value 0
status : OK
How do I fix this? I'm starting to panic.
Comments
did u have any luck fixing this?
if so, please post your fixes! thanks!
Trying to fix myself
Hi,
I'm hunting down a MySQL 4.1 sever to attempt fixing this very issue myself. If either of you have had success please post (I have no backups only a long story).
I've found this blog post
http://www.mrbuckykat.com/mysql-4-1-to-5-1-upgrade-in-cpanel-corrupt-tab...
which mentions repairing the tables on a MySQL 4.1 server and brining them back to MySQL 5. I'll try it out and post my results one way or another.