Moin Moin,
ich habe den Nano-Server bei mir auf den Root-Server gepackt.
Das Nano meldet sich auch schon.
PHP Warning: PDOStatement::execute(): SQLSTATE[HY000]: General error: 1364 Field 'amazon_token' doesn't have a default value in /var/www/api.u.de/index.php on line 204
Hat wer eine Idee wie ich diese Meldung weg bekomme?
Es wird leider noch nichts in die DB geschrieben
im Client-Log sehe ich
User-Agent: WLANThermo nano
SN: 31xxxx
Host: api.u.de
{"device":{"device":"nano","serial":"31bdce","item":"n2E03oC19a0","cpu":"esp82xx","flash_size":4194304,"hw_version":"v2","sw_version":"v1.1.0c3pu","api_version":"1","language":"de"},"cloud":{"task":"save","api_token":"31bdce5e4ae5b3d","data":[{"system":{"time":"1581968542","unit":"C","soc":100,"charge":false,"rssi":-45,"online":0},"channel":[{"number":1,"name":"Ebene 2","typ":0,"temp":999.00,"min":130.00,"max":170.00,"alarm":0,"color":"#FFC100"},{"number":2,"name":"Ebene 1","typ":0,"temp":999.00,"min":90.00,"max":140.00,"alarm":0,"color":"#22B14C"},{"number":3,"name":"PP Kamado","typ":0,"temp":999.00,"min":10.00,"max":93.00,"alarm":0,"color":"#EF562D"},{"number":4,"name":"PP Gas ","typ":0,"temp":18.70,"min":115.00,"max":220.00,"alarm":0,"color":"#804000"},{"number":5,"name":"PP Gas 2","typ":0,"temp":999.00,"min":10.00,"max":220.00,"alarm":0,"color":"#A349A4"},{"number":6,"name":"PP Gas 3","typ":0,"temp":999.00,"min":10.00,"max":93.00,"alarm":0,"color":"#FFC100"},{"number":7,"name":"Kanal 7","typ":0,"temp":999.00,"min":10.00,"max":140.00,"alarm":0,"color":"#5587A2"},{"number":8,"name":"Kanal 8","typ":0,"temp":999.00,"min":10.00,"max":93.00,"alarm":0,"color":"#5C7148"}],"pitmaster":[{"id":0,"channel":1,"pid":2,"value":0,"set":150.00,"typ":"off","set_color":"#ff0000","value_color":"#000000"}]}]}}
HTTP/1.1 200 OK
Date: Mon, 17 Feb 2020 19:42:23 GMT
Server: Apache/2.4.38 (Debian)
Upgrade: h2,h2c
Connection: Upgrade
Content-Length: 0
Content-Type: text/html; charset=UTF-8
Viele Grüße
Lemmy