Hello.

First of all, I'm not using MySQL and Perl *professionally* and I need this module working for some other piece of software. The problem is that any version higher than DBD-mysql-4.010 fails to pass the "make test" command. Still, it compiles (with "make") just fine. Now, I've tried different versions of MySQL (compiled from source with only one ./configure option - --prefix=/usr) and DBI but it hasn't changed anything. "Make test" looks like this:

PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base....................ok
t/10connect.................ok
t/20createdrop..............ok
t/25lockunlock..............ok
t/29warnings................ok
t/30insertfetch.............ok
t/31insertid................ok
t/32insert_error............ok
t/35limit...................ok
t/35prepare.................ok
t/40bindparam...............ok
t/40bindparam2..............ok
t/40blobs...................ok
t/40catalog.................ok
t/40keyinfo.................ok
t/40listfields..............ok
t/40nulls...................ok
t/40numrows.................ok
t/40server_prepare..........ok 1/21DBD::mysql::st execute failed: Incorrect arguments to mysql_stmt_execute at t/40server_prepare.t line 35.
DBD::mysql::st execute failed: Incorrect arguments to mysql_stmt_execute at t/40server_prepare.t line 35.
Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at t/40server_prepare.t line 35.
# Looks like you planned 21 tests but only ran 4.
# Looks like your test died just after 4.
t/40server_prepare..........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 5-21
Failed 17/21 tests, 19.05% okay
t/40server_prepare_error....ok
t/40types...................ok
t/41bindparam...............ok
t/41blobs_prepare...........ok
t/42bindparam...............ok
t/50chopblanks..............ok
t/50commit..................ok
t/51bind_type_guessing......ok
t/55utf8....................ok
t/60leaks...................skipped
all skipped: Skip $ENV{SLOW_TESTS} is not set
t/65types...................ok
t/70takeimp.................ok
t/71impdata.................ok
t/75supported_sql...........ok
t/76multi_statement.........ok
t/80procs...................ok
Failed Test Stat Wstat Total Fail List of Failed
-------------------------------------------------------------------------------
t/40server_prepare.t 255 65280 21 34 5-21
1 test skipped.
Failed 1/35 test scripts. 17/731 subtests failed.
Files=35, Tests=731, 6 wallclock secs ( 3.27 cusr + 0.34 csys = 3.61 CPU)
Failed 1/35 test programs. 17/731 subtests failed.
make: *** [test_dynamic] Error 255

It tried googling for this error but I didn't manage to find "DBD::mysql::st execute failed" and "Incorrect arguments to mysql_stmt_execute" in the same description of the problem (most posts found were written by programmers and concerned their own code anyway). My current software:

- PERL 5.10.0 (Ubuntu 9.10 Server default)
- DBI 1.609 (compiled from source)
- MySQL 5.1.42 (compiled from source)

Any suggestions will be greatly appreciated. Thanks.

Cheers,