Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Aiheen aloitti: igweb - helmikuu 13, 2010, 07:35:55 IP

Otsikko: Database Error - Got error 127 from storage engine
Kirjoitti: igweb - helmikuu 13, 2010, 07:35:55 IP
Hi everyone,

My SMF database/forum has fallen over.

1. Members are no longe able to post;
The following error or errors occurred while posting this message:
Your session timed out while posting. Please try to re-submit your message.

2. Global Moderators can no longer access Admin
An Error Has Occurred!
Session verification failed. Please try logging out and back in again, and then try again.

Database Error
Got error 127 from storage engine
File: /home2/impulse/public_html/forum/Sources/Load.php
Line: 2020

Before this happened, received three e-mails from SMF database saying;

SMF has detected and automatically tried to repair an error in your database.  If you continue to have problems, or continue to receive these emails, please contact your host.

So I ran the repairs sections of ADMIN but now no one can post, nor I can access admin. I even tried to run the upgrade.php as some files said 1.10 to go to 1.11 but now nothing works?

Any ideas?
Otsikko: Re: Database Error - Got error 127 from storage engine
Kirjoitti: igweb - helmikuu 13, 2010, 07:51:26 IP
I just tried to repair the database through ControlPanel and got;


Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home2/impulse/public_html/forum/Sources/Subs.php on line 321

Warning: Cannot modify header information - headers already sent by (output started at /home2/impulse/public_html/forum/Sources/Subs.php:321) in /home2/impulse/public_html/forum/Sources/Subs-Auth.php on line 346

Warning: Cannot modify header information - headers already sent by (output started at /home2/impulse/public_html/forum/Sources/Subs.php:321) in /home2/impulse/public_html/forum/Sources/Subs-Auth.php on line 347

Warning: Cannot modify header information - headers already sent by (output started at /home2/impulse/public_html/forum/Sources/Subs.php:321) in /home2/impulse/public_html/forum/Sources/Subs-Auth.php on line 348
Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

Now, I cant access my forums at all :(

This all happened when a site from China hacked in and put some malicious code into index.php. Once I deleted it, this seemed to occur.

Any help would be appreciated.
Otsikko: Re: Database Error - Got error 127 from storage engine
Kirjoitti: Kenny01 - helmikuu 14, 2010, 08:47:53 AP
Roll back to your last backups if you have one or contact your host for there backups.
Otsikko: Re: Database Error - Got error 127 from storage engine
Kirjoitti: igweb - helmikuu 14, 2010, 03:20:56 IP
Thanks Kenny, before I tried that, I managed to repair the database in Control Panel and it worked. Not sure why this happened?
Otsikko: Re: Database Error - Got error 127 from storage engine
Kirjoitti: Kenny01 - helmikuu 14, 2010, 04:03:04 IP
Good it's solved, mark the topic solved.
Otsikko: Re: Database Error - Got error 127 from storage engine
Kirjoitti: emreunan - syyskuu 05, 2011, 04:40:33 IP
Lainaus käyttäjältä: igweb - helmikuu 13, 2010, 07:51:26 IP
I just tried to repair the database through ControlPanel and got;


Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home2/impulse/public_html/forum/Sources/Subs.php on line 321

Warning: Cannot modify header information - headers already sent by (output started at /home2/impulse/public_html/forum/Sources/Subs.php:321) in /home2/impulse/public_html/forum/Sources/Subs-Auth.php on line 346

Warning: Cannot modify header information - headers already sent by (output started at /home2/impulse/public_html/forum/Sources/Subs.php:321) in /home2/impulse/public_html/forum/Sources/Subs-Auth.php on line 347

Warning: Cannot modify header information - headers already sent by (output started at /home2/impulse/public_html/forum/Sources/Subs.php:321) in /home2/impulse/public_html/forum/Sources/Subs-Auth.php on line 348
Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

Now, I cant access my forums at all :(

This all happened when a site from China hacked in and put some malicious code into index.php. Once I deleted it, this seemed to occur.

Any help would be appreciated.

Same problem, how can i solve
Otsikko: Re: Database Error - Got error 127 from storage engine
Kirjoitti: Illori - syyskuu 05, 2011, 05:05:01 IP
please open a separate thread for your issue, this thread belongs to someone else and is marked solved.