-
Incident report
-
Resolution: Fixed
-
Major
-
1.8.2
-
None
-
2.6.31-20-server #58-Ubuntu
MySQL 5.1.32
Looks like this closed bug: ZBX-2248
Just installed Zabbix 1.8.2. All configs are default.
1. Go to Monitoring -> Screens
2. Try magnifying some part of any graph
And get errors:
- Error in query [INSERT INTO profiles (profileid, userid, idx, value_int, type, idx2) VALUES (135, 1, 'web.screens.period', 3600, 2, )] [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]
- Error in query [INSERT INTO profiles (profileid, userid, idx, value_str, type, idx2) VALUES (136, 1, 'web.screens.stime', '201004032135', 3, )] [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]
It seems that idx2 in not inserted into the query, because for eg. in this query it is inserted:
INSERT INTO profiles (profileid, userid, idx, value_int, type, idx2) VALUES (137, 1, 'web.auditlogs.filter.action', -1, 2, 0)
While searching for reasons I noticed, that when I pressed fullscreen button and then pressed it again for returning to previous state, these two errors disappeared, and new rows were entered into table and they had "2" as value for idx2.
Hope this helps.
- is duplicated by
-
ZBX-2440 Screen History with OracleDB
-
- Closed
-