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

[Robert Chalmers]

Thanks,
That prompted a check. I have no idea where the bad database came about. Because I am using 1.3.1 Very strange.
However, I recreated the database, after having saved the data only from the “bad” database. Then imported the saved data back into the new database, and it all looks good.


Thanks for the directions.
Robert

> On 20 Dec 2015, at 11:43, A. Schulze <sca at andreasschulze.de> wrote:
> 
> 
> 
> 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
> _______________________________________________
> opendmarc-users mailing list
> opendmarc-users at trusteddomain.org
> http://www.trusteddomain.org/mailman/listinfo/opendmarc-users

Robert Chalmers
robert at chalmers.com <mailto:robert at chalmers.com>.au  Quantum Radio: http://tinyurl.com/lwwddov
Mac mini 6.2 - 2012, Intel Core i7,2.3 GHz, Memory:16 GB. El-Capitan 10.11. 2TB Storage made up of - 
Drive 0:HGST HTS721010A9E630. Upper bay. Drive 1:ST1000LM024 HN-M101MBB. Lower Bay



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.trusteddomain.org/pipermail/opendmarc-users/attachments/20151220/22ffb4eb/attachment.htm>