Skip to main content ↑ ↓

Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - arnoleka

1
Issues / SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffer
I created a query for 'pivoting' using mySQL. Followed the method described here:

https://www.tarynpivots.com/post/how-to-rotate-rows-into-columns-in-mysql/

Unfortunately I am getting this error:

SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.

I have attached an sql export of the data I'm using. This is the underlying query which works well on MySQL on a WAMP instance on my PC. And also attached is the query I used.

Really need help on this. Would very much appreciate your help.

Thanks,
Arno