#39052 [NEW]: pdo::query with "show slave/master status"

[xing at mac dot com]

From: xing at mac dot com
Operating system: Linux
PHP version: 5.1.6
PHP Bug Type: PDO related
Bug description: pdo::query with "show slave/master status"

Description:
------------
PHP 5.1.6
Mysql 5.0.24a

I have tested using PDO::query for both "show master status" and "show
slave status" via tcp port and both bomb out with "SQLSTATE[HY000]:
General error: 2030 This command is not supported in the prepared
statement protocol yet" error.

Bug #36572 was suppoed to fix this but I just tested with php 5.1.6 and
the issue is still unresolved.


Reproduce code:
---------------
Execute

"show slave status;"

or

"show master status"

via pdo::query connected to server using tcp port.

Expected result:
----------------
Result set.

Actual result:
--------------
SQLSTATE[HY000]: General error: 2030 This command is not supported in the
prepared statement protocol yet

--
Edit bug report at [url]http://bugs.php.net/?id=39052&edit=1[/url]
--
Try a CVS snapshot (PHP 4.4): [url]http://bugs.php.net/fix.php?id=39052&r=trysnapshot44[/url]
Try a CVS snapshot (PHP 5.2): [url]http://bugs.php.net/fix.php?id=39052&r=trysnapshot52[/url]
Try a CVS snapshot (PHP 6.0): [url]http://bugs.php.net/fix.php?id=39052&r=trysnapshot60[/url]
Fixed in CVS: [url]http://bugs.php.net/fix.php?id=39052&r=fixedcvs[/url]
Fixed in release: [url]http://bugs.php.net/fix.php?id=39052&r=alreadyfixed[/url]
Need backtrace: [url]http://bugs.php.net/fix.php?id=39052&r=needtrace[/url]
Need Reproduce Script: [url]http://bugs.php.net/fix.php?id=39052&r=needscript[/url]
Try newer version: [url]http://bugs.php.net/fix.php?id=39052&r=oldversion[/url]
Not developer issue: [url]http://bugs.php.net/fix.php?id=39052&r=support[/url]
Expected behavior: [url]http://bugs.php.net/fix.php?id=39052&r=notwrong[/url]
Not enough info: [url]http://bugs.php.net/fix.php?id=39052&r=notenoughinfo[/url]
Submitted twice: [url]http://bugs.php.net/fix.php?id=39052&r=submittedtwice[/url]
register_globals: [url]http://bugs.php.net/fix.php?id=39052&r=globals[/url]
PHP 3 support discontinued: [url]http://bugs.php.net/fix.php?id=39052&r=php3[/url]
Daylight Savings: [url]http://bugs.php.net/fix.php?id=39052&r=dst[/url]
IIS Stability: [url]http://bugs.php.net/fix.php?id=39052&r=isapi[/url]
Install GNU Sed: [url]http://bugs.php.net/fix.php?id=39052&r=gnused[/url]
Floating point limitations: [url]http://bugs.php.net/fix.php?id=39052&r=float[/url]
No Zend Extensions: [url]http://bugs.php.net/fix.php?id=39052&r=nozend[/url]
MySQL Configuration Error: [url]http://bugs.php.net/fix.php?id=39052&r=mysqlcfg[/url]

[xing at mac dot com]

ID: 39052
User updated by: xing at mac dot com
Reported By: xing at mac dot com
-Status: Feedback
+Status: Open
Bug Type: PDO related
Operating System: Linux
PHP Version: 5.1.6
New Comment:

Just tried the 5.2cvs snapshot. Same result. No change.


Previous Comments:
------------------------------------------------------------------------

[2006-10-05 19:36:29] [email]tony2001@php.net[/email]

Please try using this CVS snapshot:

[url]http://snaps.php.net/php5.2-latest.tar.gz[/url]

For Windows:

[url]http://snaps.php.net/win32/php5.2-win32-latest.zip[/url]



------------------------------------------------------------------------

[2006-10-05 19:28:57] xing at mac dot com

Description:
------------
PHP 5.1.6
Mysql 5.0.24a

I have tested using PDO::query for both "show master status" and "show
slave status" via tcp port and both bomb out with "SQLSTATE[HY000]:
General error: 2030 This command is not supported in the prepared
statement protocol yet" error.

Bug #36572 was suppoed to fix this but I just tested with php 5.1.6 and
the issue is still unresolved.


Reproduce code:
---------------
Execute

"show slave status;"

or

"show master status"

via pdo::query connected to server using tcp port.

Expected result:
----------------
Result set.

Actual result:
--------------
SQLSTATE[HY000]: General error: 2030 This command is not supported in
the prepared statement protocol yet


------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=39052&edit=1[/url]

[tony2001@php.net]

ID: 39052
Updated by: [email]tony2001@php.net[/email]
Reported By: xing at mac dot com
-Status: Open
+Status: Feedback
Bug Type: PDO related
Operating System: Linux
PHP Version: 5.1.6
New Comment:

Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.

A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external
resources such as databases, etc. If the script requires a
database to demonstrate the issue, please make sure it creates
all necessary tables, stored procedures etc.

Please avoid embedding huge scripts into the report.




Previous Comments:
------------------------------------------------------------------------

[2006-10-05 20:09:14] xing at mac dot com

Just tried the 5.2cvs snapshot. Same result. No change.

------------------------------------------------------------------------

[2006-10-05 19:36:29] [email]tony2001@php.net[/email]

Please try using this CVS snapshot:

[url]http://snaps.php.net/php5.2-latest.tar.gz[/url]

For Windows:

[url]http://snaps.php.net/win32/php5.2-win32-latest.zip[/url]



------------------------------------------------------------------------

[2006-10-05 19:28:57] xing at mac dot com

Description:
------------
PHP 5.1.6
Mysql 5.0.24a

I have tested using PDO::query for both "show master status" and "show
slave status" via tcp port and both bomb out with "SQLSTATE[HY000]:
General error: 2030 This command is not supported in the prepared
statement protocol yet" error.

Bug #36572 was suppoed to fix this but I just tested with php 5.1.6 and
the issue is still unresolved.


Reproduce code:
---------------
Execute

"show slave status;"

or

"show master status"

via pdo::query connected to server using tcp port.

Expected result:
----------------
Result set.

Actual result:
--------------
SQLSTATE[HY000]: General error: 2030 This command is not supported in
the prepared statement protocol yet


------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=39052&edit=1[/url]

[xing at mac dot com]

ID: 39052
User updated by: xing at mac dot com
Reported By: xing at mac dot com
-Status: Feedback
+Status: Open
Bug Type: PDO related
Operating System: Linux
PHP Version: 5.1.6
New Comment:

<?php

$link = new PDO("mysql:host=127.0.0.1;port=11113;","user","pas sword");
$link->setAttribute (PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$link->setAttribute (PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, TRUE);
$link->query("SET NAMES 'utf8'");

try {
$link->query("show slave status");
echo "good";
}
catch (PDOException $e) {
echo "<pre>";
print_r($e);
echo "</pre>";
}

?>


Previous Comments:
------------------------------------------------------------------------

[2006-10-05 20:21:38] [email]tony2001@php.net[/email]

Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.

A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external
resources such as databases, etc. If the script requires a
database to demonstrate the issue, please make sure it creates
all necessary tables, stored procedures etc.

Please avoid embedding huge scripts into the report.



------------------------------------------------------------------------

[2006-10-05 20:09:14] xing at mac dot com

Just tried the 5.2cvs snapshot. Same result. No change.

------------------------------------------------------------------------

[2006-10-05 19:36:29] [email]tony2001@php.net[/email]

Please try using this CVS snapshot:

[url]http://snaps.php.net/php5.2-latest.tar.gz[/url]

For Windows:

[url]http://snaps.php.net/win32/php5.2-win32-latest.zip[/url]



------------------------------------------------------------------------

[2006-10-05 19:28:57] xing at mac dot com

Description:
------------
PHP 5.1.6
Mysql 5.0.24a

I have tested using PDO::query for both "show master status" and "show
slave status" via tcp port and both bomb out with "SQLSTATE[HY000]:
General error: 2030 This command is not supported in the prepared
statement protocol yet" error.

Bug #36572 was suppoed to fix this but I just tested with php 5.1.6 and
the issue is still unresolved.


Reproduce code:
---------------
Execute

"show slave status;"

or

"show master status"

via pdo::query connected to server using tcp port.

Expected result:
----------------
Result set.

Actual result:
--------------
SQLSTATE[HY000]: General error: 2030 This command is not supported in
the prepared statement protocol yet


------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=39052&edit=1[/url]

[wez@php.net]

ID: 39052
Updated by: [email]wez@php.net[/email]
Reported By: xing at mac dot com
-Status: Open
+Status: Bogus
Bug Type: PDO related
Operating System: Linux
PHP Version: 5.1.6
New Comment:

$link->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);


Previous Comments:
------------------------------------------------------------------------

[2006-10-05 20:34:58] xing at mac dot com

<?php

$link = new PDO("mysql:host=127.0.0.1;port=11113;","user","pas sword");
$link->setAttribute (PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$link->setAttribute (PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, TRUE);
$link->query("SET NAMES 'utf8'");

try {
$link->query("show slave status");
echo "good";
}
catch (PDOException $e) {
echo "<pre>";
print_r($e);
echo "</pre>";
}

?>

------------------------------------------------------------------------

[2006-10-05 20:21:38] [email]tony2001@php.net[/email]

Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.

A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external
resources such as databases, etc. If the script requires a
database to demonstrate the issue, please make sure it creates
all necessary tables, stored procedures etc.

Please avoid embedding huge scripts into the report.



------------------------------------------------------------------------

[2006-10-05 20:09:14] xing at mac dot com

Just tried the 5.2cvs snapshot. Same result. No change.

------------------------------------------------------------------------

[2006-10-05 19:36:29] [email]tony2001@php.net[/email]

Please try using this CVS snapshot:

[url]http://snaps.php.net/php5.2-latest.tar.gz[/url]

For Windows:

[url]http://snaps.php.net/win32/php5.2-win32-latest.zip[/url]



------------------------------------------------------------------------

[2006-10-05 19:28:57] xing at mac dot com

Description:
------------
PHP 5.1.6
Mysql 5.0.24a

I have tested using PDO::query for both "show master status" and "show
slave status" via tcp port and both bomb out with "SQLSTATE[HY000]:
General error: 2030 This command is not supported in the prepared
statement protocol yet" error.

Bug #36572 was suppoed to fix this but I just tested with php 5.1.6 and
the issue is still unresolved.


Reproduce code:
---------------
Execute

"show slave status;"

or

"show master status"

via pdo::query connected to server using tcp port.

Expected result:
----------------
Result set.

Actual result:
--------------
SQLSTATE[HY000]: General error: 2030 This command is not supported in
the prepared statement protocol yet


------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=39052&edit=1[/url]