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

negative time values accepted/interpreted in maintenance periods

    XMLWordPrintable

    Details

    • Type: Problem report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Cannot Reproduce
    • Affects Version/s: 3.4.0beta1
    • Fix Version/s: None
    • Component/s: Frontend (F)

      Description

      create a new maintenance period, switch to the "periods" tab. add a period.
      switch to daily, weekly or monthly and enter "-2" for both hours and minutes. add the period.

      notice how the negative hour is kept (displayed as "At 0-3:58"), but the negative minute ended up being subtracted from the time, reducing the hour value by one.

      attempting to save such a maintenance period results in an sql error :

      Error in query [INSERT INTO timeperiods (timeperiod_type,every,month,dayofweek,day,start_time,start_date,period,timeperiodid) VALUES ('2','1','256','0','2','-7320','20170803000000','82800','1')] [Out of range value for column 'start_date' at row 1]

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            richlv richlv
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: