PHP MySQL Error Setting

Question

I have developed some php/mysql code on linux machine, and it runs fine. On client's machine running wamp server on windows, same operation gives a mysql error - which Php is displaying neatly in a tabular format. The error is in a mysql query with INSERT, pertaining to Duplicate Keys. (I know I can use ON DUPLICATE KEY UPDATE, but that is not the issue). Problem is, the code is supposed to handle errors gracefully.

It does on my linux machine, but on client's wamp - it displays html tables with error details. I tried try and catch around the function call, but that also does not prevent the error from getting displayed in the browser (the PHP file is supposed to emit json data for ajax calls, that is why I cannot afford to have those error display by PHP).

Also, in the php file, I have

ini_set('display_errors', 1); error_reporting(E_ALL);

and still, since its a mysql error, it rightly does not throw any php error on linux, but does on windows.

So basically, I want to know what PHP setting (or something else?) on client's machine could be causing the MySQL error to be propagated / processed by PHP, and how to turn it off.

Thanks

Can you show us the entire error message? (To try to figure out where it is originating from) — nl-x
– nl-x, Commented May 22, 2014 at 7:55
you are setting 'display_errors' to 1 thus showing errors? — NDM
– NDM, Commented May 22, 2014 at 9:24

nl-x · Accepted Answer · 2014-05-22 08:05:03Z

1

You might want to check your php.ini and look at these values:

xdebug.auto_trace=1
xdebug.trace_format=1
mysql.trace_mode = On
pdo_mysql.debug = On

If they are there, disable them

edited May 22, 2014 at 8:05

answered May 22, 2014 at 7:59

nl-x

11.9k7 gold badges36 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

workwise Over a year ago

It was indeed issue with xdebug and another extension.

FahadAkram · Accepted Answer · 2014-05-22 07:22:01Z

0

its better to make error_reporting(0); in start of your code when you put your code on live server , its is better to hide un necessary errors and notifications

answered May 22, 2014 at 7:22

FahadAkram

4851 gold badge7 silver badges25 bronze badges

1 Comment

xMoltenX Over a year ago

It's true that's best, but it won't make the website function.

Arian Faurtosh · Accepted Answer · 2014-05-22 07:51:04Z

0

First make sure your MySQL version numbers are the same!

If you are using mysqli try having the following:

mysqli_report(MYSQLI_REPORT_OFF);

If you want to turn it on with the Linux stack, try something like this:

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

edited May 22, 2014 at 7:51

answered May 22, 2014 at 7:38

Arian Faurtosh

18.6k23 gold badges81 silver badges117 bronze badges

Comments

Rads · Accepted Answer · 2014-05-22 08:36:02Z

0

try this instead

ini_set('display_errors', 0);

error_reporting(E_ERROR); OR error_reporting(0);

answered May 22, 2014 at 8:36

Rads

1951 gold badge3 silver badges17 bronze badges

Collectives™ on Stack Overflow

PHP MySQL Error Setting

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related