From 0e381b3d001c49d15fb8bf23af5f91fdda26e87b Mon Sep 17 00:00:00 2001 From: tbrehm <t.brehm@ispconfig.org> Date: Tue, 17 Mar 2009 07:23:39 -0400 Subject: [PATCH] Improved mysql error logging. --- server/lib/classes/db_mysql.inc.php | 18 ++++++++++-------- 1 files changed, 10 insertions(+), 8 deletions(-) diff --git a/server/lib/classes/db_mysql.inc.php b/server/lib/classes/db_mysql.inc.php index 828bb43..672de7f 100644 --- a/server/lib/classes/db_mysql.inc.php +++ b/server/lib/classes/db_mysql.inc.php @@ -41,7 +41,7 @@ var $errorNumber = 0; // last error number var $errorMessage = ""; // last error message var $errorLocation = "";// last error location - var $show_error_messages = false; + var $show_error_messages = true; // constructor function db() @@ -58,13 +58,15 @@ // error handler function updateError($location) { + global $app; $this->errorNumber = mysql_errno(); $this->errorMessage = mysql_error(); $this->errorLocation = $location; - if($this->errorNumber && $this->show_error_messages) + if($this->errorNumber && $this->show_error_messages && method_exists($app,'log')) { - echo('<br /><b>'.$this->errorLocation.'</b><br />'.$this->errorMessage); - flush(); + // echo('<br /><b>'.$this->errorLocation.'</b><br />'.$this->errorMessage); + $app->log($this->errorLocation." ".$this->errorMessage,LOGLEVEL_WARN); + //flush(); } } @@ -75,7 +77,7 @@ $this->linkId = mysql_connect($this->dbHost, $this->dbUser, $this->dbPass); if(!$this->linkId) { - $this->updateError('DB::connect()<br />mysql_connect'); + $this->updateError('DB::connect()-> mysql_connect'); return false; } } @@ -90,11 +92,11 @@ } if(!mysql_select_db($this->dbName, $this->linkId)) { - $this->updateError('DB::connect()<br />mysql_select_db'); + $this->updateError('DB::connect()-> mysql_select_db'); return false; } $this->queryId = @mysql_query($queryString, $this->linkId); - $this->updateError('DB::query('.$queryString.')<br />mysql_query'); + $this->updateError('DB::query('.$queryString.') -> mysql_query'); if(!$this->queryId) { return false; @@ -132,7 +134,7 @@ function nextRecord() { $this->record = mysql_fetch_assoc($this->queryId); - $this->updateError('DB::nextRecord()<br />mysql_fetch_array'); + $this->updateError('DB::nextRecord()-> mysql_fetch_array'); if(!$this->record || !is_array($this->record)) { return false; -- Gitblit v1.9.1