Welcome to the AgriMetSupport LCN server! <br><br>  Using production php server    :   0 <br>  Using develop DB               :   1 <br><br><BR> .01. Reading key/values from incoming GET request...<BR><BR>  network_id          :   0 <br>  timestamp           :    <br>  binCompressedData   :    <br>  datetime conversion :   1970-01-01 00:00:00<br><br><BR> .02. Decoding 96 bit payload  ...<BR><BR><pre>Array
(
    [Air temperature] => -40
    [Air humidity] => 0
    [Rainfall] => 0
    [Wind direction] => 0
    [Leaf wetness] => 100
    [Wind speed] => 0
    [Reason of last reset] => NO_MEAN
    [Wind gusts] => 0
    [Terminal open] => 0
    [Battery level] => 2.2
    [Firmware version] => 0
    [Box temperature] => -40
    [Box humidity] => 0
    [Soil temperature] => 
    [Soil humidity] => 
    [Timestamp] => 1970-01-01 00:00:00
)
</pre><BR> .03. Inserting new record in the LCN DB...<BR><BR>SELECT * FROM "develop"."Device" WHERE "Network ID" = $1;<BR>$1 = 0
<BR><BR><BR><BR> <p style="color:#0000FF"> The SigFox Backend ID not found in DB.</p><BR><BR>INSERT INTO "develop"."Message" ("device_id", "Compressed data", "Air temperature", "Air humidity", "Rainfall", "Wind direction", "Leaf wetness", "Wind speed", "Reason of last reset", "Wind gusts", "Terminal open", "Battery level", "Firmware version", "Box temperature", "Box humidity", "Timestamp") VALUES ($1, $2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16);<BR>$1 = 
$2 = 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
$3 = -40
$4 = 0
$5 = 0
$6 = 0
$7 = 100
$8 = 0
$9 = NO_MEAN
$10 = 0
$11 = 0
$12 = 2.2
$13 = 0
$14 = -40
$15 = 0
$16 = 1970-01-01 00:00:00
<BR><BR><br />
<b>Warning</b>:  pg_query_params(): Query failed: ERROR:  null value in column &quot;device_id&quot; of relation &quot;Message&quot; violates not-null constraint
DETAIL:  Failing row contains (null, 1970-01-01 00:00:00, 0000000000000000000000000000000000000000000000000000000000000000..., 0, -40.00, 0.00, 0.00, 0.00, 0.00, 0.00, 100.00, null, null, -40.00, 0.00, 0, 2.2, NO_MEAN). in <b>/var/www/html/classes/DB_connection.php</b> on line <b>57</b><br />
<br />
<b>Warning</b>:  pg_affected_rows() expects parameter 1 to be resource, boolean given in <b>/var/www/html/classes/LCN_DB_access.php</b> on line <b>94</b><br />
<BR>Fatal: Database LCN: Unable to insert message 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 sent by the device  at time 1970-01-01 00:00:00 in the LCN DB<BR> Error code: 2<BR><BR><BR>Bye!<BR><BR>