On 2013-05-13 16:19, Hynek Med wrote:
Unfortunately I have less information than wish for. :( After some digging in old backups, I think the change was from r3465 to r3981. After that update no new events were noticed (and no alerts sent).
Looking at a newer Observium installation, I found that the eventlog table fields got renamed, so the script couldn't insert new entries. After renaming host to device_id and datetime to timestamp it works.
Was there some other database structure change between r3465-r3981 or anything else I should take care of ?
Database changes should all be performed automatically.
r3465 to r3981 is a very large jump, you shouldn't wait so long to upgrade.
I think the change in question was in r3710 and was performed by sql-schema/048.sql
Note that you /must/ run the discovery script after an SVN up to ensure that the database schema is updated.
r3981 was 2 weeks ago, I assume you've updated since then?
adam.