MySQL Forums
Forum List  »  PHP

SQLSTATE[HY000]: General error: 2030 This command is not supported in the prepared statement protocol yet
Posted by: Florian Wolf
Date: September 25, 2006 12:26PM

Hi there,
i'm currently using php 5.1.4 + MySQL 5.0.24 on SuSE Linux

I'm trying the following Query via PDO:
$result = $db->query('SHOW CREATE TABLE my_table')->fetch(PDO::FETCH_ASSOC);

My local windows machine works very well with the same background: PHP 5 + MySQL 5

But if i'm trying to trigger the SQL via my linux webserver it just says:
Error Message: /home/c/clansuite.com/public_html/clansuite/core/db.class.php | Line: 225
SQLSTATE[HY000]: General error: 2030 This command is not supported in the prepared statement protocol yet
Last SQL: SHOW CREATE TABLE cs_admin_shortcuts

So i tried to get rid of the problem by going to the mysql console and preparing the statement myself (to exclude PHP Bugs) - the error reults are:
mysql> PREPARE s FROM 'SHOW CREATE TABLE cs_modules';
ERROR 1295 (HY000): This command is not supported in the prepared statement protocol yet


Any ideas how to solve this problem? I assume that i just misconfugred the MySQL Server, but i really don't know where the problem could be.

/edit: Seems to be this bug: http://bugs.mysql.com/bug.php?id=20665 - I'm trying to update to 5.1.x to solve...

Greetings from germany,
xsign.dll
http://www.clansuite.com



Edited 3 time(s). Last edit at 09/25/2006 12:49PM by Florian Wolf.

Options: ReplyQuote


Subject
Written By
Posted
SQLSTATE[HY000]: General error: 2030 This command is not supported in the prepared statement protocol yet
September 25, 2006 12:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.