Prepare error

------=_Part_21269_19656035.1140473323127
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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 stil=
l
runs and it sends it to mysql and works, BUT then the process never finishe=
s
and it spawns all kinds of problems. Is there a way around this or a fix fo=
r
this?

~Adam

------=_Part_21269_19656035.1140473323127--

RE: Prepare error

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