Install bug in 1.5beta5 - atoll

[alanjay]

When installing the 1.5 beta I got this error on an old machine FreeBSD 4.5

I suscessfully installed v1.0

source='server.c' object='server.o' libtool=no  DEPDIR=.deps depmode=gcc /bin/sh ../../
depcomp  gcc -DHAVE_CONFIG_H -I. -I. -I../../include -I../../include -I/usr/local/inclu
de/mysql     -g -O2 -c server.c
gcc  -g -O2   -o zabbix_server -L/usr/local/lib/mysql evalfunc.o expression.o  actions.
o zlog.o functions.o  server.o ../libs/zbxsysinfo/libzbxsysinfo.a ../libs/zbxsysinfo/fr
eebsd/libzbxsysinfo2.a  ../libs/zbxlog/libzbxlog.a ../libs/zbxpid/libzbxpid.a ../libs/z
bxconf/libzbxconf.a ../libs/zbxcrypto/libzbxcrypto.a ../libs/zbxnet/libzbxnet.a pinger/
libzbxpinger.a poller/libzbxpoller.a escalator/libzbxescalator.a housekeeper/libzbxhous
ekeeper.a alerter/libzbxalerter.a timer/libzbxtimer.a trapper/libzbxtrapper.a ../libs/z
bxemail/libzbxemail.a  ../libs/zbxdbhigh/libzbxdbhigh.a ../libs/zbxcommon/libzbxcommon.
a -lmysqlclient -lm -lz -lkvm
functions.o: In function `process_new_value':
/home/users/root/zabbix-1.1beta5/src/zabbix_server/functions.c(.text+0x18ee): undefined
 reference to `atoll'
../libs/zbxcommon/libzbxcommon.a(misc.o): In function `set_result_type':
/home/users/root/zabbix-1.1beta5/src/libs/zbxcommon/misc.c(.text+0x1ad): undefined refe
rence to `atoll'
*** Error code 1

Stop in /home/users/root/zabbix-1.1beta5/src/zabbix_server.
*** Error code 1

Stop in /home/users/root/zabbix-1.1beta5/src/zabbix_server.
*** Error code 1

Stop in /home/users/root/zabbix-1.1beta5/src.
*** Error code 1

Stop in /home/users/root/zabbix-1.1beta5.

[Alexei]

Replace atoll() with atol() and recompile. As far as I remember 4.5 libc does not provide atoll function.

[alanjay]

Thanks editing the two occurances of that manually the aplication compiles without a problem.

Now my only problem is that I don't seem to be able to add data to the database I always get error messages in the database upload ie

[ERROR:Configuration was not updated]

SQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Query: update config set alarm_history=365,alert_history=356,refresh_unsupp orted=

I am using mySQL 4.1.16

and errors like:

[ERROR:Configuration was not updated]

SQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'alert_history=,refresh_unsupported=60' at line 1
Query: update config set alarm_history=,alert_history=,refresh_unsupported= 60