PDO error
Fatal error: Uncaught exception 'Zend_Db_Statement_Exception' with 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.'
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
<?php
$gamesData = $db->query("SELECT
games.id,
games.title,
games.urlTitle
FROM games
LEFT JOIN
gameToUser
ON
(
games.id = gameToUser.game
AND gameToUser.userId = " . $userId . "
AND gameToUser.playingAtm = 1
)
WHERE games.language = '" . $_SESSION['languageSettings']['currentLanguage'] . "' AND games.deleted = 0
LIMIT 1");
$gamesData = $gamesData->fetchAll();
?>
$gamesData = $db->query("SELECT
games.id,
games.title,
games.urlTitle
FROM games
LEFT JOIN
gameToUser
ON
(
games.id = gameToUser.game
AND gameToUser.userId = " . $userId . "
AND gameToUser.playingAtm = 1
)
WHERE games.language = '" . $_SESSION['languageSettings']['currentLanguage'] . "' AND games.deleted = 0
LIMIT 1");
$gamesData = $gamesData->fetchAll();
?>
Ik snap niet wat er fout is. Ik heb al gekeken of de MySQL Client out-dated is, die is 5.0.51a. Geen idee wat er verder fout kan zijn.
Gesponsorde koppelingen:
Code (php)
1
2
3
4
2
3
4
<?php
$gamesData = $db->query("UPDATE gameToUser SET playingAtm = 0 WHERE playingAtm = 1 AND userId = " . $userId . "; UPDATE gameToUser SET playingAtm = 1 WHERE game = (SELECT id FROM games WHERE " . $field . " = '" . $value . "' AND deleted = 0 AND language = '" . $_SESSION['languageSettings']['currentLanguage'] . "')");
$gamesData->closeCursor();
?>
$gamesData = $db->query("UPDATE gameToUser SET playingAtm = 0 WHERE playingAtm = 1 AND userId = " . $userId . "; UPDATE gameToUser SET playingAtm = 1 WHERE game = (SELECT id FROM games WHERE " . $field . " = '" . $value . "' AND deleted = 0 AND language = '" . $_SESSION['languageSettings']['currentLanguage'] . "')");
$gamesData->closeCursor();
?>
Dit is de query er voor. Ik heb closeCursor() gedaan, maar dat helpt niets.
