From 28392a12d39a2d94f7c39adabf3c108c790ec01a Mon Sep 17 00:00:00 2001 From: Michael Save Date: Mon, 27 Aug 2012 21:37:21 +1000 Subject: fix "unbuffered queries" bug (issue #75) --- inc/database.php | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) (limited to 'inc/database.php') diff --git a/inc/database.php b/inc/database.php index 0dcc66b2..6f68e7e4 100644 --- a/inc/database.php +++ b/inc/database.php @@ -49,8 +49,11 @@ function sql_open() { if (!empty($config['db']['dsn'])) $dsn .= ';' . $config['db']['dsn']; try { - $options = Array(PDO::ATTR_TIMEOUT => $config['db']['timeout']); - $options = Array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'); + $options = array( + PDO::ATTR_TIMEOUT => $config['db']['timeout'], + PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8', + PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true + ); if ($config['db']['persistent']) $options[PDO::ATTR_PERSISTENT] = true; return $pdo = new PDO($dsn, $config['db']['user'], $config['db']['password'], $options); -- cgit v1.3