[vz-users] SQLSTATE[22012]: Division by zero
René W.
tylonhh at gmail.com
Sat Jun 15 04:30:01 CEST 2019
Nabend oder Moin,
ich erhalte eine SQL Fehlermeldung „SQLSTATE[22012]: Division by Zero“. Ich vermute sehr stark das es an den aggtime und interval liegt. Kann da bitte jemand mal auf meine conf schauen?
Welche Werte würden denn dort sonst Sinn machen?
{
"retry": 0,
"daemon": true,
"verbosity": 0,
"log": "/var/log/vzlogger.log",
"push": [],
"local": {
"enabled": false,
"port": 8080,
"index": false,
"timeout": 0,
"buffer": 0
},
"meters": [
{
"enabled": true,
"allowskip": false,
"interval": 5,
"aggtime": 10,
"aggfixedinterval": true,
"channels": [
{
"api": "volkszaehler",
"uuid": "xxxxx-8d06-11e9-a4c8-xxxxxx", //Haus Q3D
"middleware": "http://192.168.178.22:81/middleware.php",
"identifier": "1-0:1.7.0", //Wirkleistung 1-0:1.7.0 0.2868
//"secretKey": "",
//"type": "device",
//"scaler": 1000,
"aggmode": "AVG", //"AVG", // "AVG" Der Mittelwert für Leistung, "MAX" für Zähler, "SUM" für Counter
"duplicates": 0
}
],
"protocol": "d0",
"device": "/dev/usb-ir-lesekopf0",
"dump_file": "",
//"pullseq": "2f3f210d0a",
//"ackseq": "auto",
"baudrate": 9600,
//"baudrate_read": 9600,
"parity": "7e1"
//"wait_sync": "off",
//"read_timeout": 10,
//"baudrate_change_delay": 0
},
{
"enabled": true,
"allowskip": false,
"interval": 30,
"aggtime": 60, // >interval
"aggfixedinterval": true,
"channels": [
{
"api": "volkszaehler",
"uuid": "´xxxxxx-8d05-11e9-bb53-xxxxxxxx", //WP Elster AS1440 0.1833
"middleware": "http://192.168.178.22:81/middleware.php",
"identifier": "1-1:1.7.0",
"aggmode": "AVG", // "AVG" Der Mittelwert für Leistung, "MAX" für Zähler, "SUM" für Counter
"secretKey": "",
"type": "device",
"scaler": 1,
"duplicates": 0
}
],
"protocol": "d0",
"device": "/dev/usb-ir-lesekopf1", //
"dump_file": "",
"pullseq": "2F3F210D0A",
"ackseq": "auto",
"baudrate": 300,
"baudrate_read": 9600,
"parity": "7e1",
//"wait_sync": "off",
"baudrate_change_delay": 500,
"read_timeout": 100
}
]
}
LG Rene
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://demo.volkszaehler.org/pipermail/volkszaehler-users/attachments/20190615/8d857e72/attachment.html>
More information about the volkszaehler-users
mailing list