-
Incident report
-
Resolution: Fixed
-
Trivial
-
2.0.6rc1, 2.1.0
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).
- is duplicated by
-
ZBX-6806 Can not change maintenance period on WEB UI Frontend with PostgreSQL
- Closed