Maison > Article > développement back-end > PDO 报错 DibiDriverException: SQLSTATE[HY000]:
数据库配置页
<code><?php require './lib/dibi.min.php'; // DB try { $dsn = new PDO("mysql:host=localhost;dbname=runtime", 'root', '****', array( PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8" )); dibi::connect(array( 'driver' => 'pdo', 'pdo' => $dsn, 'lazy' => true, 'profiler' => array( 'run' => TRUE, ), )); $dibi = true; } catch (Exception $e) { echo $e->getMessage(); exit(); } ?> </code>
报错
http://up.vpsbar.im/tmp/exception-2014-04-22-04-24-23-f770dde7183df6636b625fac44d0ec02.html
日志
<code>[2014-04-22 04-05-50] DibiDriverException: SQLSTATE[HY000]: 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. in /web/lib/dibi.min.php:1102 @ http://up.vpsbar.im/en/public @@ exception-2014-04-22-04-05-50-f3cf5137b37058de5d269f6efb15af27.html [2014-04-22 04-05-59] DibiDriverException: SQLSTATE[HY000]: 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. in /web/lib/dibi.min.php:1102 @ http://up.vpsbar.im/en/public @@ exception-2014-04-22-04-05-50-f3cf5137b37058de5d269f6efb15af27.html [2014-04-22 04-06-10] DibiDriverException: SQLSTATE[HY000]: 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. in /web/lib/dibi.min.php:1102 @ http://up.vpsbar.im/en/public @@ exception-2014-04-22-04-05-50-f3cf5137b37058de5d269f6efb15af27.html [2014-04-22 04-06-19] DibiDriverException: SQLSTATE[HY000]: 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. in /web/lib/dibi.min.php:1102 @ http://up.vpsbar.im/en/public @@ exception-2014-04-22-04-05-50-f3cf5137b37058de5d269f6efb15af27.html [2014-04-22 04-07-25] DibiDriverException: SQLSTATE[HY000]: 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. in /web/lib/dibi.min.php:1102 @ http://up.vpsbar.im/en/public @@ exception-2014-04-22-04-05-50-f3cf5137b37058de5d269f6efb15af27.html </code>
数据库配置页
<code><?php require './lib/dibi.min.php'; // DB try { $dsn = new PDO("mysql:host=localhost;dbname=runtime", 'root', '****', array( PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8" )); dibi::connect(array( 'driver' => 'pdo', 'pdo' => $dsn, 'lazy' => true, 'profiler' => array( 'run' => TRUE, ), )); $dibi = true; } catch (Exception $e) { echo $e->getMessage(); exit(); } ?> </code>
报错
http://up.vpsbar.im/tmp/exception-2014-04-22-04-24-23-f770dde7183df6636b625fac44d0ec02.html
日志
<code>[2014-04-22 04-05-50] DibiDriverException: SQLSTATE[HY000]: 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. in /web/lib/dibi.min.php:1102 @ http://up.vpsbar.im/en/public @@ exception-2014-04-22-04-05-50-f3cf5137b37058de5d269f6efb15af27.html [2014-04-22 04-05-59] DibiDriverException: SQLSTATE[HY000]: 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. in /web/lib/dibi.min.php:1102 @ http://up.vpsbar.im/en/public @@ exception-2014-04-22-04-05-50-f3cf5137b37058de5d269f6efb15af27.html [2014-04-22 04-06-10] DibiDriverException: SQLSTATE[HY000]: 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. in /web/lib/dibi.min.php:1102 @ http://up.vpsbar.im/en/public @@ exception-2014-04-22-04-05-50-f3cf5137b37058de5d269f6efb15af27.html [2014-04-22 04-06-19] DibiDriverException: SQLSTATE[HY000]: 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. in /web/lib/dibi.min.php:1102 @ http://up.vpsbar.im/en/public @@ exception-2014-04-22-04-05-50-f3cf5137b37058de5d269f6efb15af27.html [2014-04-22 04-07-25] DibiDriverException: SQLSTATE[HY000]: 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. in /web/lib/dibi.min.php:1102 @ http://up.vpsbar.im/en/public @@ exception-2014-04-22-04-05-50-f3cf5137b37058de5d269f6efb15af27.html </code>
using PDOStatement::fetchAll()
setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute. in /web/lib/dibi.min.php:1102
上述两者选其一。。。。。看日志。。。。