MySQL Forums
Forum List  »  PHP

Re: SQL error on php page
Posted by: Mark Hwang
Date: March 18, 2018 12:10PM

I was able to use PDO::errorInfo() to trap the error, which was basically the same unbuffered query error. However, the fetchAll() method was not the solution, as the buffered query mode was the default. The problem was that I had an insert statement before and it could not process another SQL statement until that one was done. I tried commit or closeCursor() but neither worked. I then closed the connection and opened it for the second SQL statement and it worked!

Thanks again for your help!

Options: ReplyQuote

Written By
March 14, 2018 12:22PM
March 14, 2018 03:39PM
March 15, 2018 05:40PM
March 15, 2018 07:33PM
March 16, 2018 07:14PM
March 16, 2018 07:19PM
March 17, 2018 09:08AM
March 17, 2018 10:41AM
Re: SQL error on php page
March 18, 2018 12:10PM
March 18, 2018 06:20PM
May 09, 2018 03:33AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.