greg185 Posted February 14, 2011 Share Posted February 14, 2011 An upgrade from mysql 4 > mysql 5 was performed as the forum is v3.1.4, server had php 5.2.8 and mysql 4, after the upgrade to mysql apache failed, this was resolved by cpanel (who also upgraded php), but the databases now all have tables in them with errors. myisamchk has been run on the tables with errors and despite it saying fixed, they still showed errors, forum was working, but then when I enabled a hook, we now have driver error, running myisamchk on the tables has done the same thing, says its fixed them but still show errors. sql_error_latest.cgi Log file shows: Date: Mon, 14 Feb 2011 16:23:33 +0000 Error: 1034 - Incorrect key file for table 'ibf_skin_templates'; try to repair it IP Address: 86.3.248.68 - /forum/ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT * FROM ibf_skin_templates WHERE template_master_key='root' ORDER BY template_group .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/sources/classes/skins/skinCaching.php | [skinFunctions].fetchTemplates | 352 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/classes/skins/skinCaching.php | [skinCaching].removeDeadPHPCaches | 168 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/classes/output/publicOutput.php | [skinCaching].rebuildPHPTemplates | 382 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsRegistry.php | [output].__construct | 564 | '- Is there a way to fix the tables or not? What me and the host company are trying atm is creating a new database and then importing an old backup. Link to comment Share on other sites More sharing options...
Cloaked Posted February 14, 2011 Share Posted February 14, 2011 Try mysqlcheck -r to repair the database. Also when upgrading to a major version of mysql, going from 4 to 5 it always advised to create a new db and import the dump from the old version. Link to comment Share on other sites More sharing options...
Volvospeed Posted February 15, 2011 Share Posted February 15, 2011 Had the same issue. Rebuild from XML fixed it. Link to comment Share on other sites More sharing options...
Gary. Posted February 15, 2011 Share Posted February 15, 2011 Its cause the mysql at that time could not read / update those tables, The easy way would be to download your database, And then re-import so on upload the tables are updated. Will take around 14 seconds to complete via SSH, Jobs done. Link to comment Share on other sites More sharing options...
greg185 Posted February 15, 2011 Author Share Posted February 15, 2011 Thanks for replies We successfully imported an old backup into a newly created database, only then for the config file causing error for the db user logging in, this turned out to be a problem with cpanel not holding the privilege settings, had to be done manually via command shell. Anyway, forum seems to work using a backup, but shortly after going 'live' replies could not be added to topics, and this was the same problem I had when the forums came back online after cpanel sorted apache etc.. with the 'old' database the one with corrupted tables, the new database shows no corrupted tables, but after another round of myisamchk on some tables (which found errors and fixed them), although myisamchk saying it's fixed errors can be taken with a pinch of salt I think, replies could be added again. What I am worried about now, is when I start adding hooks/modules will it break the forum/database again! Am waiting to hear back from IPS about that. Link to comment Share on other sites More sharing options...
Owdy Posted December 2, 2012 Share Posted December 2, 2012 Its cause the mysql at that time could not read / update those tables, The easy way would be to download your database, And then re-import so on upload the tables are updated. Will take around 14 seconds to complete via SSH, Jobs done. Can you give me commands to do that? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.