Re: DBD::mysql installing error

Did you mention what versions of mysql you are building against?
It looks like it might be MySQL 5.0.15.

Have you got the file mysql_com.h and does it contain
a definition for FIELD_TYPE_LONGLONG etc (as per the errors below)?

Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com


On 13-Jul-2006 yasinti wrote:
> Hi,
>   when I run  perl -MDBI -e 'print $DBI::VERSION,"\n"' , it's 1.51. That's my
> DBI version.
>   I've had DBD-mysql-3.0006, extracted it and ran 'make', but still got the
> same error.
>   Thanks and regards,
>    
>   sinti
>   ----- Original Message -----   From: "Martin J. Evans"
> <[email protected]>
>   To: <[email protected]>
>   Sent: Thursday, July 13, 2006 3:34 PM
>   Subject: RE: DBD::mysql installing error
> 
>   
> 
>   > Looks like DBD::mysql 2.9008 is out of sync with your DBI version.
>> 
>> What does 
>> perl -MDBI -e 'print $DBI::VERSION,"\n"'
>> output?
>> 
>> If it later than 1.4n I would get a more recent DBD::mysql like
>> DBD-mysql-3.0006 and try again.
>> 
>> The latest DBI is 1.51.
>> 
>> Martin
>> --
>> Martin J. Evans
>> Easysoft Ltd, UK
>> http://www.easysoft.com
>> 
>> 
>> On 13-Jul-2006 yasinti wrote:
>>> Hi,
>>>   I got a lot of error when I tried to install DBD::mysql module using
>>> DBD-mysql-2.9008.tar.gz. 
>>>   When I ran a command 'make' after I ran 'perl Makefile.PL', errors came
>>>   up.
>>>   The errors like bellow:
>>>   =====================================================
>>>   dbdimp.c:713: (near initialization for
>>> `SQL_GET_TYPE_INFO_values[53].native_type
>>> ')
>>> dbdimp.c:714: initializer element is not constant
>>> dbdimp.c:714: (near initialization for `SQL_GET_TYPE_INFO_values[53]')
>>> dbdimp.c:720: `FIELD_TYPE_LONGLONG' undeclared here (not in a function)
>>> dbdimp.c:720: initializer element is not constant
>>> dbdimp.c:720: (near initialization for
>>> `SQL_GET_TYPE_INFO_values[54].native_type
>>> ')
>>> dbdimp.c:721: initializer element is not constant
>>> dbdimp.c:721: (near initialization for `SQL_GET_TYPE_INFO_values[54]')
>>> dbdimp.c: In function `native2sql':
>>> dbdimp.c:729: `FIELD_TYPE_VAR_STRING' undeclared (first use in this
>>> function)
>>>   .
>>>   .
>>>   .
>>>   dbdimp.c: In function `mysql_dr_connect':
>>> dbdimp.c:855: `MYSQL' undeclared (first use in this function)
>>> dbdimp.c:855: `result' undeclared (first use in this function)
>>> dbdimp.c:857: `host' undeclared (first use in this function)
>>> dbdimp.c:858: `port' undeclared (first use in this function)
>>> dbdimp.c:863: `user' undeclared (first use in this function)
>>> dbdimp.c:864: `password' undeclared (first use in this function)
>>> dbdimp.c:878: `CLIENT_FOUND_ROWS' undeclared (first use in this function)
>>> dbdimp.c:880: `sock' undeclared (first use in this function)
>>> dbdimp.c:882: `imp_dbh' undeclared (first use in this function)
>>> dbdimp.c:897: `MYSQL_OPT_COMPRESS' undeclared (first use in this function)
>>> dbdimp.c:906: `MYSQL_OPT_CONNECT_TIMEOUT' undeclared (first use in this
>>> function
>>>   .
>>>   .
>>>   .
>>>   dbdimp.c:2419: dereferencing pointer to incomplete type
>>> dbdimp.c:2420: dereferencing pointer to incomplete type
>>> dbdimp.c:2423: dereferencing pointer to incomplete type
>>> dbdimp.c: In function `mysql_db_quote':
>>> dbdimp.c:2559: dereferencing pointer to incomplete type
>>> dbdimp.c: In function `mysql_db_last_insert_id':
>>> dbdimp.c:2575: dereferencing pointer to incomplete type
>>> make: *** [dbdimp.o] Error 1
>>>   ================================================
>>>   I've tried to change some parameter when running 'perl Makefile.PL', such
>>> as --testuser=root, --testhost=localhost.
>>>   I use xampp/lampp bundle (Apache 2.0.55, MySQL 5.0.15, Perl 5.8.7, etc).
>>>   Is there something wrong?
>>>   Thanks a lot and regards,
>>>    
>>>   sinti
>>> 
>>>               
>>> ---------------------------------
>>> Apakah Anda Yahoo!?
>>> Kunjungi halaman depan Yahoo! Indonesia yang baru!
>> 
>> -- 
>> MySQL Perl Mailing List
> 
> 
>               
> ---------------------------------
> Apakah Anda Yahoo!?
> Kunjungi halaman depan Yahoo! Indonesia yang baru!

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]