<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Thanks,</div><div class="">That prompted a check. I have no idea where the bad database came about. Because I am using 1.3.1 Very strange.</div><div class="">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.</div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Thanks for the directions.</div><div class="">Robert</div><br class=""><div><blockquote type="cite" class=""><div class="">On 20 Dec 2015, at 11:43, A. Schulze <<a href="mailto:sca@andreasschulze.de" class="">sca@andreasschulze.de</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class=""><br class=""><br class="">Am 20.12.2015 um 11:51 schrieb Robert Chalmers:<br class=""><blockquote type="cite" class="">Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 559.<br class=""></blockquote> if (get_value("requests", "locked", $request_id) != 1)<br class=""><br class=""><blockquote type="cite" class="">The database structure supplied has the fields in the table default to NULL, and obviously this bit of code is falling over it.<br class=""></blockquote>No, it do not default to NULL.<br class="">The current source of version opendmarc-1.3.1 contain a file "reports/mkdb.mysql"<br class=""><br class="">there I see:<br class=""> CREATE TABLE requests (<br class=""> ...<br class=""> locked TINYINT(4) NOT NULL DEFAULT '0',<br class=""> ...<br class=""><br class="">btw: that line did not change since opendmarc-1.1.x times...<br class=""><br class="">Which version of mysql do you use?<br class=""><br class="">Maybe it help if you drop the whole database and recreate a new one.<br class="">After that manually add an entry to the requests table like opendmarc-import would do<br class="">and verify the locked field is not "NULL" but "0".<br class=""><br class="">Andreas<br class="">_______________________________________________<br class="">opendmarc-users mailing list<br class=""><a href="mailto:opendmarc-users@trusteddomain.org" class="">opendmarc-users@trusteddomain.org</a><br class="">http://www.trusteddomain.org/mailman/listinfo/opendmarc-users<br class=""></div></div></blockquote></div><br class=""><div class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class=""><div class="">Robert Chalmers</div><div class=""><a href="mailto:robert@chalmers.com" class="">robert@chalmers.com</a>.au Quantum Radio: <a href="http://tinyurl.com/lwwddov" class="">http://tinyurl.com/lwwddov</a></div><div class=""><div class="">Mac mini 6.2 - 2012, Intel Core i7,2.3 GHz, Memory:16 GB. El-Capitan 10.11. 2TB Storage made up of - </div><div class="">Drive 0:HGST HTS721010A9E630. Upper bay. Drive 1:ST1000LM024 HN-M101MBB. Lower Bay</div></div></div><div class=""><br class=""></div></div></div><br class="Apple-interchange-newline">
</div>
<br class=""></body></html>