[opendmarc-users] Can someone help me solve this please? Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278

[A. Schulze]

Am 20.12.2015 um 11:51 schrieb Robert Chalmers:
> Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 559.
         if (get_value("requests", "locked", $request_id) != 1)

> The database structure supplied has the fields in the table default to NULL, and obviously this bit of code is falling over it.
No, it do not default to NULL.
The current source of version opendmarc-1.3.1 contain a file "reports/mkdb.mysql"

there I see:
   CREATE TABLE requests (
   ...
   locked TINYINT(4) NOT NULL DEFAULT '0',
   ...

btw: that line did not change since opendmarc-1.1.x times...

Which version of mysql do you use?

Maybe it help if you drop the whole database and recreate a new one.
After that manually add an entry to the requests table like opendmarc-import would do
and verify the locked field is not "NULL" but "0".

Andreas