upgraded to 1.1.13 now get database error 69

[lindaf]

i upgraded to 1.1.13 as recommended in admin panel.  now can't post when trying to post get this error:

Database Error: Got error 69 from table handler
File: /usr/home/adsg/public_html/forum/Sources/Post.php
Line: 1993

i tried to delete some members that were spammers and got this msg:

Database Error: Got error 69 from table handler
File: /usr/home/adsg/public_html/forum/Sources/Subs.php
Line: 2980

oh wow.. now I can't even go into any board.. if I click on a board I get this msg:

Database Error: Can't open file: 'smf_log_notify.MYD'. (errno: 145)
File: /usr/home/adsg/public_html/forum/Sources/MessageIndex.php
Line: 127

[Illori]

sounds like an issue for your host to look into, could be a problem with your database or an issue with running out of hard drive space for the database.

[Arantor]

No, error 28 is out of space. Error 145 is table corruption.

First, let's fix that. You'll need access to phpMyAdmin. Go into the database, hit the SQL tab and type in:

Code Select Expand

REPAIR TABLE smf_log_notify; and run that. See what happens.

[lindaf]

when i clicked to go into db I got this error:

SQL show index from `smf_log_actions` failed : Can't open file: 'smf_log_actions.MYD'. (errno: 145)

--------------------------------------------------------------------------------

[Arantor]

You should be able to get to the SQL tab from there though.

In addition to REPAIR TABLE smf_log_notify, also REPAIR TABLE smf_log_actions;

Though I'd be talking to the host about their backups about now... the tables are damaged.

[lindaf]

it won't let me do anything but return to previous page.  if I go into another db i have the option of executing sql, but not in the damaged one.. only displays the error msg with no options..  oh boy..

so sounds like I need to get ahold of my isp then eh.

[redone]

If you have cpanel and you usually do the repair function by selecting the MySQL database, pick the one you have issues with and selecting the repair drop down.

~RedOne

[lindaf]

don't have cpanel, but my isp fixed it!! yea!