I’m having an issue with 0.15.4.6392.

When polling devices I get

./discovery.php -d -h hostname.domain.com

SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('143','143','device',NOW(),'6','Inventory: 3 added.')]

RUNTIME[0.00013995s]

ERROR[Error in query: (1364) Field 'reference' doesn't have a default value]

SQL[INSERT INTO `entPhysical` (`entPhysicalIndex`,`entPhysicalDescr`,`entPhysicalClass`,`entPhysicalName`,`entPhysicalHardwareRev`,`entPhysicalFirmwareRev`,`entPhysicalSoftwareRev`,`entPhysicalAlias`,`entPhysicalAssetID`,`entPhysicalIsFRU`,`entPhysicalModelName`,`entPhysicalVendorType`,`entPhysicalSerialNum`,`entPhysicalContainedIn`,`entPhysicalParentRelPos`,`entPhysicalMfgName`,`ifIndex`,`device_id`) VALUES ('1','MikroTik RouterBoard','chassis','','','','','','','false','','','57820471C18C','0','0','MikroTik','','143')]

RUNTIME[0.00013900s]

ERROR[Error in query: (1366) Incorrect integer value: '' for column 'ifIndex' at row 1]

ALTER TABLE `ports` ADD `port_label_short` VARCHAR( 16 ) NOT NULL AFTER `port_label` ;

Changing this to “DEFAULT NULL” seems to fix the problem and ports are discovered and graphed…

./discovery.php -u

Observium 0.15.4.6392

Discovery )