Neuer ioBroker-Blog online: Monatsrückblick März/April 2026

[marco-mh]

Hallo Leute, ich hab mal wieder ein problem, diesmal mit demSQL adapter.
ich habe seit längerem das problem das mir keine Grafische anzeige meiner gelogten daten angezeigt wird, Daten stehen aber in der Tabelle. Der kreis dreht un dreht sich in Flot. ich glaub das ist zu ersten mal nach einem Umzug auf ein neues system vorgekommen.
das steht im Log

sql.0	2020-01-23 22:48:45.094	info	(26930) enabled logging of Anja auf Arbeit, Alias=true, 1 points now activated
sql.0	2020-01-23 22:48:45.050	info	(26930) Connected to mysql
sql.0	2020-01-23 22:48:44.850	info	(26930) starting. Version 1.10.0 in /opt/iobroker/node_modules/iobroker.sql, node: v10.18.1
host.IobrokerDebian	2020-01-23 22:48:43.539	info	instance system.adapter.sql.0 started with pid 26930
host.IobrokerDebian	2020-01-23 22:48:13.527	info	Restart adapter system.adapter.sql.0 because enabled
host.IobrokerDebian	2020-01-23 22:48:13.527	info	instance system.adapter.sql.0 terminated with code 0 (NO_ERROR)
host.IobrokerDebian	2020-01-23 22:48:13.527	error	Caught by controller[0]: at Protocol._parsePacket (/opt/iobroker/node_modules/mysql/lib/protocol/Protocol.js:291:23)
host.IobrokerDebian	2020-01-23 22:48:13.526	error	Caught by controller[0]: at Query.EofPacket (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Query.js:133:8)
host.IobrokerDebian	2020-01-23 22:48:13.526	error	Caught by controller[0]: at Query._handleFinalResultPacket (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Query.js:149:8)
host.IobrokerDebian	2020-01-23 22:48:13.526	error	Caught by controller[0]: at Query.Sequence.end (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
host.IobrokerDebian	2020-01-23 22:48:13.526	error	Caught by controller[0]: at Query._callback (/opt/iobroker/node_modules/mysql/lib/Connection.js:488:16)
host.IobrokerDebian	2020-01-23 22:48:13.526	error	Caught by controller[0]: at Query.<anonymous> (/opt/iobroker/node_modules/mysql/lib/Connection.js:526:10)
host.IobrokerDebian	2020-01-23 22:48:13.526	error	Caught by controller[0]: at Query.client.execute (/opt/iobroker/node_modules/iobroker.sql/main.js:1568:27)
host.IobrokerDebian	2020-01-23 22:48:13.526	error	Caught by controller[0]: at getDataFromDB (/opt/iobroker/node_modules/iobroker.sql/main.js:1669:21)
host.IobrokerDebian	2020-01-23 22:48:13.526	error	Caught by controller[0]: at Object.sendResponse (/opt/iobroker/node_modules/iobroker.sql/lib/aggregate.js:454:29)
host.IobrokerDebian	2020-01-23 22:48:13.526	error	Caught by controller[0]: at aggregation (/opt/iobroker/node_modules/iobroker.sql/lib/aggregate.js:43:41)
host.IobrokerDebian	2020-01-23 22:48:13.525	error	Caught by controller[0]: TypeError: Assignment to constant variable.
sql.0	2020-01-23 22:48:13.002	info	(18800) Terminated (NO_ERROR): Without reason
sql.0	2020-01-23 22:48:13.000	info	(18800) terminating
sql.0	2020-01-23 22:48:12.495	error	at Protocol._parsePacket (/opt/iobroker/node_modules/mysql/lib/protocol/Protocol.js:291:23)
sql.0	2020-01-23 22:48:12.495	error	at Query.EofPacket (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Query.js:133:8)
sql.0	2020-01-23 22:48:12.495	error	at Query._handleFinalResultPacket (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Query.js:149:8)
sql.0	2020-01-23 22:48:12.495	error	at Query.Sequence.end (/opt/iobroker/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
sql.0	2020-01-23 22:48:12.495	error	at Query._callback (/opt/iobroker/node_modules/mysql/lib/Connection.js:488:16)
sql.0	2020-01-23 22:48:12.495	error	at Query.<anonymous> (/opt/iobroker/node_modules/mysql/lib/Connection.js:526:10)
sql.0	2020-01-23 22:48:12.495	error	at Query.client.execute (/opt/iobroker/node_modules/iobroker.sql/main.js:1568:27)
sql.0	2020-01-23 22:48:12.495	error	at getDataFromDB (/opt/iobroker/node_modules/iobroker.sql/main.js:1669:21)
sql.0	2020-01-23 22:48:12.495	error	at Object.sendResponse (/opt/iobroker/node_modules/iobroker.sql/lib/aggregate.js:454:29)
sql.0	2020-01-23 22:48:12.495	error	at aggregation (/opt/iobroker/node_modules/iobroker.sql/lib/aggregate.js:43:41)
sql.0	2020-01-23 22:48:12.495	error	(18800) TypeError: Assignment to constant variable.
sql.0	2020-01-23 22:48:12.495	error	(18800) uncaught exception: Assignment to constant variable.
sql.0	2020-01-23 22:48:12.492	warn	(18800) Exception: TypeError: Assignment to constant variable.
web.0	2020-01-23 22:48:11.987	info	(2325) ==>Connected system.user.admin from ::ffff:192.168.178.21

hat jemand eine idee und wird schlau aus dem Log?
Danke und gruss Marco

[dtp]

@marco-mh Was sagt denn der SQL-Adapter, wenn du über die erstellte Instanz die Verbindung testest?

[marco-mh]

ich hab es hinbekommen, ich hab von 1.10 auf 1.95 installiert und dann ging es.
danke für die Amtwort