i'm getting this error:
DBD::mysql::st execute failed: Column count doesn't match value count at row
1 at ./test-get.pl line 91, line 1.
DBD::mysql::st execute failed: Column count doesn't match value count at row
1 at ./test-get.pl line 91, line 1.
and i've been counting p
Ryan Chan wrote:
Sometimes, my sql is running for a quite long time, e.g. 1 hour
The perl script will warn "DBD::mysql::st execute failed: MySQL server
has gone away at ..." and my script failed.
I have already set the auto reconnect, e.g.
$dbh->{mysql_auto_reconnect} = 1;
Hello,
Sometimes, my sql is running for a quite long time, e.g. 1 hour
The perl script will warn "DBD::mysql::st execute failed: MySQL server
has gone away at ..." and my script failed.
I have already set the auto reconnect, e.g.
$dbh->{mysql_auto_reconnect} = 1;
But problem sti
er tables I am able to
> isnert data
>
>
>
> ------------------
>
> DBD::mysql::st execute failed: Column count doesn't match value count
--
DBD::mysql::st execute failed: Column count doesn't match value count at row
1 a
t db_access.pm line 63.
Below is my script
my $XML_FILE="E:/Project/scripts/Master.xml";
my $ref = eval {
_days(NOW()) -1)
group by service,d ";
$sth = $dbh->prepare($query);
$sth->execute() or die "$dbh->errstr \n";
Thanks,
Chan Choth
Rob Dixon wrote:
> Puth Chan Choth wrote:
> > Hello all,
> >
> > Why do I get DBD::mysql::st execute failed: Got erro
Puth Chan Choth wrote:
> Hello all,
>
> Why do I get DBD::mysql::st execute failed: Got error -1 from table
> handler at sys.pl line 40? My line 40 is:
> $sth->execute() or die "$dbh->errstr \n";
>
> Thank you so much for your assistance.
It's my guess
Hello all,
Why do I get DBD::mysql::st execute failed: Got error -1 from table
handler at sys.pl line 40? My line 40 is:
$sth->execute() or die "$dbh->errstr \n";
Thank you so much for your assistance.
Best regards,
Chan Choth
--
To unsubscribe, e-mail: [EMAIL PROTECTED