php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #56305 General error: 2014 Commands out of sync; you can't run this command now
Submitted: 2005-02-17 08:17 UTC Modified: 2005-06-10 02:23 UTC
Votes:7
Avg. Score:4.3 ± 0.9
Reproduced:7 of 7 (100.0%)
Same Version:3 (42.9%)
Same OS:1 (14.3%)
From: lphuberdeau at phpquebec dot org Assigned: wez (profile)
Status: Wont fix Package: PDO_MYSQL (PECL)
PHP Version: 5.0.3 OS: Windows 2000
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: lphuberdeau at phpquebec dot org
New email:
PHP Version: OS:

 

 [2005-02-17 08:17 UTC] lphuberdeau at phpquebec dot org 
Description:
------------
The problem mostly occur when multiple queries are made at once (loops made afterwards). 

Exception is thrown:
General error: 2014 Commands out of sync; you can't run this command now

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-02-17 08:36 UTC] lphuberdeau at phpquebec dot org 
I found a similar bug related to the MySQL library.
http://bugs.php.net/bug.php?id=19529

I made a rollback on the code to the old mysql_ functions and it all works fine. The bug report refers to mysql_db_query() as the function causing problems. All the code currently has mysql_query() calls.
 [2005-02-18 11:03 UTC] wez@php.net 
This is expected behaviour; PDO opens forward-only rowsets that fetch on demand by default.  (equivalent to http://www.php.net/mysql_unbuffered_query).

This is by design, and encourages you to write more efficient scripts.
I will look into something more convenient, however.
 [2005-04-03 09:17 UTC] Jared dot Williams1 at ntlworld dot com 
[quote]I will look into something more convenient, however.[/quote]

Excellent. Does seem a pain, when sqlite & pgsql can have multiple unbuffered queries.
 [2005-06-10 02:23 UTC] wez@php.net 
Use PDOStatement::fetchAll()
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat Dec 21 16:01:28 2024 UTC