Advertisement:

Author Topic: SMF could not connect to the database (No noticeable issues)  (Read 424 times)

Offline showngo

  • Jr. Member
  • **
  • Posts: 195
SMF could not connect to the database (No noticeable issues)
« on: February 08, 2021, 06:44:20 PM »
About once a day or every other day I get a webmaster email that SMF could not connect to the database. There are zero http500 errors and no noticeable spinning wheels of death loading.
The correct info is in the server section. The correct info is in the Settings.php and there is no visible/noticeable downtime.  (Members are on 24/7)
The SMF Error log shows nothing around the times I get the notifications.

Is this just a glitch to not worry about?   SMF 2.0.17 AND now 2.0.18 (No errors updating to 18)

Installed mods

1.   Simple Audio Video Embedder   6.0.1    
2.   Resize Attached Images   2.4.1    
3.   AdditionalMembergroups   1.04
4.   Anti-spam by CleanTalk   2.31
5.   SimplePortal   2.3.7    
6.   SMF 2.0.18 Update   0.1.0    
7.   Recent Forum Topics Boardindex   1.2    
8.   WYSIWYG Quick Reply   2.3


Offline shadav

  • Support Specialist
  • Sophist Member
  • *
  • Posts: 1,352
  • Gender: Female
    • shadav on Facebook
    • leashadav on GitHub
    • Ask The Muslims: A Place To Ask Honest Questions and Receive Respectful Answers
Re: SMF could not connect to the database (No noticeable issues)
« Reply #1 on: February 08, 2021, 07:39:24 PM »
I had the same issue only a lot more often....it was my crappy host
something wrong with their server....

if possible, switch hosts, if not ask the host to move you to another server and see if that helps.

Offline showngo

  • Jr. Member
  • **
  • Posts: 195
Re: SMF could not connect to the database (No noticeable issues)
« Reply #2 on: February 08, 2021, 07:50:00 PM »
I had the same issue only a lot more often....it was my crappy host
something wrong with their server....

if possible, switch hosts, if not ask the host to move you to another server and see if that helps.

I'll ask them.    Wasn't sure if it was anything with a scheduled task.   I know we do not receive "approval notifications" but it was checked.   I'm still trying to link the times to any events.

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,976
  • We were all equal in the end.
Re: SMF could not connect to the database (No noticeable issues)
« Reply #3 on: February 08, 2021, 08:05:58 PM »
I had the same issue only a lot more often....it was my crappy host
something wrong with their server....

if possible, switch hosts, if not ask the host to move you to another server and see if that helps.

 ^ This.  The connect errors are random, caused by server being overloaded or poorly configured.  You won't see them on a decent host.
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

Offline showngo

  • Jr. Member
  • **
  • Posts: 195
Re: SMF could not connect to the database (No noticeable issues)
« Reply #4 on: February 23, 2021, 05:30:04 AM »
With nothing being noticeable, I just turned off the notification for not connecting to the database in the Admin section.

Offline TheDragon

  • Sr. Member
  • ****
  • Posts: 833
Re: SMF could not connect to the database (No noticeable issues)
« Reply #5 on: February 23, 2021, 10:40:07 AM »
I had the same issue after host upgraded to PHP 7.4
but not on occasion - was permanent
NOTHING would fix it
the only solution was to install a fresh version of SMS 2.0.18
and then import old SQL
(changing hosts is not easy - as i have MANY sites there)