Re: [Observium] Last update, upgrading schema fails

-- Sent from my Android phone with K-9 Mail. Please excuse my brevity. Dennis Kruyt d.kruyt@zx.nl wrote: 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 _____________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium