|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2006-10-05 19:28 UTC] 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 PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Wed Oct 29 01:00:01 2025 UTC |
<?php $link = new PDO("mysql:host=127.0.0.1;port=11113;","user","password"); $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>"; } ?>