Re: [PHP-DB] PHP mysqli is NOT trapping some errors when calling stored procedure

2019-02-12 Thread Venkat Hariharan
Yes, I do have all reqd privs. In fact, as long as a duplicate key situation isnt encountered, I am able to invoke the stored proc from PHP alright and the record gets saved in the database. But when I try to re-do it using the same value (thereby I am expecting that 1062-DUPLICATE KEY error will

Re: [PHP-DB] PHP mysqli is NOT trapping some errors when calling stored procedure

2019-02-12 Thread Aziz Saleh
Do you have sufficient privileges to execute stored procedures (procs_priv) on PHP's end? On Tue, Feb 12, 2019 at 11:07 AM Venkat Hariharan wrote: > Can you take a look at the issue that I've described at > > https://stackoverflow.com/questions/54643704/php-mysqli-is-not-trapping-some-errors-whe

[PHP-DB] PHP mysqli is NOT trapping some errors when calling stored procedure

2019-02-12 Thread Venkat Hariharan
Can you take a look at the issue that I've described at https://stackoverflow.com/questions/54643704/php-mysqli-is-not-trapping-some-errors-when-calling-stored-procedure and tell me what I am missing in my PHP code ? To summarize: I am calling a MySQL stored procedure from PHP that does some DMLs