[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