<div dir="ltr">Hallo.<div><br></div><div><span style="color:rgb(33,33,33)">>1062 Duplicate entry '32-1517131035000'</span> <br></div><div><br></div><div>Für diesen Timestamp gibt es schon einen Eintrag. Ist das Zufällig ein Temp Wert ausgelesen von einer externen Seite?</div><div><br></div><div>Grüße</div></div><br><div class="gmail_quote"><div dir="ltr">Frank Richter <<a href="mailto:frank.richter83@gmail.com">frank.richter83@gmail.com</a>> schrieb am So., 28. Jan. 2018 um 12:27 Uhr:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto">Hallo Michael,<div dir="auto"><br></div><div dir="auto">hast du mal versucht, vzlogger neu zu starten?</div><div dir="auto"><br></div><div dir="auto">Gruß</div></div><div dir="auto"><div dir="auto">Frank</div></div><div class="gmail_extra"><br><div class="gmail_quote">Am 28.01.2018 11:08 schrieb "Michael Koch" <<a href="mailto:princemichi@gmail.com" target="_blank">princemichi@gmail.com</a>>:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
Schönen Sonntag allen!<br>
<br>
Einer meiner Pis sendet derzeit keine Werte an meine Middleware.<br>
<br>
<u><b>Meldung auf lokalem Pi:</b></u><br>
[Jan 28 10:50:01][chn8] CURL Error from middleware: continue<br>
<br>
[Jan 28 10:50:01][chn10]CURL Error from middleware: continue<br>
<br>
<u><b>Meldung auf meinem Server mit MW:</b></u><br>
[Sun Jan 28 10:50:<a href="tel:01%20019076" value="+431019076" target="_blank">01.019076</a> 2018] [:error] [pid 12270] [client
xx.xx.xxx.xxx:33538] PHP Fatal error: Uncaught exception
'PDOException' with message 'SQLSTATE[23000]: Integrity constraint
violation: 1062 Duplicate entry '30-1517131035000' for key
'data_unique'' in
/var/www/<a href="http://volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91%5CnStack" target="_blank">volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91\nStack</a>
trace:\n#0
/var/www/<a href="http://volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(91)" target="_blank">volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(91)</a>:
PDOStatement->execute(Array)\n#1
/var/www/<a href="http://volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1008)" target="_blank">volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1008)</a>:
Doctrine\\DBAL\\Driver\\PDOStatement->execute(Array)\n#2
/var/www/<a href="http://volkszaehler.org/lib/Controller/DataController.php(134)" target="_blank">volkszaehler.org/lib/Controller/DataController.php(134)</a>:
Doctrine\\DBAL\\Connection->executeUpdate('INSERT INTO dat...',
Array)\n#3
/var/www/<a href="http://volkszaehler.org/lib/Controller/Controller.php(112)" target="_blank">volkszaehler.org/lib/Controller/Controller.php(112)</a>:
Volkszaehler\\Controller\\DataController->add('835c1870-1002-1...')\n#4
/var/www/<a href="http://volkszaehler.org/lib/Router.php(210)" target="_blank">volkszaehler.org/lib/Router.php(210)</a>:
Volkszaehler\\Controller\\Controller->run('add',
'835c1870-1002-1...')\n#5
/var/www/<a href="http://volkszaehler.org/lib/Router.php(189)" target="_blank">volkszaehler.org/lib/Router.php(189)</a>:
Volkszaehler\\Router->handler(Object(Symfony\\Componen in
/var/www/<a href="http://volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php" target="_blank">volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php</a>
on line 66<br>
<br>
[Sun Jan 28 10:50:<a href="tel:01%20341604" value="+431341604" target="_blank">01.341604</a> 2018] [:error] [pid 12617] [client
xx.xx.xxx.xxx:33564] PHP Fatal error: Uncaught exception
'PDOException' with message 'SQLSTATE[23000]: Integrity constraint
violation: 1062 Duplicate entry '32-1517131035000' for key
'data_unique'' in
/var/www/<a href="http://volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91%5CnStack" target="_blank">volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91\nStack</a>
trace:\n#0
/var/www/<a href="http://volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(91)" target="_blank">volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(91)</a>:
PDOStatement->execute(Array)\n#1
/var/www/<a href="http://volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1008)" target="_blank">volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1008)</a>:
Doctrine\\DBAL\\Driver\\PDOStatement->execute(Array)\n#2
/var/www/<a href="http://volkszaehler.org/lib/Controller/DataController.php(134)" target="_blank">volkszaehler.org/lib/Controller/DataController.php(134)</a>:
Doctrine\\DBAL\\Connection->executeUpdate('INSERT INTO dat...',
Array)\n#3
/var/www/<a href="http://volkszaehler.org/lib/Controller/Controller.php(112)" target="_blank">volkszaehler.org/lib/Controller/Controller.php(112)</a>:
Volkszaehler\\Controller\\DataController->add('c72e0a60-13b6-1...')\n#4
/var/www/<a href="http://volkszaehler.org/lib/Router.php(210)" target="_blank">volkszaehler.org/lib/Router.php(210)</a>:
Volkszaehler\\Controller\\Controller->run('add',
'c72e0a60-13b6-1...')\n#5
/var/www/<a href="http://volkszaehler.org/lib/Router.php(189)" target="_blank">volkszaehler.org/lib/Router.php(189)</a>:
Volkszaehler\\Router->handler(Object(Symfony\\Componen in
/var/www/<a href="http://volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php" target="_blank">volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php</a>
on line 66<br>
<br>
Hat einer Idee wo das Problem liegt?<br>
Was braucht Ihr noch für Infos?<br>
<br>
Danke, Michael<br>
</div>
</blockquote></div></div>
</blockquote></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><p dir="ltr">Von meinem Smartphone versendet</p>
</div>