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