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

go to bug id or search bugs for

Bug #57292 LOCK TABLES -> 'SQLSTATE[HY000]: General error: 2030'
Submitted: 2006-10-12 11:05 UTC Modified: 2008-05-08 11:01 UTC
From: fog at gmx dot de Assigned:
Status: Not a bug Package: PDO_MYSQL (PECL)
PHP Version: 5.1.4 OS: Linux
Private report: No CVE-ID: None
View Developer Edit
 [2006-10-12 11:05 UTC] fog at gmx dot de 
Description:
------------
The use of LOCK TABLES tablename WRITE causes an error on Linux servers while it runs perfect on windows machines. A PHP Script using LOCK TABLES would fail under Linux if used with PDO.

On the Linux Server the pdo_mysql Version is:
PDO Driver for MySQL, client library version 5.0.18 




Actual result:
--------------
Error Message without stack trace:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2030 This command is not supported in the prepared statement protocol yet' in /home/gforge/printserver.gforge.iklk.de/visitenkarten-docs/lib/CB_NestedSet.class.php:665

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-10-12 12:06 UTC] wez@php.net 
See: http://netevil.org/node.php?uuid=444a6017-0548-2459-2943-44a601714d58
 [2008-05-08 11:01 UTC] johannes at schlueters dot de 
No PDO_mysql issue, emulation is used by default.
 [2011-09-09 19:09 UTC] aa at ff dot com 
shit
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Tue May 13 04:01:27 2025 UTC