Help I get an error when editing
Permalink
I log into my church's site that I am building and this is the error I get:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1016: Can't open file: 'CollectionVersionBlocks.MYI' (errno: 145)] in EXECUTE("select bID, arHandle from CollectionVersionBlocks where cID = '1' and cvID = '60'") ' in /all_else/messiah/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /all_else/messiah/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1016, 'Can't open file...', 'select bID, arH...', false, Object(ADODB_mysql)) #1 /all_else/messiah/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('select bID, arH...') #2 [internal function]: ADOConnection->Execute('select bID, arH...', Array) #3 /all_else/messiah/concrete/libraries/database.php(73): call_user_func_array(Array, Array) #4 [internal function]: Database->__call('Execute', Array) #5 /all_else/messiah/concrete/libraries/database_indexed_search.php(151): Database->Execute('select bID, arH...', Array) #6 /all_else/messiah/concrete/libraries/da in /all_else/messiah/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
What's going on and how do I fix it?
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1016: Can't open file: 'CollectionVersionBlocks.MYI' (errno: 145)] in EXECUTE("select bID, arHandle from CollectionVersionBlocks where cID = '1' and cvID = '60'") ' in /all_else/messiah/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /all_else/messiah/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1016, 'Can't open file...', 'select bID, arH...', false, Object(ADODB_mysql)) #1 /all_else/messiah/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('select bID, arH...') #2 [internal function]: ADOConnection->Execute('select bID, arH...', Array) #3 /all_else/messiah/concrete/libraries/database.php(73): call_user_func_array(Array, Array) #4 [internal function]: Database->__call('Execute', Array) #5 /all_else/messiah/concrete/libraries/database_indexed_search.php(151): Database->Execute('select bID, arH...', Array) #6 /all_else/messiah/concrete/libraries/da in /all_else/messiah/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
What's going on and how do I fix it?
Worth noting that one common cause of corrupt MySQL tables is the disk being full. Check you haven't run out of space...
Jon
Jon
Thanks, I will look into that.
I have looked around myphpadmin. I don't see anywhere that indicates disk usage/allowance. how do I find that? I have taken a crack at repairing the tables, and they do. But, I get the same errors happening and am thinking it is a space issue. Thanks for your help.
Ran database repair through my Host. That worked. Thanks
Cool - glad it worked out :)
For reference, the space issues I was referring to, you would need to either check from a terminal session, or ask your hosting provider if you don't have access.
Some hosting control panels will also tell you how much space you have left on disks, but it's not really a phpMyAdmin thing...
Jon
For reference, the space issues I was referring to, you would need to either check from a terminal session, or ask your hosting provider if you don't have access.
Some hosting control panels will also tell you how much space you have left on disks, but it's not really a phpMyAdmin thing...
Jon
To fix it, log into MySQL from the commandline, or via phpMyAdmin and try repairing the table.
REPAIR TABLE CollectionVersionBlocks;More info:
Repair table syntax:
http://dev.mysql.com/doc/refman/5.0/en/repair-table.html...
MySQL Manual on Corrupted MyISAM Tables:
http://dev.mysql.com/doc/refman/5.0/en/corrupted-myisam-tables.html...
Hope that helps...
Jon