Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: lindaf on March 24, 2011, 12:09:20 PM

Title: upgraded to 1.1.13 now get database error 69
Post by: lindaf on March 24, 2011, 12:09:20 PM
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

Title: Re: upgraded to 1.1.13 now get database error 69
Post by: Illori on March 24, 2011, 12:12:40 PM
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.
Title: Re: upgraded to 1.1.13 now get database error 69
Post by: Arantor on March 24, 2011, 12:14:35 PM
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:
REPAIR TABLE smf_log_notify; and run that. See what happens.
Title: Re: upgraded to 1.1.13 now get database error 69
Post by: lindaf on March 24, 2011, 12:21:11 PM
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)

--------------------------------------------------------------------------------
Title: Re: upgraded to 1.1.13 now get database error 69
Post by: Arantor on March 24, 2011, 12:25:42 PM
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.
Title: Re: upgraded to 1.1.13 now get database error 69
Post by: lindaf on March 24, 2011, 12:33:13 PM
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.
Title: Re: upgraded to 1.1.13 now get database error 69
Post by: redone on March 24, 2011, 01:26:48 PM
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
Title: Re: upgraded to 1.1.13 now get database error 69
Post by: lindaf on March 24, 2011, 04:58:05 PM
don't have cpanel, but my isp fixed it!! yea! :)