OXID Community Forum

> International Forums > Installation and configuration > SQLSTATE[HY000]: General error: 2014
Login
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Thread: SQLSTATE[HY000]: General error: 2014


Reply
 
Thread Tools Display Modes
#Top   #1  
Old 02-13-2012, 04:46 PM
skygate skygate is offline
Junior Member
Join Date: Feb 2012
Posts: 9
skygate is on a distinguished road
Default SQLSTATE[HY000]: General error: 2014

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.
Reply With Quote
#Top   #2  
Old 02-13-2012, 05:43 PM
Marco Steinhaeuser's Avatar
Marco Steinhaeuser Marco Steinhaeuser is online now
Community Guide @ OXID
Join Date: Oct 2008
Posts: 11,242
Marco Steinhaeuser is on a distinguished road
Default Re: SQLSTATE[HY000]: General error: 2014

Hi,

Quote:
Originally Posted by skygate View Post
I have downloaded the newest Oxwall community software, build 4417, version 1.2.6.
You probably wanted to get here, right?
http://www.oxwall.org/forum

Regards
__________________
Marco
http://about.me/marco.steinhaeuser

Will ignore unsolicited support requests via PM, email or IM.
Reply With Quote
#Top   #3  
Old 02-14-2012, 10:28 AM
skygate skygate is offline
Junior Member
Join Date: Feb 2012
Posts: 9
skygate is on a distinguished road
Default Re: SQLSTATE[HY000]: General error: 2014

Hello Marco,



Why do You think so? I have downloaded the OXID Community Edition.

Isn't it the:

OXID Community Forum > International Forums > Installation and configuration

here?


Thanks for Your information.
Reply With Quote
#Top   #4  
Old 02-14-2012, 10:38 AM
Marco Steinhaeuser's Avatar
Marco Steinhaeuser Marco Steinhaeuser is online now
Community Guide @ OXID
Join Date: Oct 2008
Posts: 11,242
Marco Steinhaeuser is on a distinguished road
Default Re: SQLSTATE[HY000]: General error: 2014

Hi,

Quote:
Originally Posted by skygate View Post
Why do You think so? I have downloaded the OXID Community Edition.
Well, because before, you stated that you're using oxwall. Also, the given build and version number looked like referring more to this system.

Anyway - never seen your error message before. In another forum, I read that it might be caused by a PHP bug on Windows machines:
https://bugs.php.net/bug.php?id=39858

Possible to update your PHP version?

Regards
__________________
Marco
http://about.me/marco.steinhaeuser

Will ignore unsolicited support requests via PM, email or IM.
Reply With Quote
#Top   #5  
Old 02-14-2012, 01:49 PM
skygate skygate is offline
Junior Member
Join Date: Feb 2012
Posts: 9
skygate is on a distinguished road
Default Re: SQLSTATE[HY000]: General error: 2014

Hello Marco,


Actually - Your solution worked! Thanks I have installed the PHP 5.3.10 and this error is no more


Best Regards,
Krzysztof
Reply With Quote
#Top   #6  
Old 02-14-2012, 05:11 PM
Marco Steinhaeuser's Avatar
Marco Steinhaeuser Marco Steinhaeuser is online now
Community Guide @ OXID
Join Date: Oct 2008
Posts: 11,242
Marco Steinhaeuser is on a distinguished road
Default Re: SQLSTATE[HY000]: General error: 2014

Nice. Thanks for your feedback!
__________________
Marco
http://about.me/marco.steinhaeuser

Will ignore unsolicited support requests via PM, email or IM.
Reply With Quote
Reply

Bookmarks

Tags
2014, error, general, sqlstatehy000

« Previous Thread | Next Thread »
Thread Tools
Display Modes

Nicht Sichtbar
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating own modules (general) cbiel Developers 4 07-19-2011 04:06 PM
setup problem: Parse error: syntax error, unexpected T_STRING line 136 sales-man Installation and configuration 1 11-06-2010 10:25 AM
Error 500 & 504 mpqtjan Installation und Konfiguration 7 10-13-2010 02:28 PM
Parse error: syntax error.... unikat Installation und Konfiguration 1 12-21-2009 04:07 PM
Error 404 woozie Newbies 20 10-28-2009 01:07 PM

All times are GMT +1. The time now is 07:01 AM.