This also happened to me. I think you must disable strict mode in MySQL.

Hope it helps.

Enviado con Aquamail para Android
http://www.aqua-mail.com

El 21 de abril de 2015 20:20:24 Shaun Courtney <shaun@cybersmart.co.za> escribio:

Hi

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]

and also:


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]

192.sql has:

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…

(I’ve run 
./discovery.php -u
Observium 0.15.4.6392
Discovery )

Can anyone assist?

Regards,


Shaun



Este correo electrónico y, en su caso, cualquier fichero anexo al mismo, contiene información de carácter confidencial exclusivamente dirigida a su destinatario o destinatarios. Si no es vd. el destinatario indicado, queda notificado que la lectura, utilización, divulgación y/o copia sin autorización está prohibida en virtud de la legislación vigente. En el caso de haber recibido este correo electrónico por error, se ruega notificar inmediatamente esta circunstancia mediante reenvío a la dirección electrónica del remitente.
Evite imprimir este mensaje si no es estrictamente necesario.

This email and any file attached to it (when applicable) contain(s) confidential information that is exclusively addressed to its recipient(s). If you are not the indicated recipient, you are informed that reading, using, disseminating and/or copying it without authorisation is forbidden in accordance with the legislation in effect. If you have received this email by mistake, please immediately notify the sender of the situation by resending it to their email address.
Avoid printing this message if it is not absolutely necessary.