By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,913 Members | 1,274 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,913 IT Pros & Developers. It's quick & easy.

what does sql error 1040 mean?

P: n/a
SQL ERROR [ mysqli ]

I was trying to enter one of my favorite sites, but when i clicked on the link, this error kept showing up on my screen. It also said "too many connections." Why does this keep happening?
Nov 5 '10 #1
Share this Question
Share on Google+
1 Reply


P: 9
too many connections. Are multiple connections allowed for what you are doing? It could be your hosting service or maybe the way you have permissions set up. make sure you close the connection (mysql_close('database')) when done, make sure you can read, write and execute by checking with your host, and make sure that you are not on an awful shared host. This will help to clean up connections.$result = mysql_query("SHOW FULL PROCESSLIST");
while ($row=mysql_fetch_array($result)) {
$process_id=$row["Id"];
if ($row["Time"] > 200 ) {
$sql="KILL $process_id";
mysql_query($sql);
}
}
Nov 5 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.