• Welcome to Simple Machines Community Forum. Please login or sign up.
January 17, 2022, 12:24:56 PM

News:

SMF 2.0.19 has been released! Please update. Read more.


There has been a problem with the database!

Started by lather, December 06, 2021, 08:46:21 PM

Previous topic - Next topic

lather

I received an email from my 2.0.18 forum:

There has been a problem with the database!

This is a notice email to let you know that SMF could not connect to the database, contact your host if this continues.

When I checked the forum all was well and there were no forum or server errors in  the forum folder.
The Word Press folder did have errors in the log:
PHP Warning:  mysqli_query(): MySQL server has gone away in /home/ridemsta1/public_html/wp-includes/wp-db.php on line 2056

Both the forum message and the error were dated 12/4/21 no more since then. The Word Press site seems fine.


Sir Osis of Liver

Database connect errors are common on some hosts, not really a problem unless they occur frequently.  Usually caused by overloaded server. 
"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

Aleksi "Lex" Kilpinen

If it happens once or twice, no problem - That's bound to happen at some point.
If it starts happening more frequently, then you've probably got an issue somewhere.
A Finnish Project Manager (Support Specialist)
 Happily running multiple SMF 2.x installations.
  Fooling around with i7-10700 @ 2,90GHz-4.80GHz / 16Gb / RTX-2070 Super / 3840x2160 / Win 10 x64


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

shadav

Quote from: Aleksi "Lex" Kilpinen on December 07, 2021, 07:00:38 AMIf it happens once or twice, no problem - That's bound to happen at some point.
If it starts happening more frequently, then you've probably got an issue somewhere.

or on an over sold shared host and need to find a better host ;)

but yeah it's gonna happen sometimes there's a hiccup in the server...but if like my last host that it kept happening like every 30 minutes, na it was time to find a new host

Doug Heffernan

Quote from: shadav on December 07, 2021, 04:27:47 PM
Quote from: Aleksi "Lex" Kilpinen on December 07, 2021, 07:00:38 AMIf it happens once or twice, no problem - That's bound to happen at some point.
If it starts happening more frequently, then you've probably got an issue somewhere.

or on an over sold shared host and need to find a better host ;)

but yeah it's gonna happen sometimes there's a hiccup in the server...but if like my last host that it kept happening like every 30 minutes, na it was time to find a new host

Was your previous host GoDaddy by any chance btw?

shadav

Quote from: Doug Heffernan on December 07, 2021, 04:51:11 PM
Quote from: shadav on December 07, 2021, 04:27:47 PM
Quote from: Aleksi "Lex" Kilpinen on December 07, 2021, 07:00:38 AMIf it happens once or twice, no problem - That's bound to happen at some point.
If it starts happening more frequently, then you've probably got an issue somewhere.

or on an over sold shared host and need to find a better host ;)

but yeah it's gonna happen sometimes there's a hiccup in the server...but if like my last host that it kept happening like every 30 minutes, na it was time to find a new host

Was your previous host GoDaddy by any chance btw?
:laugh:  :laugh:  :laugh:  :laugh: *#&%*#*# NO!  :laugh:  :laugh:  :laugh:  :laugh:
I learned over a decade ago to stay as far away from them as possible through other peoples experiences

lather

Thanks for the replies. There has only been the one instance so far. The forum is hosted by Godaddy. We are coming up on the end of our 5 year subscription and I am considering a move. However we have really had very few problems.


Aleksi "Lex" Kilpinen

You can really count yourself lucky, 5 years on GoDaddy is an achievement on it's own.
A Finnish Project Manager (Support Specialist)
 Happily running multiple SMF 2.x installations.
  Fooling around with i7-10700 @ 2,90GHz-4.80GHz / 16Gb / RTX-2070 Super / 3840x2160 / Win 10 x64


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

lather

I logged into our forum servers phpMyAdmin yesterday and discovered that backup tables have been created for all of the SMF tables in out forum database. I assume this is related to the recent database problem  Should I delete  them or just leave them?

Aleksi "Lex" Kilpinen

Backup tables are usually created only when upgrading. If everything is working correctly and you are sure you don't need them anymore, it should be safe to delete them.
A Finnish Project Manager (Support Specialist)
 Happily running multiple SMF 2.x installations.
  Fooling around with i7-10700 @ 2,90GHz-4.80GHz / 16Gb / RTX-2070 Super / 3840x2160 / Win 10 x64


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

lather


Advertisement: