Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-2267

[Screens] Error in SQL query wihle using graph

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Major Major
    • 1.8.3
    • 1.8.2
    • Frontend (F)
    • 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.

            Unassigned Unassigned
            tiffolk Vladimir Osipenko
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: