Re: MySQL error reporting

Paul Furman wrote:
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




Paul,

Not as easy - and a little bit user unfriendly, also.

Rather - check the result of the @mysql_query() insert. If it is false, call mysql_errno() to get the error number.

Error code 1062 is a duplicate entry error. If you get that, the userid already exists. If you get something else, you have a different problem.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================
.

Relevant Pages

  • Re: MySQL error reporting
    ... now that I think of it that may be a built in error reporting system. ... 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: Windows Vista Update - Screen blank missing text
    ... If this is a non-Microsoft service, contact the service vendor and refer to service-specific error code -2147467243. ... This error message is similar to the "Error 5: ... The most likely cause for this is security software or malware that has modified said access perms. ... I'm suspicious that this program is the cause of the Windows Update ...
    (microsoft.public.windowsupdate)
  • Re: Hiding A Field
    ... Please respond only to this newsgroup. ... the error code says. ... Ok I plugged in the code you gave me and it gave me an error message. ... The expression may result in the name of a macro, ...
    (microsoft.public.access.formscoding)
  • Re: Office Stopped Working
    ... Then "run Microsoft Office diagnostics." ... I've never used this before, but saw a posting on another forum with a similar problem, same error code, this procedure was recommended. ... Sometimes Access will display Send Info window and/or an error message. ... "The exception unknown software exception occurred in the ...
    (microsoft.public.office.misc)
  • Re: Column does not belong to table
    ... It seems that error code 80070057 is somewhat of a generic error code. ... of the error message I quoted to your search (the "System.Data" part that I ... We're using ADO.Net on a classic ASP site that's using a .Net dll for ... with every user receiving that error message, and restarting IIS resolves ...
    (microsoft.public.dotnet.framework.adonet)