@stefande Bin jetzt auch auf 1.9.5 zurück, das funktioniert problemlos. Gut zu wissen dass das Problem nicht nur bei mir Auftrat.

Hallo,

Ich habe mich entschlossen vom History Adapter zum SQLadapter mit MySQL umzuziehen.

iobroker 3.6.2
mySQL 1.10.0
flot 1.9.3

Ich habe die Flot Instanz und Adapter bereits mehrmals de-/installiert, PI regebooted, SQL instanz und Adapter de/installiert aber ich habe immer noch Probleme mit der Visualisierung. Mit dem History Adapter klappt es ohne Probleme. Die Werte kann ich in der MySQL DB schreiben und lesen (tabelarisch unter Objekte, oder von einem anderen Client). Die dargestellten Werte stimmen auch. Ich habe auch neue Objekte zum loggen hinzugefuegt aber das gleiche Problem besteht.

Zum Problem:
Wenn ich einen FLOT chart erstellen/darstellen will (in FLOT selbst oder nur ueber Objekte Grafik) crasht mein SQLadapter mit dem Error "TypeError: Assignment to constant variable." was zur folge hat, dass der FLOT chart nicht dargestellt wird.

Es spielt keine Rolle welche Variable ich darstellen will, immer der gleiche Fehler.
Im Flot Chart habe ich einen neuen Chart angelegt und verschiedene darstellungsarten durchprobiert. Im Web Adapter habe ich kein SSL aktiviert.
Kurzum, keine vorhandene Loesung im Forum funktionierte bisher.

Hat jemand eine Idee an was es liegen könnte?

