Unable to save global configuration

[gael]

Unable to save settings/preferences. When hitting the save button the following error occurs on siwapp_dev.php/settings/global page:

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.

[enrique]

is this bug of the 0.3 dev version? I mean, the trunk svn repository or the 0.2-alpha?

[jzarate]

gael. since the dev version is built on doctrine, and the 0.2 on propel, is rather important to know exactly which version are you having this issue on. Could you please provide some more details??

in the meantime, Here are a few bugs that may or may not be related to that, if you feel like it, go ahead and check them.

• http://bugs.php.net/bug.php?id=44081
• http://bugs.php.net/bug.php?id=39759

[jzarate]

gael, we also need the php version and platform .

[leo]

is happening to me also. I´m using WAMP (Apache.v2.28, mySQL.v5.05, PHP.v5.2.6), with siwapp.v0.3. I will be looking at it.

[leo]

this bug happens when saving the Currency decimal numbers, when calling the method execute in the SiwappViews? class. This method runs several views in mySQL, and it fails. It´s a PHP bug in Windows platform, as jzarate said, and as far as I know it´s not fixed yet.

Anyway, as #298 is meant to replace mySQl views with triggers, I´m closing this ticket.