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

Incorrect date format in UPDATE query for maintenance daily period

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: 2.0.6rc1, 2.1.0
    • Fix Version/s: 2.0.7rc1, 2.1.0
    • Component/s: Frontend (F)
    • Labels:

      Description

      Seems date is not converted to unixtime:
      SQL error [ORA-01438: value larger than specified precision allowed for this column] in [UPDATE timeperiods SET timeperiodid='1', timeperiod_type='2', every='1', month='0', dayofweek='0', day='1', start_time='43200', start_date='201304171020', period='4320' WHERE timeperiodid='1']

      for mysql:
      SQL (0.00037): UPDATE timeperiods SET timeperiodid='2', timeperiod_type='2', every='1', month='0', dayofweek='0', day='1', start_time='43200', start_date='197001010260', period='5640' WHERE timeperiodid='2'
      CAPIObject->update() > CAPIObject>__call() > czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CMaintenance>update() > CMaintenance>replaceTimePeriods() -> DB::replace() -> DB::save() -> DB::updateByPk() -> DB::update() -> DBexecute()

      To reproduce it create a maintenance with daily period, Save and try update recently added period (for example, change time start).

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              dotneft Alexey Pustovalov
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: