FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Error
Show: Today's Messages :: Unread Messages :: Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Error [message #1148] Thu, 21 March 2002 16:38 Go to next message
DPitts18 is currently offline  DPitts18   United States
Messages: 32
Registered: March 2002
Karma: 0
Member
add to buddy list
ignore all messages by this user
I keep getting the following error when I try to view my page, what does it mean?

Warning: Too many connections in /home/sites/cgi.passionscentral.com/forum2/include/db.inc on line 26
Re: Error [message #1149 is a reply to message #1148] Thu, 21 March 2002 17:31 Go to previous messageGo to next message
Olliver   Germany
Messages: 443
Registered: March 2002
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Hi,
It probably means that ur server appears to have problems with persistant connections to SQL. U should edit ur GLOBALS.php to use just connect as method, that should solve the problem.

Look for the line where it says

$MYSQL_PERSIST = "Y";

and then turn it to

$MYSQL_PERSIST = "N";

Bye
Ken
Re: Error [message #1150 is a reply to message #1148] Thu, 21 March 2002 17:37 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Tell your host to set the timeout time on idle SQL connection to something like 5 minute (300 seconds).

And like Ken suggested, don't use persistant connection, because then each apache child will want a mysql socket for itself.


FUDforum Core Developer
Re: Error [message #1153 is a reply to message #1150] Thu, 21 March 2002 20:25 Go to previous messageGo to next message
DPitts18 is currently offline  DPitts18   United States
Messages: 32
Registered: March 2002
Karma: 0
Member
add to buddy list
ignore all messages by this user
prottoss wrote on Thu, 21 March 2002 5:37 PM

Tell your host to set the timeout time on idle SQL connection to something like 5 minute (300 seconds).

And like Ken suggested, don't use persistant connection, because then each apache child will want a mysql socket for itself.


Can you edit the GLOBALS.php file for me? I can not figure out how to edit it. I can give you all my info so you can do it.
Re: Error [message #1154 is a reply to message #1153] Thu, 21 March 2002 20:39 Go to previous message
Olliver   Germany
Messages: 443
Registered: March 2002
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Hello,
though it's often faster and easier to edit the GLOBALS.php directly, u can also change the setting via the admin controlpanel. U can find this item under the global settings -> SQL -> Use Persistent Connections from "yes" to "no". after that u just need to press the bottom right "set" button and u're done.
bye
Ken
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Upgrade script does not work
Next Topic: URL Avatar
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 25 06:35:35 EDT 2024

Total time taken to generate the page: 0.05740 seconds