There are some scripts that help us to save logs,
For example: log4php
You write your app and when you're testing it you define a level to save the
errors into a file and display them in your app but in production the client
doesn't have to see the errors, only the developers, so, in your log4php
define that only write the errors into a log file. This is a easy way to
control the errors logs, without re-write your scripts, for example:
Testing: Mysql_query($sql) or die(mysql_error()." $sql");
Production: Mysql_query($sql) or die(saveLog(mysql_error()." $sql"));
De: Subscriptions [mailto:subscriptions@stripped]
Enviado el: Viernes, 10 de Marzo de 2006 10:27 a.m.
Asunto: Re: How to Log Warnings and Errors from queries
In PHP, you can see the error message as follows:
$result = mysql_query($sSQL) or die ("<br>".mysql_error()
Just change it to write that mysql_error() to a file instead and that'll do
it. So, something like:
$result = mysql_query($sSQL) or die ( log_error(mysql_error()) );
where you create that function log_error to write to a file.
----- Original Message -----
From: "Kishore Jalleda" <kjalleda@stripped>
To: "ryan lwf" <ryanlwf@stripped>
Cc: "Dan Nelson" <dnelson@stripped>; <mysql@stripped>
Sent: Friday, March 10, 2006 10:03 AM
Subject: Re: How to Log Warnings and Errors from queries
as you know mysql gives you an error to check your sql syntax when it
doesn't understand a query but does not log it , but you can have your
application (php, perl, etc ) accessing mysql to log any bad/malformed
On 3/10/06, ryan lwf <ryanlwf@stripped> wrote:
> Hi Dan,
> Noted with thanks.
> As such, is there a workaround to log problematic sql queries ran
> against the mysqld server ? Do I need to write separate script to do
> this ?
> On 3/10/06, Dan Nelson <dnelson@stripped> wrote:
> > In the last episode (Mar 08), ryan lwf said:
> > > I understand that the option log-errors and log-warnings only logs
> > > server related internal errors. How do I enable logging errors
> > > from queries executed, so that I can fix the problematic query
> > > statement accordingly?
> > >
> > > The statement "SHOW WARNINGS" and "SHOW ERRORS" does not work on
> > > my server with mysqld-4.0.25 binary version.
> > Those commands appeared in MySQL 4.1. Before then, warnings were
> > simply counted.
> > --
> > Dan Nelson
> > dnelson@stripped
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1