Bug #69079 for DBD-mysql: DBD::mysql version 4.019 does not build against MySQL 4.0.27

Fri Jun 24 13:07:42 2011 kenp [...] cpanel.net - Ticket created

Subject:

DBD::mysql version 4.019 does not build against MySQL 4.0.27

Attempting to build DBD::mysql 4.019 against MySQL 4.0.27 results in failure. Relevant output: I will use the following settings for compiling and testing: cflags (mysql_config) = -I/usr/include/mysql -g embedded (mysql_config) = libs (mysql_config) = -L/usr/lib -lmysqlclient -lz -lcrypt -lnsl -lm mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb (default ) = test testhost (default ) = testpassword (default ) = testsocket (default ) = testuser (guessed ) = root To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Checking if your kit is complete... Looks good Using DBI 1.616 (for perl 5.008008 on x86_64-linux) installed in /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBI/ Writing Makefile for DBD::mysql -> OK Finding PREREQ from Makefile ... Checking if you have Data::Dumper 0 ... Yes (2.131) Checking if you have DBI 1.08 ... Yes (1.616) Building and testing DBD-mysql-4.019 cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm cc -c -I/usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBI -I/usr/include/mysql -g -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -fPIC -DPIC -m64 -fno-strict-aliasing -pipe - Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE - D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -Os -mmmx -msse -mfpmath=sse -msse2 - mssse3 -DVERSION=\"4.019\" -DXS_VERSION=\"4.019\" -fpic "- I/usr/local/lib/perl5/5.8.8/x86_64-linux/CORE" dbdimp.c dbdimp.c: In function ‘alloc_param’: dbdimp.c:223: warning: comparison is always false due to limited range of data type dbdimp.c: At top level: dbdimp.c:3481: error: expected identifier or ‘(’ before ‘if’ dbdimp.c:3501: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘->’ token dbdimp.c:3503: error: expected identifier or ‘(’ before ‘if’ dbdimp.c:3515: error: expected identifier or ‘(’ before ‘return’ dbdimp.c:3516: error: expected identifier or ‘(’ before ‘}’ token make: *** [dbdimp.o] Error 1

Tue Oct 11 18:10:03 2011 john [...] nixnuts.net - Correspondence added

On Fri Jun 24 13:07:42 2011, kpower wrote: Show quoted text

> Attempting to build DBD::mysql 4.019 against MySQL 4.0.27 results in > failure.

Patch attached that fixes the compile problem on my test system.

Subject:

mysql_4_compile.diff

--- dbdimp.c.orig 2011-08-20 13:35:59.000000000 -0500 +++ dbdimp.c 2011-10-11 17:05:45.000000000 -0500 @@ -3473,7 +3473,9 @@ return 0; } #endif +#if MYSQL_VERSION_ID >= SERVER_PREPARE_VERSION } +#endif if (imp_sth->row_num+1 != (my_ulonglong)-1) {

Tue Oct 11 18:10:05 2011 The RT System itself - Status changed from 'new' to 'open'

Wed Oct 12 05:55:43 2011 GRUBER [...] cpan.org - Correspondence added

On Tue Oct 11 18:10:03 2011, lightsey wrote: Show quoted text

> On Fri Jun 24 13:07:42 2011, kpower wrote:

> > Attempting to build DBD::mysql 4.019 against MySQL 4.0.27 results in > > failure.

> > Patch attached that fixes the compile problem on my test system.

Just encountered the error myself. I prefer a different patch: --- dbdimp.c.orig 2011-10-12 11:52:09.000000000 +0200 +++ dbdimp.c 2011-10-12 11:52:14.000000000 +0200 @@ -3455,8 +3455,9 @@ int dbd_st_execute(SV* sth, imp_sth_t* i &imp_sth- Show quoted text

>has_been_bound

); } - else { + else #endif + { imp_sth->row_num= mysql_st_internal_execute( sth, *statement,

Wed Oct 12 05:59:05 2011 GRUBER [...] cpan.org - Correspondence added

On Wed Oct 12 05:55:43 2011, GRUBER wrote: Show quoted text

> On Tue Oct 11 18:10:03 2011, lightsey wrote:

> > On Fri Jun 24 13:07:42 2011, kpower wrote:

> > > Attempting to build DBD::mysql 4.019 against MySQL 4.0.27 results in > > > failure.

> > > > Patch attached that fixes the compile problem on my test system.

> > Just encountered the error myself. I prefer a different patch:

Garbled patch, sorry, the correct one is attached.

Subject:

dbdimp.patch

--- dbdimp.c.orig 2011-10-12 11:52:09.000000000 +0200 +++ dbdimp.c 2011-10-12 11:52:14.000000000 +0200 @@ -3455,8 +3455,9 @@ int dbd_st_execute(SV* sth, imp_sth_t* i &imp_sth->has_been_bound ); } - else { + else #endif + { imp_sth->row_num= mysql_st_internal_execute( sth, *statement,

Thu Sep 12 17:44:40 2013 MICHIELB [...] cpan.org - Correspondence added

Hi, MySQL 4 is really very old and out of support by Oracle. Of course you're free to use it if it makes you happy, but please take an old DBD::mysql version to go with it. We'll remove MySQL 4 related code in the driver soon.

Thu Sep 12 17:44:41 2013 MICHIELB [...] cpan.org - Status changed from 'open' to 'rejected'

Fri Sep 13 08:27:24 2013 kenp [...] cpanel.net - Correspondence added

Subject:	Re: [rt.cpan.org #69079] DBD::mysql version 4.019 does not build against MySQL 4.0.27
Date:	Fri, 13 Sep 2013 07:27:09 -0500
To:	bug-DBD-mysql [...] rt.cpan.org
From:	Ken Power <kenp [...] cpanel.net>

OK. We've also moved away from MySQL 4.0. Thank you for the follow up. On Sep 12, 2013, at 4:44 PM, Michiel Beijen via RT <bug-DBD-mysql@rt.cpan.org> wrote: Show quoted text

> <URL: https://rt.cpan.org/Ticket/Display.html?id=69079 > > > Hi, MySQL 4 is really very old and out of support by Oracle. > > Of course you're free to use it if it makes you happy, but please take an old DBD::mysql version to go with it. We'll remove MySQL 4 related code in the driver soon.

Download signature.asc
application/pgp-signature 801b

Message body not shown because it is not plain text.