On 20-Feb-2006 Adam Boswell wrote:
> Hello,
>
> I am trying to run a prepare("check table ***on all tables**") and I am
> getting an error "DBD::mysql::db prepare failed: This command is not
> supported in the prepared statement protocol yet". However the process still
> runs and it sends it to mysql and works, BUT then the process never finishes
> and it spawns all kinds of problems. Is there a way around this or a fix for
> this?
>
> ~Adam
You could try setting mysql_emulated_prepare as per the DBD::mysql
docs to see if that helps.
I think this explains some code in DBD::mysql I was unsure about recently.
I'm guessing you'd need to add "check" to the list of commands tested for in
dbdimp.c in dbd_st_prepare (but this code only exists in 3.0002_4).
e.g. like
if ( (statement[i] == 'c' || statement[i] == 'C') &&
(statement[i+1] == 'r' || statement[i+1] == 'R') &&
(statement[i+2] == 'e' || statement[i+2] == 'E') &&
(statement[i+3] == 'a' || statement[i+3] == 'A') &&
(statement[i+4] == 't' || statement[i+4] == 'T') &&
(statement[i+5] == 'e' || statement[i+5] == 'E'))
{
if (dbis->debug >= 2)
PerlIO_printf(DBILOGFP, "CREATE set use_server_side_prepare to 0\n");
imp_sth->use_server_side_prepare= 0;
}
But that is a guess. Like the entry in the ChangeLog:
* Fix that sets mysql_server_prepare to 0 if SQL statement is 'SHOW ...'
which is not supported by prepared statement API currently
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
