[HELP] Error with PDO


I just tried to install Piwik, and after I fill the SQL’s form, but I get this error :

Test SQL failed to execute: INSERT INTO piwik_test_table (value) VALUES (123) 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.

Thanks :slight_smile:


I got the same issue.
On my Piwik on my local xampp server I changed the adapter to MySQLi but this didn’t work on a real server.


Got the same error.

Thought the issue stemmed from disabled MySQL query cache disabled (query_cache_size=0), but after setting it to 1 mb, I got the same error/warning.

Reinstalled 1.7.1 over the same db server, with no issues encountered.

(Matthieu Aubry) #4

Very sorry about this error we packaged 1.8.2 with a critical bug for install with PDO!

Please try 1.8.2 which should be OK Thanks


Thanks a lot, I’ll try it tomorrow ! :slight_smile:
Thanks for your reactivity, also !


I am having the same issue…

How is it possible to download 1.8.2 as only 1.8.1 is showing for download…

Many thanks in advance.

(mahdi1234) #7

You can get all the builds including 1.8.2 from here


Many thanks working like a treat…


THANKS, it works perfectly now !