Re: MySQL error reporting

Paul Furman wrote:
Jerry Stuckle wrote:
Paul Furman wrote:
Jerry Stuckle wrote:
Paul Furman wrote:

How do I turn off MySQL error reporting? I set error_reporting(0); but that doesn't seem to be working.

That turns off PHP error reporting.

What problem are you having?

Sorry for the slow reply. Any SQL error appears on the screen, and sometimes that includes info I don't want included. Hmm, now that I think of it that may be a built in error reporting system (I didn't write all of this system). In any case is this a risk and is there a way of turning it off? The worst case I recall was something like:

ERROR: unable to connect to the sever using user 'admin' and password 'mysectretpassword'

Ha ha, I made that up as I don't recall that one but I don't want anything like that to happen again!

Preface the mysql_connect() call with an '@' character, i.e.

@mysql_connect(....);

This suppresses any error message for this function. Just be sure to check the response.

Excellent, thank you!!!

Hmm, well I thought that was working but maybe just on the live server not my home test version. Anyways I have a related question. Now I do want to show at least part of the error, to prevent duplicate login names, I set the 'unique' key on that field and tested, the test came back like this *first section in red I'd like to show* the next part I'd rather not:

--
*ERROR: Duplicate entry 'paul' for key 2* - INSERT INTO customer VALUES (0, 'paul','paul', '', 'paul', 'p', '', '', '', 'CA', '', '', '2007-04-24', 'no', '0', 'n', 'n', 'n' )

Thank you! Your registration has been completed!
--

And of course I'd want at a minimum to be able to note the error & suppress my "thank you" message afterwards. That bit of code is simply:

query($query);
print "<p>Thank you! Your registration has been completed!</p>\n";

more like this:

query($query);
if (!$error){
print "<p>Thank you! Your registration has been completed!</p>\n";
}

Thanks for any ideas!

Paul



.

Relevant Pages

  • Re: MySQL error reporting
    ... This suppresses any error message for this function. ... well I thought that was working but maybe just on the live server not my home test version. ... Error code 1062 is a duplicate entry error. ...
    (comp.lang.php)
  • Re: access 97 to 2000
    ... Access database. ... > conversion does not change the original file. ... I recall that after ... I do not recall the exact wording of the error message, ...
    (microsoft.public.office.misc)
  • Re: OT: my new PC rocks!!
    ... That error message sounds familiar, but I can't recall what was causing ... > I then used the fallback makefile for unix, ... HINSTANCE TYPEDEF DWORD ...
    (alt.lang.asm)
  • Re: Login from Invalid worksation message ?
    ... I can not recall ever seeing that ... particular error message either. ... > assignments for log on ... as entries there will override the ...
    (microsoft.public.win2000.security)
  • Re: system restarts
    ... image file to this PC? ... I seem to recall it may also be a registry setting ... > when loading using the debugging option i get the dreaded blue screen ... > staying up on the screen and the error message "session 3 initialization ...
    (microsoft.public.windowsxp.help_and_support)