Customizing SMF > SMF Coding Discussion

Getting the following error...

(1/2) > >>

damo1065:
I've had no problems with my site and forums till about half an hour ago. When I got the following message on my site


--- Code: ---Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/thegaf2/public_html/forum/SSI.php on line 60
--- End code ---

And when I go to my forums....


--- Code: ---Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.
--- End code ---

I haven't done anything to the site, they just happened a few minutes ago - anyone know what all this means?

Chris Cromer:
It's having problems connecting to the database. Either your username, password, or server info is set wrong in Settings.php.

damo1065:

--- Quote from: Chris Cromer on July 28, 2004, 01:01:29 AM ---It's having problems connecting to the database. Either your username, password, or server info is set wrong in Settings.php.

--- End quote ---

But I haven't changed anything over the last while....I'll check the Settings.php to see...

damo1065:
Ah but sur...take a look at this. I went into my cpanel to see what was going on and this os what I found for my database name

DBI connect('mysql:localhost','root',...) failed: Too many connections at /usr/local/cpanel/Cpanel/Mysql.pm line 42

Also under Service Status
Server Load has a Red Light and 4.33 (1 cpu)

What in the name of beejesus does all this mean?

(BTW Thanks for the help...a wee bit simple y'see)

Chris Cromer:
It looks like too many connections to mysql are opened currently. By any chance did you recently turn on persistent mysql connections in smf?

Anyway open up Settings.php and look for this:

--- Code: ---$db_persist = 1;
--- End code ---
then replace it with this:

--- Code: ---$db_persist = 0;
--- End code ---

That should hopefully fix it.

Navigation

[0] Message Index

[#] Next page