• Welcome to Simple Machines Community Forum. Please login or sign up.
October 24, 2021, 06:13:36 AM

News:

SMF 2.1 RC4 has been released! Try it out and help us test! :) Read more.


forum crashed, repair did not work, now server busy?

Started by Janet, October 16, 2016, 05:04:36 PM

Previous topic - Next topic

Janet

Hello,

Our forum runs on version  2.0.12 and suddenly received a message that the forum had crashed. It said it was marked as crashed and last repair failed.
We tried a repair at the host which did not take. We then logged in at phpmyadmin and repaired the log_online table (as was suggested in a different yet similar thread here). Now we get the message that the server is busy. Forum is still down. Now what do I do? Please help me.

Best,
Janet.

http://www.julieandrewsonline.com/2015/forum

Sir Osis of Liver

"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

Janet

My partner may have one. Is that the only way to solve this problem?  :-[

Sir Osis of Liver

You can try repairing all tables in phpmyadmin, but you're getting a connection error, which is odd.  Are your database credentials in Settings.php correct?
"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

Illori

have you contacted your host to see if they know what is going on? if not i would start there.

Janet

I will try to repair all the tables now. I don't know if the credentials are correct -- how can I tell? Sorry, not a specialist here as you might have noticed  :-[

Sir Osis of Liver

Quote from: Janet on October 16, 2016, 05:04:36 PM
We tried a repair at the host which did not take.

Did host do something to your db?
"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

Janet

Quote from: Sir Osis of Liver on October 16, 2016, 05:18:04 PM
Quote from: Janet on October 16, 2016, 05:04:36 PM
We tried a repair at the host which did not take.

Did host do something to your db?


Not that we are aware of. We always run our repairs there and it has always worked so far. Except this time.

Sir Osis of Liver

You need to confirm $db_server, $db_name, $db_user, $db_passwd in Settings.php.  That info should be in the mysql database section of your host control panel.  You can edit the file manually, or use repair_settings.php.

"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

Sir Osis of Liver

Quote from: Illori on October 16, 2016, 05:15:37 PM
have you contacted your host to see if they know what is going on? if not i would start there.

^  If nothing has changed, your db may be offline for some reason at host's end.
"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

Uhura!

:) Our Parenting Spot is an online parenting community for fathers, mothers, grandparents, teachers, and family service professionals. 8) We also provide low cost advertising options for authors, family service providers, and businesses with family friendly products and services. ;D Visit us @ www.OurParentingSpot.net!

Janet

Quote from: Sir Osis of Liver on October 16, 2016, 05:27:53 PM
Quote from: Illori on October 16, 2016, 05:15:37 PM
have you contacted your host to see if they know what is going on? if not i would start there.

^  If nothing has changed, your db may be offline for some reason at host's end.


I'll check this first then. Nothing has changed, no upgrade or anything. It happened out of the blue.  Although come to think of it, people did have troubles logging in for a while.

Quote from: Uhura! on October 16, 2016, 05:28:48 PM
I had to disable server load balancing...
I am so sorry but I don't know what that means...:(

Janet

Quote from: Sir Osis of Liver on October 16, 2016, 05:25:41 PM
You need to confirm $db_server, $db_name, $db_user, $db_passwd in Settings.php.  That info should be in the mysql database section of your host control panel.  You can edit the file manually, or use repair_settings.php.



Tried this. Did not work :( :(


Illori

then ask your host to help you. they should be able to verify the connection details are correct and there are no issues with the database server. if they are unable to help, i would start looking for a new more helpful host.

Janet

It worked now! Not sure why the settings had changed but now it works! Made a backup immediately. Thank you for your help!

Sir Osis of Liver

My host has the annoying habit of occasionally changing my account server address without notification.  It's supposed to be 'transparent' to the user, my domain addresses still work, but the forum internal urls do not, and have to be changed manually.  Your host may have changed server address of the database without telling you, which would cause db connection to fail until you fixed it.

The net works in mysterious ways.
"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

Advertisement: