Re: [Observium] Last update, upgrading schema fails

2012/3/12 Adam Armstrong adama@memetic.org:

Delete database, recreate it and then re-add and rediscover devices

Adam.

Sent from my Android phone with K-9 Mail. Please excuse my brevity.

Well, taking a look at the schema update files, I saw that I had all the changes declared in 006.sql, except the new column for dbSchema. The 007.sql tries to drop the only column on the table, which is not supported.

As a workaround I added the missing column hand (as stated in 006.sql):

ALTER TABLE `dbSchema` ADD `version` INT NOT NULL;

And after that the 007.sql run without issues.

Regards,