upcp DBD-mysql-4.004 installation errors

jamesbond

Well-Known Member
Oct 9, 2002
738
1
168
For over a month I noticed a problem in the upcp mails regarding DBD-mysql (see below). Will the next version (4.005?) possible contain a fix or do I need to upgrade something? I am running Perl 5.8.7 and MySQL 4.0.27 on CentOS 4.5.


Code:
Running install for module 'DBD::mysql'
Running make for C/CA/CAPTTOFU/DBD-mysql-4.004.tar.gz
CPAN: Digest::SHA loaded ok (v5.44)
Checksum for /home/.cpan/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.004.tar.gz ok
DBD-mysql-4.004/
...
...
...
cc -c  -I/usr/lib/perl5/site_perl/5.8.7/i686-linux/auto/DBI -I/usr/include/mysql -g -pipe -march=i386 -mcpu=i686 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2   -DVERSION=\"4.004\" -DXS_VERSION=\"4.004\" -fpic "-I/usr/lib/perl5/5.8.7/i686-linux/CORE"   dbdimp.c
dbdimp.c: In function `mysql_st_fetch':
dbdimp.c:3429: error: too few arguments to function `mysql_dr_error'
dbdimp.c:3593: error: too few arguments to function `mysql_dr_error'
dbdimp.c: In function `mysql_st_FETCH_internal':
dbdimp.c:3931: error: too few arguments to function `mysql_dr_error'
dbdimp.c:3945: error: too few arguments to function `mysql_dr_error'
dbdimp.c: In function `mysql_bind_ph':
dbdimp.c:4264: error: too few arguments to function `mysql_dr_error'
dbdimp.c:4291: error: too few arguments to function `mysql_dr_error'
dbdimp.c:4303: error: too few arguments to function `mysql_dr_error'
dbdimp.c: In function `mysql_db_reconnect':
dbdimp.c:4465: error: too few arguments to function `mysql_dr_error'
make: *** [dbdimp.o] Error 1
 

sparek-3

Well-Known Member
Aug 10, 2002
1,983
218
343
cPanel Access Level
Root Administrator
I believe this is because you are running MySQL 4.0 and not MySQL 4.1.

The simple solution is to upgrade to MySQL 4.1. MySQL 4.0 is considerably old and I'm really not even sure if cPanel is support MySQL 4.0 any more.
 

jamesbond

Well-Known Member
Oct 9, 2002
738
1
168
Hello Sparek, 4.0.27 is indeed pretty old, I've always been a bit afraid to upgrade since I have quite a few phhp/mysql sites on the server.

I guess I should upgrade. I just want to be able to revert back to 4.0 in case there any problems.

What I plan to do is:

1. make a copy of /var/lib/mysql
2. go in to whm -> upgrade to mysql 4.1 (check old passwords)
3. check for errors:
-if no erros, then that's great!
-if there are (many) errors, then restore the /var/lib/mysql copy and downgrade to 4.0

This should work, right?

Is there a way to check for compatibility issues beforehand? I did check to make sure all tables are MyISAM (.MYD).