<div dir="ltr">Hallo Heiko,<br><div class="gmail_extra"><br><div class="gmail_quote">2014/1/12 Heiko Baumann <span dir="ltr"><<a href="mailto:hbcs@gmx.de" target="_blank">hbcs@gmx.de</a>></span><br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<div>Hm. Ich hab vorhin mit git pull meinen
vz geupdatet:<br>
<br>
pi@BauratPi /var/www/<a href="http://volkszaehler.org" target="_blank">volkszaehler.org</a> $ sudo git pull<br>
remote: Counting objects: 73, done.<br>
remote: Compressing objects: 100% (70/70), done.<br>
remote: Total 73 (delta 29), reused 34 (delta 3)<br>
Unpacking objects: 100% (73/73), done.<br>
From git://<a href="http://github.com/volkszaehler/volkszaehler.org" target="_blank">github.com/volkszaehler/volkszaehler.org</a><br>
ec0c82d..ba113f6 master -> origin/master<br>
Updating ec0c82d..ba113f6<br>
Fast-forward<br>
.../Interpreter/CounterInterpreter.php | 27 ++----<br>
lib/Volkszaehler/Interpreter/MeterInterpreter.php | 3 +-<br>
.../Interpreter/SQL/MySQLAggregateOptimizer.php | 90
+++++++++++---------<br>
lib/Volkszaehler/Interpreter/SQL/SQLOptimizer.php | 3 +-<br>
lib/Volkszaehler/Interpreter/SensorInterpreter.php | 3 +-<br>
lib/Volkszaehler/Model/Property.php | 13 ++-<br>
lib/Volkszaehler/View/CSV.php | 52
+++--------<br>
lib/Volkszaehler/View/JSON.php | 32 ++-----<br>
lib/Volkszaehler/View/JpGraph.php | 8 +-<br>
lib/Volkszaehler/View/XML.php | 80
++++++-----------<br>
misc/tools/vzclient | 16 ++--<br>
test/Tests/DataCounterTest.php | 2 +-<br>
test/Tests/DataMeterTest.php | 2 +-<br>
13 files changed, 135 insertions(+), 196 deletions(-)<br>
<br>
- damit sollten doch alle updates drin sein, oder?<br></div></div></blockquote><div><br></div><div>Ja- Commit 8ac2c5039273b590aec2a9890f87400c08b949a8 liegt dazwischen.<br> <br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF"><div>
<br>
Im mysql-log gehts aber nach wie vor extrem wüst zu:<br>
17345 Connect vz@localhost on volkszaehler<br>
17345 Query SELECT e0_.id AS id0, e0_.uuid AS
uuid1, e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4,
p1_.value AS value5, e0_.class AS class6, p1_.entity_id AS
entity_id7 FROM entities e0_ LEFT JOIN properties p1_ ON e0_.id =
p1_.entity_id WHERE (e0_.uuid =
'ae9d1b00-f2f5-11e2-8a1f-0dad1c039958') AND e0_.class IN
('channel', 'aggregator') ORDER BY p1_.pkey ASC<br>
140112 22:33:47 17345 Query START TRANSACTION<br>
17345 Query INSERT INTO data (timestamp,
value, channel_id) VALUES ('1389562426842', '1', 16)<br>
17345 Query UPDATE properties SET value = '1'
WHERE id = 83<br>
17345 Query UPDATE properties SET value = '1'
WHERE id = 81<br>
17345 Query UPDATE properties SET value =
'3600000' WHERE id = 79<br>
17345 Query commit<br>
17345 Quit<br>
<br>
Insofern also alles beim alten. Wie krieg ich die neueste Version?<br></div></div></blockquote><div><br>Ich kann's nicht mehr nachvollziehen:<br><br>SELECT e0_.id AS id0, e0_.uuid AS uuid1, e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4, p1_.value AS value5, e0_.class AS class6, p1_.entity_id AS entity_id7 FROM entities e0_ LEFT JOIN properties p1_ ON e0_.id = p1_.entity_id WHERE (e0_.uuid = ?) AND e0_.class IN ('channel', 'aggregator') ORDER BY p1_.pkey ASC<br>
START TRANSACTION<br>INSERT INTO data (timestamp, value, channel_id) VALUES (?, ?, ?)<br>COMMIT<br><br></div><div>Bist Du sicher dass der Code den Du siehst auch wirklich der ist der ausgeführt wird?<br><br>vg<br></div><div>
Andreas<br></div></div></div></div>