ID: 35793
Comment by: post-christian at freenet dot de
Reported By: deadman_great at mail dot ru
Status: No Feedback
Bug Type: PDO related
Operating System: RH Fedora Core 2
PHP Version: 5CVS-2005-12-25 (snap)
Assigned To: Wez
New Comment:
I think we need to rethink about how mysql works. If you don't use
mysql_stmt_store_result(), which make sense when loading long data,
mysql seems to allow only one active statement per connection. puhh.
hard to believe but could be true. I'm having the same problem with a
mysql driver for perl.
Previous Comments:
------------------------------------------------------------------------
[2008-10-21 06:20:08] vishalraj82 at gmail dot com
I guess this is a problem with pdo.
When you connect to localhost using pdo, fire a query and store the
result in variable, the variable needs to be reset before it can be
reused, given that mysql resids on a remote server and not on
localhost.
$conn = new PDO("localhost"....
$sql1 = "SELECT * from TEST";
$res = $conn->query($sql1);
...
...
$sql2 = "SELECT * from MYTAB";
$res = $conn->query($sql2); // In this line you will get mysql general
error if $res has not been reset before being used again
------------------------------------------------------------------------
[2008-08-19 16:06:01] baptiste dot place at utopiaweb dot fr
Got the same error with second statement of a function.
Worked fine on winXP xampp, PHP 5.2.6, MySql 5.0.51b.
Deployed on a debian server with PHP 5.2.0-8 and MySQL 5.0.32, the code
threw this error.
Made it work with michal vrchota's solution, thanks a lot.
------------------------------------------------------------------------
[2008-03-19 16:40:26] ob dot php at daevel dot fr
This bug/problem is not solved with PHP 5.2.0 under Debian stable
(etch).
Full code :
<?php
$db = new pdo( 'mysql:host=localhost;dbname=admin', 'administration',
'XXX' );
$db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING );
if( ( $res = $db->query( 'select id from user_group' ) ) !== false )
{
print_r( $res->fetchAll() );
}
if( ( $res = $db->query( 'select description from user_group' ) ) !==
false )
{
print_r( $res->fetchAll() );
}
?>
And result for the second query :
Warning: PDOStatement::fetchAll(): SQLSTATE[HY000]: General error: 2050
in /home/dev-olivier/toutgagner.admin/test.php on line 14
Array
(
)
Won't it be fixed ?
------------------------------------------------------------------------
[2006-12-28 01:22:18] dennis at inmarket dot lviv dot ua
Remember to have these "fixes" in your code on every connection you
might have to the same database.
------------------------------------------------------------------------
[2006-11-03 08:53:42] arnaud dot lb at gmail dot com
I have the same problem with php-5.2, mysql-5.0.26 on
Debian system.
Fixed the problem using the
PDO::MYSQL_ATTR_USE_BUFFERED_QUERY option.
It seems that closeCursor() does not works properly.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/35793
--
Edit this bug report at http://bugs.php.net/?id=35793&edit=1
