SitePoint Sponsor |
|
User Tag List
Results 1 to 1 of 1
Thread: MySQL Error : Connection Error
-
May 8, 2001, 05:11 #1
- Join Date
- Nov 2000
- Location
- Ontario, Canada
- Posts
- 89
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
MySQL Error : Connection Error
I don't seem to be having a great deal of luck with a particular site that I'm working on. The latest problem is that the Guest Book (Advanced Guestbook 1.0) has suddenly decided to die! I was alerted to the problem by an automated email generated by the script. The error that it is saying is MySQL Error : Connection Error. When I actually visit the page the error that is produced is as follows,
Warning: Too many connections in /export/home/atlantic/www/guestbook/include/mysql.inc.php on line 8
Connection Error
--------------------------------------------------------------------------------
MySQL Error : Connection Error
Error Number:
Date : Tue, May 8, 2001 07:41:50
IP : hidden for security reasons
Browser : Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
Referer :
PHP Code:<?php
class db_sql {
var $conn_id, $result, $record;
function connect ($host,$user,$pwd,$dbname) {
$this->conn_id = mysql_pconnect($host,$user,$pwd);
if ($this->conn_id == 0) {
$this->sql_error("Connection Error");
}
if (!mysql_select_db($dbname, $this->conn_id)) {
$this->sql_error("Select DB Error");
}
return $this->conn_id;
}
function query($query_string) {
$this->result = mysql_query($query_string,$this->conn_id);
if (!$this->result) {
$this->sql_error("Query Error");
}
return $this->result;
}
function fetch_array($query_id) {
$this->record = mysql_fetch_array($query_id,MYSQL_ASSOC);
return $this->record;
}
function free_result($query_id) {
return mysql_free_result($query_id);
}
function sql_error($message) {
global $admin_mail,$sql_hostname;
$description = mysql_error();
$number = mysql_errno();
$error ="MySQL Error : $message\n";
$error.="Error Number: $number $description\n";
$error.="Date : ".date("D, F j, Y H:i:s")."\n";
$error.="IP : ".getenv("REMOTE_ADDR")."\n";
$error.="Browser : ".getenv("HTTP_USER_AGENT")."\n";
$error.="Referer : ".getenv("HTTP_REFERER")."\n";
echo "<b><font size=4 face=Arial>$message</font></b><hr>";
echo "<pre>$error</pre>";
@mail("$admin_mail","Guestbook - Error","$error","From: guestbook@$sql_hostname\nX-Mailer: Advanced Guestbook");
exit();
}
}
?>
At the moment due to time constraints, my knowledge of PHP/MySQL is very much on a need to know basis.
If anyone could elaborated on the above then I would be very grateful.
Many Thanks,
UPDATE: D'oh!Just noticed that it's not just the guestbook script thats suffering. ALL of the scripts that I use, that access MySQL are suffering from the same errors. Time to contact support me thinks.
Last edited by Chip D; May 8, 2001 at 05:17.
Chip D
----------------------------------------------------
Chances are what I think I'm typing is nothing like what I type.
Bookmarks