zabbix 1.6 CLIENT_MULTI_STATEMENTS

[gedp]

Trying to upgrade to 1.6 and have the following error when compiling:

make[3]: Entering directory `/home/zabbix/zabbix-1.6/src/libs/zbxdb'
if gcc -DHAVE_CONFIG_H -I. -I. -I../../../include -g -O2 -I/usr/include/mysql -march=i586 -mcpu=i68
6 -fmessage-length=0 -DPIC -fPIC -fno-strict-aliasing -I/usr/include/rpm -I. -I/usr/include -MT db
.o -MD -MP -MF ".deps/db.Tpo" -c -o db.o db.c; \
then mv -f ".deps/db.Tpo" ".deps/db.Po"; else rm -f ".deps/db.Tpo"; exit 1; fi
db.c: In function `zbx_db_connect':
db.c:87: error: `CLIENT_MULTI_STATEMENTS' undeclared (first use in this function)
db.c:87: error: (Each undeclared identifier is reported only once
db.c:87: error: for each function it appears in.)
make[3]: *** [db.o] Error 1

Could not find any reference of the CLIENT_MULTI_STATEMENTS in any of the files.

OS is SuSE SLES 9 SP2.
mysql Ver 12.22 Distrib 4.0.18, for suse-linux (i686)

Would appreciate help. Stupid me already upgraded the database with patch.sql....

Thanks,

Geert

[gedp]

mysql version

My current version is mysql Ver 12.22 Distrib 4.0.18, for suse-linux (i686)
The doc says 4.x should be ok, but I'm wondering if there isn't a problem somewhere
with the version. Next to the CLIENT_MULTI_STATEMENTS error, I also have:

../../src/libs/zbxdb/libzbxdb.a(db.o)(.text+0x363): In function `zbx_db_vexecute':
/home/zabbix/zabbix-1.6/src/libs/zbxdb/db.c:470: undefined reference to `mysql_next_result'

which make me wondering if the multi statement maybe came in a later version of mysql and that we need a specific version to be able to run the zabbix 1.6?