undefined2019-08-11 16:54:32.304 - info: web.0 ==>Connected system.user.admin from ::ffff:192.168.0.107
2019-08-11 16:54:32.593 - info: web.0 ==>Connected system.user.admin from ::ffff:192.168.0.107
2019-08-11 16:54:35.454 - info: web.0 ==>Connected system.user.admin from ::ffff:192.168.0.107
2019-08-11 16:54:35.662 - debug: sql.0 system.adapter.admin.0: logging false
2019-08-11 16:54:35.703 - debug: sql.0 SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=1 AND `iobroker`.ts_number.ts < 1565538875197 AND `iobroker`.ts_number.ts >= 1565538275197 UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=1 AND `iobroker`.ts_number.ts < 1565538275197 ORDER BY `iobroker`.ts_number.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=1 AND `iobroker`.ts_number.ts >= 1565538875197 ORDER BY `iobroker`.ts_number.ts ASC LIMIT 1) ORDER BY ts ASC;
2019-08-11 16:54:35.704 - debug: sql.0 SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=1 AND `iobroker`.ts_number.ts < 1565538875197 AND `iobroker`.ts_number.ts >= 1565538275197 UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=1 AND `iobroker`.ts_number.ts < 1565538275197 ORDER BY `iobroker`.ts_number.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=1 AND `iobroker`.ts_number.ts >= 1565538875197 ORDER BY `iobroker`.ts_number.ts ASC LIMIT 1) ORDER BY ts ASC;
2019-08-11 16:54:35.729 - warn: sql.0 Exception: TypeError: Assignment to constant variable.
2019-08-11 16:54:35.739 - error: sql.0 uncaught exception: Assignment to constant variable.
2019-08-11 16:54:35.740 - error: sql.0 TypeError: Assignment to constant variable.
at aggregation (/opt/iobroker/node_modules/iobroker.sql/lib/aggregate.js:43:41)
at Object.sendResponse (/opt/iobroker/node_modules/iobroker.sql/lib/aggregate.js:454:29)
at getDataFromDB (/opt/iobroker/node_modules/iobroker.sql/main.js:1669:21)
at Query.client.execute (/opt/iobroker/node_modules/iobroker.sql/main.js:1568:27)
at Query. (/opt/iobroker/node_modules/mysql/lib/Connection.js:525:10)
at Query._callback (/opt/iobroker/node_modules/mysql/lib/Connection.js:491:16)
at Query.Sequence.end (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
at Query._handleFinalResultPacket (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Query.js:139:8)
at Query.EofPacket (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Query.js:123:8)
at Protocol._parsePacket (/opt/iobroker/node_modules/mysql/lib/protocol/Protocol.js:291:23)
2019-08-11 16:54:35.750 - debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(1, 1565538314668, 22, 1, 2, 0);
2019-08-11 16:54:35.753 - debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(2, 1565538314647, 52, 1, 2, 0);
2019-08-11 16:54:35.756 - debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(3, 1565538314658, 1013, 1, 2, 0);
2019-08-11 16:54:35.758 - debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(4, 1565538314637, 0, 1, 2, 0);
2019-08-11 16:54:35.761 - debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(5, 1565538314678, 4600, 1, 2, 0);
2019-08-11 16:54:35.763 - debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(6, 1565538314523, 26, 1, 2, 0);
2019-08-11 16:54:35.766 - debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(7, 1565538314608, 16, 1, 2, 0);
2019-08-11 16:54:36.251 - info: sql.0 terminating
2019-08-11 16:54:36.294 - error: Caught by controller[0]: TypeError: Assignment to constant variable.
2019-08-11 16:54:36.295 - error: Caught by controller[0]: at aggregation (/opt/iobroker/node_modules/iobroker.sql/lib/aggregate.js:43:41)
2019-08-11 16:54:36.295 - error: Caught by controller[0]: at Object.sendResponse (/opt/iobroker/node_modules/iobroker.sql/lib/aggregate.js:454:29)
2019-08-11 16:54:36.295 - error: Caught by controller[0]: at getDataFromDB (/opt/iobroker/node_modules/iobroker.sql/main.js:1669:21)
2019-08-11 16:54:36.295 - error: Caught by controller[0]: at Query.client.execute (/opt/iobroker/node_modules/iobroker.sql/main.js:1568:27)
2019-08-11 16:54:36.295 - error: Caught by controller[0]: at Query. (/opt/iobroker/node_modules/mysql/lib/Connection.js:525:10)
2019-08-11 16:54:36.295 - error: Caught by controller[0]: at Query._callback (/opt/iobroker/node_modules/mysql/lib/Connection.js:491:16)
2019-08-11 16:54:36.296 - error: Caught by controller[0]: at Query.Sequence.end (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
2019-08-11 16:54:36.296 - error: Caught by controller[0]: at Query._handleFinalResultPacket (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Query.js:139:8)
2019-08-11 16:54:36.296 - error: Caught by controller[0]: at Query.EofPacket (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Query.js:123:8)
2019-08-11 16:54:36.296 - error: Caught by controller[0]: at Protocol._parsePacket (/opt/iobroker/node_modules/mysql/lib/protocol/Protocol.js:291:23)
2019-08-11 16:54:36.296 - error: host.rasp instance system.adapter.sql.0 terminated with code 0 (OK)
2019-08-11 16:54:36.296 - info: host.rasp Restart adapter system.adapter.sql.0 because enabled
2019-08-11 16:54:37.923 - info: web.0 ==>Connected system.user.admin from ::ffff:192.168.0.107
2019-08-11 16:54:44.218 - info: web.0 <==Disconnect system.user.admin from ::ffff:192.168.0.107 flot
2019-08-11 16:54:46.340 - info: web.0 <==Disconnect system.user.admin from ::ffff:192.168.0.107 flot
2019-08-11 16:54:46.343 - info: web.0 <==Disconnect system.user.admin from ::ffff:192.168.0.107 flotEdit
2019-08-11 16:54:46.344 - info: web.0 <==Disconnect system.user.admin from ::ffff:192.168.0.107 flotEditDialog
2019-08-11 16:55:06.327 - info: host.rasp instance system.adapter.sql.0 started with pid 11546
2019-08-11 16:55:09.160 - debug: sql.0 objectDB connected
2019-08-11 16:55:09.204 - debug: sql.0 statesDB connected
2019-08-11 16:55:09.251 - info: sql.0 starting. Version 1.10.0 in /opt/iobroker/node_modules/iobroker.sql, node: v10.16.2

Hallo,

ich habe ein sehr ähnliches Problem wie ursprünglich in diesem Thread beschrieben.

iobroker 3.6.2
mySQL 1.10.0
flot 1.9.3

Ich habe die Flot Instanz und Adapter bereits mehrmals de-/installiert, PI regebooted aber ich habe immer noch Probleme mit der Visualisierung. Mit History klappt es ohne Probleme. Die Werte kann ich in der mySql DB auch lesen und stimmen auch soweit. Das einzige was mir auffällt ist, wenn ich im flot adapter einen chart erstellen will, werden errors geloggt.

undefined2019-08-11 16:54:32.304 - info: web.0 ==>Connected system.user.admin from ::ffff:192.168.0.107
2019-08-11 16:54:32.593 - info: web.0 ==>Connected system.user.admin from ::ffff:192.168.0.107
2019-08-11 16:54:35.454 - info: web.0 ==>Connected system.user.admin from ::ffff:192.168.0.107
2019-08-11 16:54:35.662 - debug: sql.0 system.adapter.admin.0: logging false
2019-08-11 16:54:35.703 - debug: sql.0 SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=1 AND `iobroker`.ts_number.ts < 1565538875197 AND `iobroker`.ts_number.ts >= 1565538275197 UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=1 AND `iobroker`.ts_number.ts < 1565538275197 ORDER BY `iobroker`.ts_number.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=1 AND `iobroker`.ts_number.ts >= 1565538875197 ORDER BY `iobroker`.ts_number.ts ASC LIMIT 1) ORDER BY ts ASC;
2019-08-11 16:54:35.704 - debug: sql.0 SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=1 AND `iobroker`.ts_number.ts < 1565538875197 AND `iobroker`.ts_number.ts >= 1565538275197 UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=1 AND `iobroker`.ts_number.ts < 1565538275197 ORDER BY `iobroker`.ts_number.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=1 AND `iobroker`.ts_number.ts >= 1565538875197 ORDER BY `iobroker`.ts_number.ts ASC LIMIT 1) ORDER BY ts ASC;
2019-08-11 16:54:35.729 - warn: sql.0 Exception: TypeError: Assignment to constant variable.
2019-08-11 16:54:35.739 - error: sql.0 uncaught exception: Assignment to constant variable.
2019-08-11 16:54:35.740 - error: sql.0 TypeError: Assignment to constant variable.
at aggregation (/opt/iobroker/node_modules/iobroker.sql/lib/aggregate.js:43:41)
at Object.sendResponse (/opt/iobroker/node_modules/iobroker.sql/lib/aggregate.js:454:29)
at getDataFromDB (/opt/iobroker/node_modules/iobroker.sql/main.js:1669:21)
at Query.client.execute (/opt/iobroker/node_modules/iobroker.sql/main.js:1568:27)
at Query. (/opt/iobroker/node_modules/mysql/lib/Connection.js:525:10)
at Query._callback (/opt/iobroker/node_modules/mysql/lib/Connection.js:491:16)
at Query.Sequence.end (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
at Query._handleFinalResultPacket (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Query.js:139:8)
at Query.EofPacket (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Query.js:123:8)
at Protocol._parsePacket (/opt/iobroker/node_modules/mysql/lib/protocol/Protocol.js:291:23)
2019-08-11 16:54:35.750 - debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(1, 1565538314668, 22, 1, 2, 0);
2019-08-11 16:54:35.753 - debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(2, 1565538314647, 52, 1, 2, 0);
2019-08-11 16:54:35.756 - debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(3, 1565538314658, 1013, 1, 2, 0);
2019-08-11 16:54:35.758 - debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(4, 1565538314637, 0, 1, 2, 0);
2019-08-11 16:54:35.761 - debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(5, 1565538314678, 4600, 1, 2, 0);
2019-08-11 16:54:35.763 - debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(6, 1565538314523, 26, 1, 2, 0);
2019-08-11 16:54:35.766 - debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(7, 1565538314608, 16, 1, 2, 0);
2019-08-11 16:54:36.251 - info: sql.0 terminating
2019-08-11 16:54:36.294 - error: Caught by controller[0]: TypeError: Assignment to constant variable.
2019-08-11 16:54:36.295 - error: Caught by controller[0]: at aggregation (/opt/iobroker/node_modules/iobroker.sql/lib/aggregate.js:43:41)
2019-08-11 16:54:36.295 - error: Caught by controller[0]: at Object.sendResponse (/opt/iobroker/node_modules/iobroker.sql/lib/aggregate.js:454:29)
2019-08-11 16:54:36.295 - error: Caught by controller[0]: at getDataFromDB (/opt/iobroker/node_modules/iobroker.sql/main.js:1669:21)
2019-08-11 16:54:36.295 - error: Caught by controller[0]: at Query.client.execute (/opt/iobroker/node_modules/iobroker.sql/main.js:1568:27)
2019-08-11 16:54:36.295 - error: Caught by controller[0]: at Query. (/opt/iobroker/node_modules/mysql/lib/Connection.js:525:10)
2019-08-11 16:54:36.295 - error: Caught by controller[0]: at Query._callback (/opt/iobroker/node_modules/mysql/lib/Connection.js:491:16)
2019-08-11 16:54:36.296 - error: Caught by controller[0]: at Query.Sequence.end (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
2019-08-11 16:54:36.296 - error: Caught by controller[0]: at Query._handleFinalResultPacket (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Query.js:139:8)
2019-08-11 16:54:36.296 - error: Caught by controller[0]: at Query.EofPacket (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Query.js:123:8)
2019-08-11 16:54:36.296 - error: Caught by controller[0]: at Protocol._parsePacket (/opt/iobroker/node_modules/mysql/lib/protocol/Protocol.js:291:23)
2019-08-11 16:54:36.296 - error: host.rasp instance system.adapter.sql.0 terminated with code 0 (OK)
2019-08-11 16:54:36.296 - info: host.rasp Restart adapter system.adapter.sql.0 because enabled
2019-08-11 16:54:37.923 - info: web.0 ==>Connected system.user.admin from ::ffff:192.168.0.107
2019-08-11 16:54:44.218 - info: web.0 <==Disconnect system.user.admin from ::ffff:192.168.0.107 flot
2019-08-11 16:54:46.340 - info: web.0 <==Disconnect system.user.admin from ::ffff:192.168.0.107 flot
2019-08-11 16:54:46.343 - info: web.0 <==Disconnect system.user.admin from ::ffff:192.168.0.107 flotEdit
2019-08-11 16:54:46.344 - info: web.0 <==Disconnect system.user.admin from ::ffff:192.168.0.107 flotEditDialog
2019-08-11 16:55:06.327 - info: host.rasp instance system.adapter.sql.0 started with pid 11546
2019-08-11 16:55:09.160 - debug: sql.0 objectDB connected
2019-08-11 16:55:09.204 - debug: sql.0 statesDB connected
2019-08-11 16:55:09.251 - info: sql.0 starting. Version 1.10.0 in /opt/iobroker/node_modules/iobroker.sql, node: v10.16.2

Im Flot Chart habe ich einen neuen Chart angelegt und verschiedene Arten durchprobiert jedoch ohne Erfolg. Im Web Adapter habe ich kein SSL aktiviert.

Hat jemand eine Idee an was es liegen könnte?

Neustart hat das Problem behoben. Danke fuer die schnelle Antwort @klassisch und @tombox

@klassisch über die App bekomme ich zusätzlich die Funktionen wie:
Kilometerstand, Tankfuellstand, Standheizung, Reifendruck, Batteriestatus, Fenster ..... letzte Fahrten

edit:
@tombox ich habe ich über die App, und die Website angemeldet
zusätzlich habe ich iobroker neu gestartet, jetzt kommt alles an wie es soll, Danke!

Hallo,
ich hab den mercedesme Adapter in der Version 0.0.12 installiert.
Leider wird mir nur die Fahrgestellnummer und das Nummernschild als im mercedesme.0. als einzigstes Objekt angezeigt.
Hat jemand eine Idee um dies zu beheben?
Im Log sehe ich keine Fehlermeldungen.

mercedesme.0	2019-08-03 16:02:57.566	info	starting. Version 0.0.12 in /opt/iobroker/node_modules/iobroker.mercedesme, node: v10.16.0
mercedesme.0	2019-08-03 15:53:43.068	info	starting. Version 0.0.12 in /opt/iobroker/node_modules/iobroker.mercedesme, node: v10.16.0
mercedesme.0	2019-08-03 15:51:47.209	info	starting. Version 0.0.12 in /opt/iobroker/node_modules/iobroker.mercedesme, node: v10.16.0