Click here to get back home

DBD::mysql test errors on Win32

 HomeNewsGroups | Search | About
 comp.lang.perl.modules    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
DBD::mysql test errors on Win32 Brian 09-02-2005
Posted by Brian on September 2, 2005, 2:54 pm
Please log in for more thread options


Hello All,

I am trying to build DBD::mysql for Win32, but am having a few
errors on the 'nmake test'. The compiler is MS VS.NET 2003, version of
mysqlclient.lib is 4.1.13a and the version of perl is 5.8.5. We do not
use ActiveState Perl, so I do not have the option of using the
pre-built module (or perhaps I could as long as the correct version of
mySQL library, 4.1.13a, is linked in). I am statically linking the
mysqlclient.lib file in. This was built from source as the provided
library created unresolved symbols when linking (and the solution
suggested was to build from source). Below is an excerpt from the
'nmake test' which shows the error. I can post more information if
required, but did not to make this post too long. Thank you for any
insight into what this error message means.

-brian

------------------
tchopblanks.......ok
tcommit...........ok
tleaks............skipped
all skipped: $ENV is not set or Proc::ProcessTable
not installed
t\ak-dbd.............ok 1/90DBD::mysql::FIELD_TYPE_STRING: Not defined
at t\ak-dbd.t line 68
t\ak-dbd.............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-90
Failed 89/90 tests, 1.11% okay
t\akmisc.............ok 22/351Mysql::FIELD_TYPE_STRING: Not defined in
Mysql and not autoloadable (last try fieldtypestring) at t\akmisc.t
line 252
t\akmisc.............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 23-351
Failed 329/351 tests, 6.27% okay



Posted by Sisyphus on September 3, 2005, 12:29 pm
Please log in for more thread options



> Hello All,
>
> I am trying to build DBD::mysql for Win32, but am having a few
> errors on the 'nmake test'. The compiler is MS VS.NET 2003, version of
> mysqlclient.lib is 4.1.13a and the version of perl is 5.8.5. We do not
> use ActiveState Perl, so I do not have the option of using the
> pre-built module (or perhaps I could as long as the correct version of
> mySQL library, 4.1.13a, is linked in).

Yes - I think you'll find that the ActiveState binary works fine with your
perl (assuming they've built their binary against a suitable version of the
mySQL library). ActiveState binaries will generally work fine with a perl
built using MS VS.NET 2003. Exceptions are possible - I know only of one
such exception (Win32::SharedFileOpen) ...... well .... it would be an
exception ..... except that last time I looked, ActiveState didn't have a
binary for it anyway :-)

> I am statically linking the
> mysqlclient.lib file in. This was built from source as the provided
> library created unresolved symbols when linking (and the solution
> suggested was to build from source). Below is an excerpt from the
> 'nmake test' which shows the error. I can post more information if
> required, but did not to make this post too long. Thank you for any
> insight into what this error message means.
>
> -brian
>
> ------------------
> tchopblanks.......ok
> tcommit...........ok
> tleaks............skipped
> all skipped: $ENV is not set or Proc::ProcessTable
> not installed
> t\ak-dbd.............ok 1/90DBD::mysql::FIELD_TYPE_STRING: Not defined
> at t\ak-dbd.t line 68
> t\ak-dbd.............dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 2-90
> Failed 89/90 tests, 1.11% okay
> t\akmisc.............ok 22/351Mysql::FIELD_TYPE_STRING: Not defined in
> Mysql and not autoloadable (last try fieldtypestring) at t\akmisc.t
> line 252
> t\akmisc.............dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 23-351
> Failed 329/351 tests, 6.27% okay
>

Can't really help much with that. Looks like 2 different (but probably
connected) complaints. First complaint is that DBD::mysql::FIELD_TYPE_STRING
(which is a perl constant) is not defined, and second complaint is that the
Mysql library constant FIELD_TYPE_STRING is not defined. One thing you could
do is to find out from the Mysql folk whether or not FIELD_TYPE_STRING
should exist in your particular version of the Mysql library. (Or maybe
there's something in a Mysql library Change log that will give you that
answer.)

Cheers,
Rob




Posted by Brian on September 5, 2005, 10:45 am
Please log in for more thread options


Thank you for the reply - I should make sure to check in when posting
right before the weekend... I'll check out the ActiveState PERL and
see what versions they have. Also, I'll check my version of the
mysqlclient.lib to make sure that it has all required symbols. If it
is not defined in the .lib, then that is probably why it does not exist
in the .pm (although I am not very familiar with calling C code from
PERL). Again, thank you for the insight; it gives me somewhere else to
look.



Similar ThreadsPosted
Catalog() in Win32::ODBC for MySQL August 27, 2006, 1:58 am
[RESOLVED] DBD::mysql unresolved symbol _intel_fast_memcpy & mysql-standard-5.0.22-linux-i686-icc-glibc23 August 29, 2006, 6:33 pm
MySQL 5.0 and Perl DBD-MySQL December 3, 2005, 1:10 am
Embedded mysql with DBD::mysql July 30, 2008, 10:15 am
DBD:mysql doesn't read mysql option file /etc/my.cnf file January 27, 2005, 11:19 pm
Dave Roth's site (Win32::AdminMisc, Win32::ODBC, etc.) not available. December 22, 2005, 8:46 am
Strange errors August 9, 2004, 7:17 pm
How do I trap DBI errors? May 16, 2006, 5:49 am
Problems installing Win32-Setupsup, Win32-CtrlGUI October 10, 2004, 12:31 am
Sybperl errors on Solaris 2.9 March 2, 2005, 8:52 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap