DBD::mysql error

[gvim]

MySQL 5.5.11
Perl 5.14.0
DBI 1.616
DBD::mysql 4.018

Installing the DBD::mysql on OS X Snow Leopard 10.6.6, I ran `perl Makefile.PL` 
fine but `make test` produced:

# make test
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
/usr/bin/gcc-4.2 -c  -I/sw/lib/perl5/site_perl/5.14.0/darwin-multi-2level/auto/DBI -I/usr/local/mysql/include 
 -Os -g -fno-common -fno-strict-aliasing -arch x86_64 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -O2 -arch x86_64 
-fno-common -DPERL_DARWIN -I/sw/include -no-cpp-precomp -fno-strict-aliasing -pipe -fstack-protector 
-I/usr/local/include -I/opt/local/include -O3   -DVERSION=\4.018\ 
-DXS_VERSION=\4.018\  -I/sw/lib/perl5/5.14.0/darwin-multi-2level/CORE   dbdimp.c
dbdimp.c: In function 'mysql_db_FETCH_attrib':
dbdimp.c:2447: error: 'sv_undef' undeclared (first use in this function)
dbdimp.c:2447: error: (Each undeclared identifier is reported only once
dbdimp.c:2447: error: for each function it appears in.)
dbdimp.c: In function 'mysql_st_internal_execute41':
dbdimp.c:3298: warning: format '%d' expects type 'int', but argument 3 has type 
'my_ulonglong'
dbdimp.c: In function 'mysql_describe':
dbdimp.c:3517: warning: format '%d' expects type 'int', but argument 5 has type 
'long unsigned int'
dbdimp.c:3521: warning: format '%d' expects type 'int', but argument 3 has type 
'long unsigned int'
dbdimp.c: In function 'mysql_st_fetch':
dbdimp.c:3738: warning: format '%d' expects type 'int', but argument 3 has type 
'long int'
dbdimp.c:3780: warning: format '%08lx' expects type 'long unsigned int', but 
argument 3 has type 'struct MYSQL_RES *'
dbdimp.c:3782: warning: format '%llu' expects type 'long long unsigned int', 
but argument 3 has type 'unsigned int'
dbdimp.c: In function 'mysql_st_FETCH_attrib':
dbdimp.c:4365: warning: format '%d' expects type 'int', but argument 3 has type 
'my_ulonglong'
dbdimp.c: In function 'mysql_bind_ph':
dbdimp.c:4571: warning: format '%d' expects type 'int', but argument 3 has type 
'IV'
dbdimp.c:4583: warning: format '%d' expects type 'int', but argument 3 has type 
'IV'
dbdimp.c:4595: warning: format '%d' expects type 'int', but argument 3 has type 
'IV'
dbdimp.c:4609: warning: format '%d' expects type 'int', but argument 3 has type 
'IV'
dbdimp.c:4630: warning: format '%d' expects type 'int', but argument 5 has type 
'IV'
make: *** [dbdimp.o] Error 1

What could be the cause of the errors?

gvim




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Design: how to prioritise 1-to-many fields

[gvim]

I have a typical contact database which caters for multiple email addresses 
with a distinct Email table keyed to a foreign key inside the Contact table, 
ie. a 1-to-many relationship. However, I want to prioritise these Email entries 
for a given Contact entry so all I can think of is to add a numeric Priority 
field alongside the Address field inside the Email table. Is this the 
best/standard solution or is there another way?

gvim

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org