Hi,

I updated to revision 2891, but still have a error.

root@observium:/opt/observium# php includes/sql-schema/update.php -d

SQL[SELECT version FROM `dbSchema` ORDER BY version DESC LIMIT 1] SQL[SELECT revision FROM `dbSchema`] -- Transitioning from old revision-based schema to database version system -- Updating database schema 006 -> 007 ...ALTER TABLE `dbSchema` DROP `revision`; You can't delete all columns with ALTER TABLE; use DROP TABLE instead done (1 errors).

SQL[INSERT INTO `dbSchema` (`version`) VALUES ('007')] PHP Warning: QDB - Insert failed. in /var/opt/observium/includes/dbFacile.php on line 77 PHP Notice: Undefined index: insert_sec in /var/opt/observium/includes/dbFacile.php on line 86 PHP Notice: Undefined index: insert in /var/opt/observium/includes/dbFacile.php on line 87 PHP Notice: Undefined variable: id in /var/opt/observium/includes/dbFacile.php on line 89 -- Done

regards,

Dennis Kruyt,-

-----Original Message----- From: observium-bounces@observium.org [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong Sent: Thursday, March 08, 2012 12:13 PM To: Observium Network Observation System Subject: Re: [Observium] Last update, upgrading schema fails

I think this is all fixed now. It shouldn't have broken anything afaik :)

adam

On 2012-02-28 11:51, Ciro Iriarte wrote:

Hi, reporting a schema failure with rev2880:

---

wwwrun@cplanning:/opt/observium> php includes/sql-schema/update.php -d

SQL[SELECT version FROM `dbSchema`] SQL[SELECT revision FROM `dbSchema`] -- Transitioning from old revision-based schema to database version system -- Updating database schema 006 -> 007 ...ALTER TABLE `dbSchema` DROP `revision`; You can't delete all columns with ALTER TABLE; use DROP TABLE instead done (1 errors).

SQL[INSERT INTO `dbSchema` (`version`) VALUES ('007')] PHP Warning: QDB - Insert failed. in /opt/observium/includes/dbFacile.php on line 77 PHP Notice: Undefined index: insert_sec in /opt/observium/includes/dbFacile.php on line 86 PHP Notice: Undefined index: insert in /opt/observium/includes/dbFacile.php on line 87 PHP Notice: Undefined variable: id in /opt/observium/includes/dbFacile.php on line 89

-- Done

Regards,

_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

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,