MySQL create/data/data.sql ERROR in 1.5 rev 5865

[cstackpole]

I believe I have found a bug with this revision. Can anyone confirm before I file a bug report?

Thanks!

# mysql -uzabbix -p zabbix <  create/data/data.sql 
Enter password: 
ERROR 1136 (21S01) at line 6603: Column count doesn't match value count at row 1

I have line 6603 to be:

INSERT INTO sysmaps_elements VALUES (2,2,10017,0,19,19,19,'ZABBIX Server',NULL,100,100,'');

[Alexei]

Thanks for reporting this. Please do not fill any bug reports yet. We are very close to 1.5.4, this issue will be fixed shortly.

[cstackpole]

OK, a bit of MySQL digging around in past revisions revealed that there was an extra field added to the table sysmaps_elements.

| iconid_disabled | bigint(20) unsigned | NO   |     | 0       |       |

So I changed this:

INSERT INTO sysmaps_elements VALUES (2,2,10017,0,19,19,19,'ZABBIX Server',NULL,100,100,'');

to this:

mysql> INSERT INTO sysmaps_elements VALUES (2,2,10017,0,19,19,19,'ZABBIX Server',NULL,100,100,'',0);
Query OK, 1 row affected (0.01 sec)

and it worked. Of course I don't know if that is the proper value, but it at least works in the SQL.

[EDIT] I just saw your post Alexei. So I will not file a report. Thanks!

[Sasha]

Thank you! Fixed in rev. 5872.