How can I fix "General error: 2014 Cannot execute queries while other unbuffered queries are active."?

Question

How can I fix "General error: 2014 Cannot execute queries while other unbuffered queries are active."?

ivanblue Aug '13

Created Aug '13	Last Reply Aug '13	Replies 1	Views 3099	Votes 2

ivanblue 18.9k

Aug '13

Hello, I was using raw sql queries without any problems when this error appear. I was querying for a resulset from a table and then a count from all the records and this error appears. How can fix this?

Thanks.

2

ivanblue
18.9k

Accepted
answer

Sep '13

Apparently I just wrote a bad SQL sentence... touching here and there I solved the error.... Thanks XyploatKyrt.

XyploatKyrt · Answer 1 · 2013-08-27T03:06:23-07:00

I'm not a Phalcon expert, but this sounds a lot like a general problem that can occur when you are using PDO that I've run into when using other frameworks. Basically, it happens when you send one raw PDO statement and then another without resetting the cursor in between.

You need to call ::closeCursor() on your PDOStatement object in between queries.

See: https://stackoverflow.com/questions/2066714/pdo-cannot-execute-queries-while-other-unbuffered-queries-are-active