This is almost certainly caused by running a non-standard version of MySQL with strict mode enabled.

You're running MySQL from a source other than your distribution's default packages, right?

Your database probably needs to be wiped out and rebuilt.

adam.

On 25/03/2015 10:24:06, Patrick Marquetecken <patrick@marquetecken.be> wrote:
Hi,

It seems that I have some problems with my database structure

Perhaps related to my alerts & evenlog problems.

[2015/01/18 15:05:14 +0100] update.php(2459): ====== Schema update 137
-> 138 ==============
[2015/01/18 15:05:14 +0100] update.php(2459): Query: ALTER TABLE
`sensors` ADD `entPhysicalIndex_measured` varchar(16) COLLATE
utf8_unicode_ci DEFAULT NULL AFTER `sensor_custom_limit`;
[2015/01/18 15:05:14 +0100] update.php(2459): Error: Duplicate column
name 'entPhysicalIndex_measured'
[2015/01/18 15:05:14 +0100] update.php(2459): Query: ALTER TABLE
`sensors` ADD `measured_class` VARCHAR( 32 ) NULL DEFAULT NULL AFTER
`entPhysicalIndex_measured`;
[2015/01/18 15:05:14 +0100] update.php(2459): Error: Duplicate column
name 'measured_class'
[2015/01/18 15:05:14 +0100] update.php(2459): Query: ALTER TABLE
`sensors` ADD `measured_entity` VARCHAR( 32 ) NULL DEFAULT NULL AFTER
`measured_class`;
[2015/01/18 15:05:14 +0100] update.php(2459): Error: Duplicate column
name 'measured_entity'
[2015/03/23 14:23:56 +0100] discovery.php(31115): ====== Schema update
183 -> 184 ==============
[2015/03/23 14:23:56 +0100] discovery.php(31115): Query: ALTER TABLE
`eventlog` CHANGE `reference` `entity_id` INT( 64 ) NULL DEFAULT NULL;
[2015/03/23 14:23:56 +0100] discovery.php(31115): Error: (1366)
Incorrect integer value: 'NULL' for column 'entity_id' at row 1
[2015/03/23 14:23:56 +0100] discovery.php(31115): Query: ALTER TABLE
`eventlog` ADD `severity` TINYINT NOT NULL DEFAULT '6' AFTER `entity_id`;
[2015/03/23 14:23:56 +0100] discovery.php(31115): Error: (1054) Unknown
column 'entity_id' in 'eventlog'
[2015/03/23 14:23:56 +0100] discovery.php(31115): Query: UPDATE
`eventlog` SET `severity` = 4 WHERE `message` REGEXP '(above|under)
threshold';
[2015/03/23 14:23:56 +0100] discovery.php(31115): Error: (1054) Unknown
column 'severity' in 'field list'
[2015/03/23 14:23:56 +0100] discovery.php(31115): Query: UPDATE
`eventlog` SET `severity` = 5 WHERE `message` REGEXP ' [.(.]by
(user|cron|console)';
[2015/03/23 14:23:56 +0100] discovery.php(31115): Error: (1054) Unknown
column 'severity' in 'field list'
[2015/03/23 14:23:56 +0100] discovery.php(31115): Query: UPDATE
`eventlog` SET `severity` = 3 WHERE `message` LIKE 'Device status
changed to%';
[2015/03/23 14:23:56 +0100] discovery.php(31115): Error: (1054) Unknown
column 'severity' in 'field list'
[2015/03/23 14:23:56 +0100] discovery.php(31115): Query: UPDATE
`eventlog` SET `severity` = 4 WHERE `message` LIKE '%probably the device
was replaced%';
[2015/03/23 14:23:56 +0100] discovery.php(31115): Error: (1054) Unknown
column 'severity' in 'field list'
[2015/03/23 14:23:56 +0100] discovery.php(31115): Query: UPDATE
`eventlog` SET `severity` = 4 WHERE `message` LIKE 'OS changed%';
[2015/03/23 14:23:56 +0100] discovery.php(31115): Error: (1054) Unknown
column 'severity' in 'field list'
[2015/03/23 14:23:56 +0100] discovery.php(31115): Query: UPDATE
`eventlog` SET `severity` = 4 WHERE `message` LIKE 'Device rebooted%';
[2015/03/23 14:23:56 +0100] discovery.php(31115): Error: (1054) Unknown
column 'severity' in 'field list'
[2015/03/23 14:23:56 +0100] discovery.php(31115): Query: UPDATE
`eventlog` SET `severity` = 4 WHERE `entity_type` IN ('bgp_peer',
'sensor') AND `message` REGEXP ' (Up|Down|Alarm): ';
[2015/03/23 14:23:56 +0100] discovery.php(31115): Error: (1054) Unknown
column 'severity' in 'field list'

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