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

    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

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

              Dates

                Created:
                Updated:
                Resolved: