SQLSTATE[HY000]: General error: 2030 This command is not supported in the prepared statement protocol yet
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.