Zabbix 1.5.2 (trunk 5675) - Master and Child Node Sync Problem

[Palmertree]

Child Node is not syncing to the master node correctly.

See the following error on the master server node in the zabbix_server.log:

2808:20080502:015347 Query failed: [insert into node_cksum (nodeid,tablename,recordid,cksumtype,cksum) select 2,'actions',actionid,1,concat_ws(',',md5(name),eve ntsource,evaltype,status) from actions where 1=1 and actionid between 200000000000000 and 299999999999999and actionid=200200000000002
] 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 'actionid=200200000000002' at line 1 [1064]

[Palmertree]

Looks like a space issue between "and" and the value:
and 299999999999999and actionid=200200000000002

[Palmertree]

Found the problem. After making the following correction my master and child nodes are synced to each other.

In nodesender.c make the following modification by adding a space which is shown in red on line 150:

Before:

148                 if (0 != id) {
149                         zbx_snprintf_alloc(&sql, &sql_allocated, &sql_offset, 128,
150                                 [COLOR="Red"]"and %s="ZBX_FS_UI64,[/COLOR]
151                                 tables[t].recid,
152                                 id);

After:

148                 if (0 != id) {
149                         zbx_snprintf_alloc(&sql, &sql_allocated, &sql_offset, 128,
150                                 [COLOR="Red"]" and %s="ZBX_FS_UI64,[/COLOR]
151                                 tables[t].recid,
152                                 id);

[Aly]

Space Added. Thanks a lot for your Help