what does sql error 1040 mean?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Danielle Pollet

    #1

    what does sql error 1040 mean?

    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?
  • Scott Evans
    New Member
    • Nov 2010
    • 9

    #2
    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('d atabase')) 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.$re sult = mysql_query("SH OW FULL PROCESSLIST");
    while ($row=mysql_fet ch_array($resul t)) {
    $process_id=$ro w["Id"];
    if ($row["Time"] > 200 ) {
    $sql="KILL $process_id";
    mysql_query($sq l);
    }
    }

    Comment

    Working...