Issue with the host System for our Spectroserver had the locale time change incorrectly to 2018

Document ID : KB000016509
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

A problem exists where the host System for our spectroserver had the locale time change incorrectly to 2018 – How can we remove these unwanted events?

Answer:

In a scenario where a hosts system locale changed to an incorrect future date and time (for example in 2017 the date and time was changed to 2018) you can remove these unwanted events by doing the following:

1.      Log into mysql and use the Archive Manager ddmdb:

 

Windows            ./mysql  uroot  proot ddmdb;

Linux                    ./mysql --defaults-file=../my-spectrum.cnf -uroot –proot ddmdb;

2.      Delete the events from 2018 using mysql query:

 

Delete from event where time > ‘2018-01-01 00:00:00’;

Note: you can modify the year and date as required. Also take care that the year and date are set correctly or you may lose current events.