General Error(!)

PHP: Select all

Return to index page 

General Error

SQL ERROR [ mysql4 ]



Too many connections [1040]



An sql error occurred while fetching this page. Please contact an administrator if this problem persists. 

How do I counter this?

You could try checking the number of connections allowed in my.ini
you should see a section of text like this

HTML: Select all

# The maximum amount of concurrent sessions the MySQL server will
# allow. One of these connections will be reserved for a user with
# SUPER privileges to allow the administrator to login even if the
# connection limit has been reached.
max_connections=100

set max connections to 500 or whatever.

This may not cure it but give it a try

Well, I think the error is obvious.

There are too many connections to the databank at once. There are a few things you can do about it:

1. Make sure you only leave databank connections open as long as you need them

PHP: Select all

$connection = mysql_connect("localhost", "root", "") or die ("Could not connect!");
mysql_select_db("db_name", $connection) or die ("Database not found!"); 

do stuff and as soon as you are done:

PHP: Select all

mysql_close($connection); 

2. The second thing you can do is having proper error handling. This doesn't solve your problem but at least you can catch errors and output a nice friendly error message (i.e.: "Server overloaded. Please try again in a few seconds") to the user.
Check all your databank queries for errors like so:

PHP: Select all

if(mysql_query("INSERT INTO table_name (text) VALUES ('some text')")) {
  echo("success");
} else {
  echo("error");
} 

or like so:

PHP: Select all

$query=mysql_query("SELECT * FROM ".$table_name." ORDER BY date DESC");
if($row=mysql_fetch_object($query)) {
  // do something
} else {
  echo("error");
} 

Hope that helps....

And in English?

OK, which part do you need translated?

As I don't know one end of MySQL from the other - er.. Everything?

OK, I'm not sure if I understand everything good enough to give a proper explanation, but I'll give it a shot

1. mySQL connections.

PHP: Select all

$connection = mysql_connect("localhost", "root", "") or die ("Could not connect!"); 

In this line you are storing a mysql_connection resource in the $connection variable. The first parameter is the server name, the second is your username and the third, your password. The 'or die' part catches any errors that could occur while trying to connect to the server (for example: the server is down, or your username and/or password is wrong). The 'die' means that PHP execution stops right there and the page outputs the error. I'd guess that this is the place where you are getting your error.

PHP: Select all

 mysql_select_db("db_name", $connection) or die ("Database not found!"); 

Here we select the database that we are going to be reading from. The first parameter is the database name and the second is the mysql_connection resource that we generated in the line above. Again, you can see the 'or die' to catch possible errors.

2. Error handling (catching errors and dealing with them yourself instead of the user getting a cryptic message).

PHP: Select all

if(mysql_query("INSERT INTO table_name (text) VALUES ('some text')")) {
  echo("success");
} else {
  echo("error");
} 

I think you would know how an IF statement works.... The mysql_query function sends a query to the currently-opened database and returns a resource. However, when the query fails, it returns false, and that is the kind of thing that you can catch and deal with yourself.

PHP: Select all

$query=mysql_query("SELECT * FROM table_name");
if($row=mysql_fetch_object($query)) {
  // do something
} else {
  echo("error");
} 

This is similar to the previous example, only that we store the returned resource into a variable and check if that operation was a success.

3. Closing the connection.

PHP: Select all

mysql_close($connection); 

This is the important part. The mysql_close function takes a connection resource as parameter and tells the database that we are done and closes the connection. This means that there is now one more connection available for use. Most database queries only take a few milliseconds, so an error like this only rarely occurs, and if you refresh the page a couple seconds later, the problem will already be solved.

OK, I hope that clarifies a few things.
That was my good deed for the day....

Did I mention the site is a forum?

what are your max connections settings with your host. Could it have just been a glitch at there end.