We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

SQLSTATE[HY000]: General error: 2014 | Forum

SKY GATE
SKY GATE Feb 14 '12
Hello,

I have downloaded the newest Oxwall community software, build 4417, version 1.2.6.
I am trying to set it up on my Windows local machine with:
ZWAMP 1.1.2
Apache 2.2.17
PHP 5.2.11 with all necessary modules
MySQL: 5.0.51a
I am running the installation process after the third step I get the following information:
http://localhost/install/plugins

Message: 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.
File: Z:\web\wollrausch\ow_core\database.php
Line: 311
Trace:
#0 Z:\web\wollrausch\ow_core\database.php(311): PDOStatement->execute()
#1 Z:\web\wollrausch\ow_core\database.php(345): OW_Database->execute('SELECT * FROM o...', NULL)
#2 Z:\web\wollrausch\ow_core\base_dao.php(114): OW_Database->queryForObject('SELECT * FROM o...', 'BOL_Plugin')
#3 Z:\web\wollrausch\ow_system_plugins\base\bol\plugi n_dao.php(115): OW_BaseDao->findObjectByExample(Object(OW_Example))
#4 Z:\web\wollrausch\ow_system_plugins\base\bol\plugi n_service.php(113): BOL_PluginDao->findPluginByKey('notifications')
#5 Z:\web\wollrausch\ow_core\plugin_manager.php(184): BOL_PluginService->findPluginByKey('notifications')
#6 Z:\web\wollrausch\ow_plugins\notifications\install .php(86): OW_PluginManager->addPluginSettingsRouteName('notifications', 'notifications-a...')
#7 Z:\web\wollrausch\ow_system_plugins\base\bol\plugi n_service.php(384): include_once('Z:\web\wollraus...')
#8 Z:\web\wollrausch\ow_install\controllers\install.p hp(466): BOL_PluginService->install('notifications')
#9 Z:\web\wollrausch\ow_install\controllers\install.p hp(422): INSTALL_CTRL_Install->installComplete(Array)
#10 [internal function]: INSTALL_CTRL_Install->plugins()
#11 Z:\web\wollrausch\ow_install\classes\application.p hp(57): call_user_func_array(Array, Array)
#12 Z:\web\wollrausch\ow_install\install.php(75): INSTALL_Application->display()
#13 Z:\web\wollrausch\index.php(32): include('Z:\web\wollraus...')
#14 {main}
Type: PDOException



How can I fix it? I have already tried to set the MYSQL_ATTR_USE_BUFFERED_QUERY attribute but it does not help.

Thanks for Your information.
Michael I.
Michael I. Feb 15 '12
Well, 1.2.6 is not the latest build now, 1.3.0 has been released recently and we recommend using it.


As for the error you receive - that is definitely your server error which is more a conflict of PHP and your Windows server, than the Oxwall issue. I've found some solutions here:


http://www.magentocommerce.com/boards/viewthread/35/

https://bugs.php.net/bug.php?id=39858