HELLO EVERYBODY, I GOT A BIG PROBLEM AND I WILL SHARE WITH YA, HOPE I WILL FINE A GOOD RESOLUTION. THANK YOU BEFORE
I WORKING ON E-COMMERCE WITH USING PDO SUDDENDLY I GOT THIS ERROR MESSAGE. HOPE THERE WILL BE SOMEONE HERE TO HELP ME:
ERRNO: 256
TEXT: 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.
LOCATION: C:\tshirtshop\business\database_handler.php, line 89, at June 23, 2010, 10:16 am
Showing backtrace:
trigger_error("SQLSTATE[HY000]: General error: 2014 Cannot execute queries whil...", "256") # line 89, file: C:\tshirtshop\business\database_handler.php
DatabaseHandler.GetAll("CALL catalog_get_departments_list()") # line 11, file: C:\tshirtshop\business\catalog.php
Catalog.GetDepartments() # line 21, file: C:\tshirtshop\presentation\departments_list.php
DepartmentsList.init() # line 13, file: C:\tshirtshop\presentation\smarty_plugins\function.load_presentation_object.php
smarty_function_load_presentation_object(Array[2], Object: Application) # line 5, file: C:\tshirtshop\presentation\templates_c\%%A5A5AA5A1C73D%%departments_list.tpl.php
include("C:\tshirtshop\presentation\templates_c\%%A5A5AA5A1C73D%%depart...") # line 1869, file: C:\tshirtshop\libs\smarty\Smarty.class.php
Smarty.smarty_include(Array[2]) # line 46, file: C:\tshirtshop\presentation\templates_c\%%41412412F4E3D%%store_front.tpl.php
include("C:\tshirtshop\presentation\templates_c\%%41412412F4E3D%%store...") # line 1256, file: C:\tshirtshop\libs\smarty\Smarty.class.php
Smarty.fetch("store_front.tpl", null, null, true) # line 1106, file: C:\tshirtshop\libs\smarty\Smarty.class.php
Smarty.display("store_front.tpl") # line 26, file: C:\tshirtshop\index.php