Zabbix 1.8.2 bug: Complex reports

[rincewind]

In complex reports with graphs, in case you're changing scaling period or shit thru report line, after commiting period goes following error

 Error in query [INSERT INTO profiles (profileid, userid, idx, value_int, type, idx2) VALUES (292, 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 (293, 1, 'web.screens.stime', '201005170633', 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]

[rincewind]

Really? Why would you use that on the official Zabbix website? It is inappropriate.

Omg, I just misspelled, must be shift of cource

[satchelp]

I have this same issue. Is there a fix for this?

[fableman]

In complex reports with graphs, in case you're changing scaling period or shit thru report line, after commiting period goes following error

 Error in query [INSERT INTO profiles (profileid, userid, idx, value_int, type, idx2) VALUES (292, 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 (293, 1, 'web.screens.stime', '201005170633', 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]

Any solution ?

[yohanan]

I had had the same error

Any solution ?

Until ran this
INSERT INTO profiles (profileid, userid, idx, value_int, type, idx2) VALUES (292, 1, 'web.screens.period', 3600, 2,1). Now I don't have any problems with chart but errors appears.

[whitehat]

same problem!

I have the same problem with fresh install of zabbix 1.8.2 from debian repository\
Found solution here
You just need to enter full-screen (button upper-right) once and the problem is gone