Home > Backend Development > PHP Tutorial > PDO 报错 DibiDriverException: SQLSTATE[HY000]:

PDO 报错 DibiDriverException: SQLSTATE[HY000]:

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-06 20:46:08
Original
1486 people have browsed it

数据库配置页

<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>
Copy after login
Copy after login

报错
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>
Copy after login
Copy after login

回复内容:

数据库配置页

<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>
Copy after login
Copy after login

报错
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>
Copy after login
Copy after login

using PDOStatement::fetchAll()

setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute. in /web/lib/dibi.min.php:1102

上述两者选其一。。。。。看日志。。。。

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
Database pdo connection problem
From 1970-01-01 08:00:00
0
0
0
pdo installation
From 1970-01-01 08:00:00
0
0
0
$pdo->exec($sql);Why does it always return false?
From 1970-01-01 08:00:00
0
0
0
PHP PDO predefined constants
From 1970-01-01 08:00:00
0
0
0
PDO query data error
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template