DBD::mysql installing error

--0-698609578-1152756490=:53636
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit

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!
--0-698609578-1152756490=:53636--

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
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: DBD::mysql installing error

--0-1411717350-1152786061=:9661
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit

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"
To:
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!
--0-1411717350-1152786061=:9661--

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"
>
> To:
> 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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: DBD::mysql installing error

--0-25531002-1153103433=:15761
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit

Hi,
it seems lampp installation doesn't include some header file. I've downloaded mysql-devel and install it. Now, there's no error and installation succedded.
Thanks a lot for your help and regards,

sinti
----- Original Message ----- From: "Martin J. Evans"
To:
Sent: Thursday, July 13, 2006 8:20 PM
Subject: 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
>
>

---------------------------------
Apakah Anda Yahoo!?
Kunjungi halaman depan Yahoo! Indonesia yang baru!
--0-25531002-1153103433=:15761--