Jahresrückblick 2025 – unser neuer Blogbeitrag ist online! ✨

[Onkel-Tom]

Guten Abend,

ich bin heute nach Hause gekommen und habe im Protokoll des IoBrokers hunderte Fehlermeldungen vom Sql-Adapter gefunden.
Alle paar Sekunden kommen neue Einträge dazu. Heute morgen war ich noch kurz über das Handy auf der Seite mit den Objekten und vermute ich habe aus Versehen etwas verstellt da nach ca. 6 Uhr keine Daten mehr gespeichert wurden. Zu allem Überfluss wollte ich nur das Log auf dem Bildschirm löschen und habe das Protokoll vom ganzen Tag gelöscht - sau dämlich :-(
Den IoBroker habe ich schon neu gestartet und nach allem gesehen was mir so eingefallen ist aber ich konnte den Fehler nicht finden.
Auf die Datenbank kann ich noch über myPHPAdmin zugreifen und da scheint alles ok zu sein.
Im Protokoll bekomme ich diese Fehler :

	2025-11-13 21:22:51.847	warn	Cannot get "from" for "system.adapter.e3dc-rscp.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:22:51.846	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.e3dc-rscp.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:22:42.320	warn	Cannot get "from" for "system.adapter.mqtt.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:22:42.320	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.mqtt.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:22:32.893	warn	Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:22:32.892	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:22:23.465	warn	Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:22:23.465	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:22:21.831	warn	Cannot get "from" for "system.adapter.e3dc-rscp.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:22:21.830	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.e3dc-rscp.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:22:12.315	warn	Cannot get "from" for "system.adapter.mqtt.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:22:12.315	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.mqtt.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:21:57.359	warn	Cannot get "from" for "system.adapter.mqtt.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:21:57.359	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.mqtt.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:21:51.853	warn	Cannot get "from" for "system.adapter.e3dc-rscp.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:21:51.853	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.e3dc-rscp.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:21:27.356	warn	Cannot get "from" for "system.adapter.mqtt.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:21:27.356	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.mqtt.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:21:27.313	warn	Cannot get "from" for "system.adapter.mqtt.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:21:27.313	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.mqtt.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:21:21.836	warn	Cannot get "from" for "system.adapter.e3dc-rscp.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:21:21.836	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.e3dc-rscp.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:21:21.361	warn	Cannot get "from" for "system.adapter.e3dc-rscp.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:21:21.361	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.e3dc-rscp.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:20:57.355	warn	Cannot get "from" for "system.adapter.mqtt.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:20:57.355	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.mqtt.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:20:57.310	warn	Cannot get "from" for "system.adapter.mqtt.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:20:57.309	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.mqtt.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:20:56.098	warn	Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:20:56.097	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:20:51.868	warn	Cannot get "from" for "system.adapter.e3dc-rscp.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:20:51.868	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.e3dc-rscp.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:20:51.861	warn	Cannot get "from" for "system.adapter.e3dc-rscp.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:20:51.860	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.e3dc-rscp.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:20:27.311	warn	Cannot get "from" for "system.adapter.mqtt.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:20:27.311	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.mqtt.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:20:21.833	warn	Cannot get "from" for "system.adapter.e3dc-rscp.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-13 21:20:21.832	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.e3dc-rscp.0';: Error: Unknown column 'id' in 'field list'

ich habe jetzt schon ein paar Stunden gesucht und finde den Fehler nicht.
Hat jemand einen guten Tipp für mich wo ich noch suchen Kann?
Danke schon mal im Voraus
Gruß
Onkel-Tom

[Dr. Bakterius]

@onkel-tom Also wenn die Datenbank in Ordnung ist, dann liegt es an der Verbindung ioBroker <-> SQL.

Wo liegt denn die Datenbank? Dort wo auch der ioBroker installiert ist oder auf einem anderen Rechner, VM / LXC, extern?

Hier alles (wirklich) richtig eingestellt?

Eventuell alles nochmal neu eintragen.

'Verbindung testen' ergibt was?

Firewall kann ausgeschlossen werden?

Port nicht auch von einem anderen Dienst verwendet?

Den SQL-Adapter mal auf 'debug' stellen und die Ausgabe ab den Neustart des Adapters hier posten.

[Onkel-Tom]

@dr-bakterius Hallo erst mal und danke für deine Antwort.
Den Test-Button hatte ich total übersehen, aber er bringt die Meldung OK.
Zum Test habe ich mal den Port wie in deinem Bild auf 3306 geändert, aber dann kam eine Fehlermeldung.
Zurück auf 3307 => OK
Firewall habe ich nicht eingerichtet.
Hier mal die Ausgabe vom Start nachdem ich auf Debug umgestellt habe:

	2025-11-14 19:59:59.462	debug	pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for kecontact.1.ePres (type: 0, ID: 17) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}: Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.462	warn	Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.462	debug	prepareTaskCheckTypeAndDbId getFrom system.adapter.sql.0 Result - isRunning length = 1
sql.0
	2025-11-14 19:59:59.462	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.461	debug	Return connection to pool: 0 now
sql.0
	2025-11-14 19:59:59.457	debug	Borrow connection from pool: 1 now
sql.0
	2025-11-14 19:59:59.456	debug	SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';
sql.0
	2025-11-14 19:59:59.456	debug	Type (from DB-Type) for kecontact.1.ePres: 0
sql.0
	2025-11-14 19:59:59.456	debug	Type set in Def for kecontact.1.ePres: false
sql.0
	2025-11-14 19:59:59.411	debug	pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for kecontact.1.currentUser (type: 0, ID: 10) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}: Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.411	warn	Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.410	debug	prepareTaskCheckTypeAndDbId getFrom system.adapter.sql.0 Result - isRunning length = 1
sql.0
	2025-11-14 19:59:59.410	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.409	debug	Return connection to pool: 0 now
sql.0
	2025-11-14 19:59:59.404	debug	Borrow connection from pool: 1 now
sql.0
	2025-11-14 19:59:59.404	debug	SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';
sql.0
	2025-11-14 19:59:59.404	debug	Type (from DB-Type) for kecontact.1.currentUser: 0
sql.0
	2025-11-14 19:59:59.403	debug	Type set in Def for kecontact.1.currentUser: false
sql.0
	2025-11-14 19:59:59.357	debug	pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for kecontact.0.plug (type: 0, ID: 9) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}: Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.357	warn	Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.356	debug	prepareTaskCheckTypeAndDbId getFrom system.adapter.sql.0 Result - isRunning length = 1
sql.0
	2025-11-14 19:59:59.356	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.355	debug	Return connection to pool: 0 now
sql.0
	2025-11-14 19:59:59.351	debug	Borrow connection from pool: 1 now
sql.0
	2025-11-14 19:59:59.350	debug	SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';
sql.0
	2025-11-14 19:59:59.350	debug	Type (from DB-Type) for kecontact.0.plug: 0
sql.0
	2025-11-14 19:59:59.350	debug	Type set in Def for kecontact.0.plug: false
sql.0
	2025-11-14 19:59:59.306	debug	pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for kecontact.0.enableUser (type: 2, ID: 8) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}: Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.305	warn	Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.305	debug	prepareTaskCheckTypeAndDbId getFrom system.adapter.sql.0 Result - isRunning length = 1
sql.0
	2025-11-14 19:59:59.305	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.304	debug	Return connection to pool: 0 now
sql.0
	2025-11-14 19:59:59.298	debug	Borrow connection from pool: 1 now
sql.0
	2025-11-14 19:59:59.298	debug	SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';
sql.0
	2025-11-14 19:59:59.298	debug	Type (from DB-Type) for kecontact.0.enableUser: 2
sql.0
	2025-11-14 19:59:59.297	debug	Type set in Def for kecontact.0.enableUser: false
sql.0
	2025-11-14 19:59:59.251	debug	pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for kecontact.0.eTotal (type: 0, ID: 7) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}: Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.251	warn	Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.250	debug	prepareTaskCheckTypeAndDbId getFrom system.adapter.sql.0 Result - isRunning length = 1
sql.0
	2025-11-14 19:59:59.250	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.250	debug	Return connection to pool: 0 now
sql.0
	2025-11-14 19:59:59.244	debug	Borrow connection from pool: 1 now
sql.0
	2025-11-14 19:59:59.244	debug	SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';
sql.0
	2025-11-14 19:59:59.244	debug	Type (from DB-Type) for kecontact.0.eTotal: 0
sql.0
	2025-11-14 19:59:59.243	debug	Type set in Def for kecontact.0.eTotal: false
sql.0
	2025-11-14 19:59:59.200	debug	pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for kecontact.0.ePres (type: 0, ID: 6) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}: Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.200	warn	Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.200	debug	prepareTaskCheckTypeAndDbId getFrom system.adapter.sql.0 Result - isRunning length = 1
sql.0
	2025-11-14 19:59:59.200	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.199	debug	Return connection to pool: 0 now
sql.0
	2025-11-14 19:59:59.192	debug	Borrow connection from pool: 1 now
sql.0
	2025-11-14 19:59:59.192	debug	SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';
sql.0
	2025-11-14 19:59:59.191	debug	Type (from DB-Type) for kecontact.0.ePres: 0
sql.0
	2025-11-14 19:59:59.189	debug	Type set in Def for kecontact.0.ePres: false
sql.0
	2025-11-14 19:59:59.185	debug	prepareTaskCheckTypeAndDbId CALLED for 0_userdata.0.E3DC.Erzeugung_aktuell_gesammt
sql.0
	2025-11-14 19:59:59.185	debug	pushValueIntoDB called for 0_userdata.0.E3DC.Erzeugung_aktuell_gesammt (type: undefined, ID: 86) and state: {"val":0,"ack":false,"ts":1763146799078,"q":0,"c":"script.js.Heizung-Solar-Lüftung.Erzeugung_aktuell_gesammt","from":"system.adapter.sql.0","user":"system.user.admin","lc":1763146799078}
sql.0
	2025-11-14 19:59:59.185	debug	prepareTaskCheckTypeAndDbId CALLED for 0_userdata.0.E3DC.Erzeugung_aktuell_gesammt
sql.0
	2025-11-14 19:59:59.184	debug	pushValueIntoDB called for 0_userdata.0.E3DC.Erzeugung_aktuell_gesammt (type: undefined, ID: 86) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.184	debug	prepareTaskCheckTypeAndDbId CALLED for 0_userdata.0.E3DC.Ertrag_PV-Zaun_Aktuell
sql.0
	2025-11-14 19:59:59.184	debug	pushValueIntoDB called for 0_userdata.0.E3DC.Ertrag_PV-Zaun_Aktuell (type: undefined, ID: 85) and state: {"val":0,"ack":true,"ts":1763146799078,"q":0,"c":"script.js.Heizung-Solar-Lüftung.Ertrag_PV-Zaun_Aktuell_aus_Powermeter","from":"system.adapter.sql.0","user":"system.user.admin","lc":1763146799078}
sql.0
	2025-11-14 19:59:59.183	debug	prepareTaskCheckTypeAndDbId CALLED for 0_userdata.0.E3DC.Ertrag_PV-Zaun_Aktuell
sql.0
	2025-11-14 19:59:59.183	debug	pushValueIntoDB called for 0_userdata.0.E3DC.Ertrag_PV-Zaun_Aktuell (type: undefined, ID: 85) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.183	debug	prepareTaskCheckTypeAndDbId CALLED for fritzdect.0.DECT_152820324877.battery
sql.0
	2025-11-14 19:59:59.182	debug	pushValueIntoDB called for fritzdect.0.DECT_152820324877.battery (type: undefined, ID: 76) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.182	debug	prepareTaskCheckTypeAndDbId CALLED for fritzdect.0.DECT_152820324877.tist
sql.0
	2025-11-14 19:59:59.182	debug	pushValueIntoDB called for fritzdect.0.DECT_152820324877.tist (type: undefined, ID: 74) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.171	debug	prepareTaskCheckTypeAndDbId CALLED for sonoff.0.Wifi-Steckdose.POWER
sql.0
	2025-11-14 19:59:59.171	debug	pushValueIntoDB called for sonoff.0.Wifi-Steckdose.POWER (type: undefined, ID: 72) and state: {"val":true,"ack":true,"ts":1763146799078,"q":0,"from":"system.adapter.sql.0","user":"system.user.admin","lc":1763146799078}
sql.0
	2025-11-14 19:59:59.171	debug	prepareTaskCheckTypeAndDbId CALLED for sonoff.0.Wifi-Steckdose.POWER
sql.0
	2025-11-14 19:59:59.171	debug	pushValueIntoDB called for sonoff.0.Wifi-Steckdose.POWER (type: undefined, ID: 72) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.170	debug	prepareTaskCheckTypeAndDbId CALLED for sonoff.0.Wifi-Steckdose.ENERGY_Power
sql.0
	2025-11-14 19:59:59.170	debug	pushValueIntoDB called for sonoff.0.Wifi-Steckdose.ENERGY_Power (type: undefined, ID: 71) and state: {"val":0,"ack":true,"ts":1763146799078,"q":0,"from":"system.adapter.sql.0","user":"system.user.admin","lc":1763146799078}
sql.0
	2025-11-14 19:59:59.170	debug	prepareTaskCheckTypeAndDbId CALLED for sonoff.0.Wifi-Steckdose.ENERGY_Power
sql.0
	2025-11-14 19:59:59.169	debug	pushValueIntoDB called for sonoff.0.Wifi-Steckdose.ENERGY_Power (type: undefined, ID: 71) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.169	debug	prepareTaskCheckTypeAndDbId CALLED for sonoff.0.Wifi-Steckdose.ENERGY_Today
sql.0
	2025-11-14 19:59:59.169	debug	pushValueIntoDB called for sonoff.0.Wifi-Steckdose.ENERGY_Today (type: undefined, ID: 70) and state: {"val":0,"ack":true,"ts":1763146799078,"q":0,"from":"system.adapter.sql.0","user":"system.user.admin","lc":1763146799078}
sql.0
	2025-11-14 19:59:59.169	debug	prepareTaskCheckTypeAndDbId CALLED for sonoff.0.Wifi-Steckdose.ENERGY_Today
sql.0
	2025-11-14 19:59:59.169	debug	pushValueIntoDB called for sonoff.0.Wifi-Steckdose.ENERGY_Today (type: undefined, ID: 70) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.168	debug	prepareTaskCheckTypeAndDbId CALLED for sonoff.0.Wifi-Steckdose.ENERGY_Total
sql.0
	2025-11-14 19:59:59.168	debug	pushValueIntoDB called for sonoff.0.Wifi-Steckdose.ENERGY_Total (type: undefined, ID: 69) and state: {"val":24.24,"ack":true,"ts":1763146799078,"q":0,"from":"system.adapter.sql.0","user":"system.user.admin","lc":1763146799078}
sql.0
	2025-11-14 19:59:59.168	debug	prepareTaskCheckTypeAndDbId CALLED for sonoff.0.Wifi-Steckdose.ENERGY_Total
sql.0
	2025-11-14 19:59:59.168	debug	pushValueIntoDB called for sonoff.0.Wifi-Steckdose.ENERGY_Total (type: undefined, ID: 69) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.167	debug	prepareTaskCheckTypeAndDbId CALLED for kecontact.1.statistics.lastChargeAmount
sql.0
	2025-11-14 19:59:59.167	debug	pushValueIntoDB called for kecontact.1.statistics.lastChargeAmount (type: undefined, ID: 63) and state: {"val":2.6212,"ack":true,"ts":1763146799078,"q":0,"from":"system.adapter.sql.0","user":"system.user.admin","lc":1763146799078}
sql.0
	2025-11-14 19:59:59.167	debug	prepareTaskCheckTypeAndDbId CALLED for kecontact.1.statistics.lastChargeAmount
sql.0
	2025-11-14 19:59:59.167	debug	pushValueIntoDB called for kecontact.1.statistics.lastChargeAmount (type: undefined, ID: 63) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.167	debug	prepareTaskCheckTypeAndDbId CALLED for kecontact.0.statistics.lastChargeAmount
sql.0
	2025-11-14 19:59:59.166	debug	pushValueIntoDB called for kecontact.0.statistics.lastChargeAmount (type: undefined, ID: 60) and state: {"val":4.899100000000001,"ack":true,"ts":1763146799078,"q":0,"from":"system.adapter.sql.0","user":"system.user.admin","lc":1763146799078}
sql.0
	2025-11-14 19:59:59.166	debug	prepareTaskCheckTypeAndDbId CALLED for kecontact.0.statistics.lastChargeAmount
sql.0
	2025-11-14 19:59:59.166	debug	pushValueIntoDB called for kecontact.0.statistics.lastChargeAmount (type: undefined, ID: 60) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.166	debug	prepareTaskCheckTypeAndDbId CALLED for mqtt.0.FBH_EG.VENTIL5
sql.0
	2025-11-14 19:59:59.166	debug	pushValueIntoDB called for mqtt.0.FBH_EG.VENTIL5 (type: undefined, ID: 43) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.165	debug	prepareTaskCheckTypeAndDbId CALLED for mqtt.0.FBH_EG.VENTIL4
sql.0
	2025-11-14 19:59:59.165	debug	pushValueIntoDB called for mqtt.0.FBH_EG.VENTIL4 (type: undefined, ID: 42) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.165	debug	prepareTaskCheckTypeAndDbId CALLED for mqtt.0.FBH_EG.VENTIL3
sql.0
	2025-11-14 19:59:59.165	debug	pushValueIntoDB called for mqtt.0.FBH_EG.VENTIL3 (type: undefined, ID: 41) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.165	debug	prepareTaskCheckTypeAndDbId CALLED for mqtt.0.FBH_EG.VENTIL2
sql.0
	2025-11-14 19:59:59.164	debug	pushValueIntoDB called for mqtt.0.FBH_EG.VENTIL2 (type: undefined, ID: 40) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.164	debug	prepareTaskCheckTypeAndDbId CALLED for mqtt.0.FBH_EG.VENTIL1
sql.0
	2025-11-14 19:59:59.164	debug	pushValueIntoDB called for mqtt.0.FBH_EG.VENTIL1 (type: undefined, ID: 39) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.164	debug	prepareTaskCheckTypeAndDbId CALLED for mqtt.0.Badsensor.temperature
sql.0
	2025-11-14 19:59:59.163	debug	pushValueIntoDB called for mqtt.0.Badsensor.temperature (type: undefined, ID: 29) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.163	debug	prepareTaskCheckTypeAndDbId CALLED for mqtt.0.Badsensor.humidity
sql.0
	2025-11-14 19:59:59.163	debug	pushValueIntoDB called for mqtt.0.Badsensor.humidity (type: undefined, ID: 28) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.163	debug	prepareTaskCheckTypeAndDbId CALLED for e3dc-rscp.0.EMS.MAX_CHARGE_POWER
sql.0
	2025-11-14 19:59:59.163	debug	pushValueIntoDB called for e3dc-rscp.0.EMS.MAX_CHARGE_POWER (type: undefined, ID: 27) and state: {"val":9000,"ack":true,"ts":1763146799078,"q":0,"from":"system.adapter.sql.0","user":"system.user.admin","lc":1763146799078}
sql.0
	2025-11-14 19:59:59.162	debug	prepareTaskCheckTypeAndDbId CALLED for e3dc-rscp.0.EMS.MAX_CHARGE_POWER
sql.0
	2025-11-14 19:59:59.162	debug	pushValueIntoDB called for e3dc-rscp.0.EMS.MAX_CHARGE_POWER (type: undefined, ID: 27) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.162	debug	prepareTaskCheckTypeAndDbId CALLED for e3dc-rscp.0.EMS.POWER_PV
sql.0
	2025-11-14 19:59:59.162	debug	pushValueIntoDB called for e3dc-rscp.0.EMS.POWER_PV (type: undefined, ID: 26) and state: {"val":0,"ack":true,"ts":1763146799078,"q":0,"from":"system.adapter.sql.0","user":"system.user.admin","lc":1763146799078}
sql.0
	2025-11-14 19:59:59.162	debug	prepareTaskCheckTypeAndDbId CALLED for e3dc-rscp.0.EMS.POWER_PV
sql.0
	2025-11-14 19:59:59.161	debug	pushValueIntoDB called for e3dc-rscp.0.EMS.POWER_PV (type: undefined, ID: 26) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.161	debug	prepareTaskCheckTypeAndDbId CALLED for e3dc-rscp.0.EMS.POWER_BAT
sql.0
	2025-11-14 19:59:59.161	debug	pushValueIntoDB called for e3dc-rscp.0.EMS.POWER_BAT (type: undefined, ID: 25) and state: {"val":0,"ack":true,"ts":1763146799078,"q":0,"from":"system.adapter.sql.0","user":"system.user.admin","lc":1763146799078}
sql.0
	2025-11-14 19:59:59.161	debug	prepareTaskCheckTypeAndDbId CALLED for e3dc-rscp.0.EMS.POWER_BAT
sql.0
	2025-11-14 19:59:59.161	debug	pushValueIntoDB called for e3dc-rscp.0.EMS.POWER_BAT (type: undefined, ID: 25) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.160	debug	prepareTaskCheckTypeAndDbId CALLED for e3dc-rscp.0.EMS.POWER_GRID
sql.0
	2025-11-14 19:59:59.160	debug	pushValueIntoDB called for e3dc-rscp.0.EMS.POWER_GRID (type: undefined, ID: 24) and state: {"val":590,"ack":true,"ts":1763146799078,"q":0,"from":"system.adapter.sql.0","user":"system.user.admin","lc":1763146799078}
sql.0
	2025-11-14 19:59:59.160	debug	prepareTaskCheckTypeAndDbId CALLED for e3dc-rscp.0.EMS.POWER_GRID
sql.0
	2025-11-14 19:59:59.160	debug	pushValueIntoDB called for e3dc-rscp.0.EMS.POWER_GRID (type: undefined, ID: 24) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.159	debug	prepareTaskCheckTypeAndDbId CALLED for e3dc-rscp.0.EMS.POWER_HOME
sql.0
	2025-11-14 19:59:59.159	debug	pushValueIntoDB called for e3dc-rscp.0.EMS.POWER_HOME (type: undefined, ID: 23) and state: {"val":590,"ack":true,"ts":1763146799078,"q":0,"from":"system.adapter.sql.0","user":"system.user.admin","lc":1763146799078}
sql.0
	2025-11-14 19:59:59.159	debug	prepareTaskCheckTypeAndDbId CALLED for e3dc-rscp.0.EMS.POWER_HOME
sql.0
	2025-11-14 19:59:59.159	debug	pushValueIntoDB called for e3dc-rscp.0.EMS.POWER_HOME (type: undefined, ID: 23) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.159	debug	prepareTaskCheckTypeAndDbId CALLED for e3dc-rscp.0.EMS.BAT_SOC
sql.0
	2025-11-14 19:59:59.158	debug	pushValueIntoDB called for e3dc-rscp.0.EMS.BAT_SOC (type: undefined, ID: 22) and state: {"val":0,"ack":true,"ts":1763146799078,"q":0,"from":"system.adapter.sql.0","user":"system.user.admin","lc":1763146799078}
sql.0
	2025-11-14 19:59:59.158	debug	prepareTaskCheckTypeAndDbId CALLED for e3dc-rscp.0.EMS.BAT_SOC
sql.0
	2025-11-14 19:59:59.158	debug	pushValueIntoDB called for e3dc-rscp.0.EMS.BAT_SOC (type: undefined, ID: 22) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.158	debug	prepareTaskCheckTypeAndDbId CALLED for e3dc-rscp.0.EMS.AUTARKY
sql.0
	2025-11-14 19:59:59.157	debug	pushValueIntoDB called for e3dc-rscp.0.EMS.AUTARKY (type: undefined, ID: 21) and state: {"val":0,"ack":true,"ts":1763146799078,"q":0,"from":"system.adapter.sql.0","user":"system.user.admin","lc":1763146799078}
sql.0
	2025-11-14 19:59:59.157	debug	prepareTaskCheckTypeAndDbId CALLED for e3dc-rscp.0.EMS.AUTARKY
sql.0
	2025-11-14 19:59:59.157	debug	pushValueIntoDB called for e3dc-rscp.0.EMS.AUTARKY (type: undefined, ID: 21) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.157	debug	prepareTaskCheckTypeAndDbId CALLED for kecontact.1.plug
sql.0
	2025-11-14 19:59:59.157	debug	pushValueIntoDB called for kecontact.1.plug (type: undefined, ID: 20) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.156	debug	prepareTaskCheckTypeAndDbId CALLED for kecontact.1.enableUser
sql.0
	2025-11-14 19:59:59.156	debug	pushValueIntoDB called for kecontact.1.enableUser (type: undefined, ID: 19) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.156	debug	prepareTaskCheckTypeAndDbId CALLED for kecontact.1.eTotal
sql.0
	2025-11-14 19:59:59.155	debug	pushValueIntoDB called for kecontact.1.eTotal (type: undefined, ID: 18) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.155	debug	prepareTaskCheckTypeAndDbId CALLED for kecontact.1.ePres
sql.0
	2025-11-14 19:59:59.155	debug	pushValueIntoDB called for kecontact.1.ePres (type: undefined, ID: 17) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.155	debug	prepareTaskCheckTypeAndDbId CALLED for kecontact.1.currentUser
sql.0
	2025-11-14 19:59:59.155	debug	pushValueIntoDB called for kecontact.1.currentUser (type: undefined, ID: 10) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.154	debug	prepareTaskCheckTypeAndDbId CALLED for kecontact.0.plug
sql.0
	2025-11-14 19:59:59.154	debug	pushValueIntoDB called for kecontact.0.plug (type: undefined, ID: 9) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.154	debug	prepareTaskCheckTypeAndDbId CALLED for kecontact.0.enableUser
sql.0
	2025-11-14 19:59:59.154	debug	pushValueIntoDB called for kecontact.0.enableUser (type: undefined, ID: 8) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.153	debug	prepareTaskCheckTypeAndDbId CALLED for kecontact.0.eTotal
sql.0
	2025-11-14 19:59:59.153	debug	pushValueIntoDB called for kecontact.0.eTotal (type: undefined, ID: 7) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.153	debug	prepareTaskCheckTypeAndDbId CALLED for kecontact.0.ePres
sql.0
	2025-11-14 19:59:59.152	debug	pushValueIntoDB called for kecontact.0.ePres (type: undefined, ID: 6) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.143	debug	pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for kecontact.0.currentUser (type: 0, ID: 5) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}: Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.143	warn	Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.143	debug	prepareTaskCheckTypeAndDbId getFrom system.adapter.sql.0 Result - isRunning length = 1
sql.0
	2025-11-14 19:59:59.142	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.142	debug	Return connection to pool: 0 now
sql.0
	2025-11-14 19:59:59.136	debug	Borrow connection from pool: 1 now
sql.0
	2025-11-14 19:59:59.136	debug	SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';
sql.0
	2025-11-14 19:59:59.136	debug	Type (from DB-Type) for kecontact.0.currentUser: 0
sql.0
	2025-11-14 19:59:59.135	debug	Type set in Def for kecontact.0.currentUser: false
sql.0
	2025-11-14 19:59:59.111	debug	prepareTaskCheckTypeAndDbId CALLED for kecontact.0.currentUser
sql.0
	2025-11-14 19:59:59.110	debug	pushValueIntoDB called for kecontact.0.currentUser (type: undefined, ID: 5) and state: {"val":null,"ts":1763146799074,"lc":1763146799074,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.108	debug	pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for fritzdect.0.DECT_152820324877.tsoll (type: 0, ID: 75) and state: {"val":null,"ts":1763146799078,"lc":1763146799078,"ack":true,"q":64,"from":"system.adapter.sql.0"}: Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.107	warn	Cannot get "from" for "system.adapter.sql.0": Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.107	debug	prepareTaskCheckTypeAndDbId getFrom system.adapter.sql.0 Result - isRunning length = 1
sql.0
	2025-11-14 19:59:59.107	error	Cannot select SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.106	debug	Return connection to pool: 0 now
sql.0
	2025-11-14 19:59:59.087	debug	Initialization done
sql.0
	2025-11-14 19:59:59.083	debug	Borrow connection from pool: 1 now
sql.0
	2025-11-14 19:59:59.083	debug	SELECT id FROM `iobroker`.sources WHERE name='system.adapter.sql.0';
sql.0
	2025-11-14 19:59:59.082	debug	Type (from DB-Type) for fritzdect.0.DECT_152820324877.tsoll: 0
sql.0
	2025-11-14 19:59:59.082	debug	Type set in Def for fritzdect.0.DECT_152820324877.tsoll: false
sql.0
	2025-11-14 19:59:59.082	debug	prepareTaskCheckTypeAndDbId CALLED for fritzdect.0.DECT_152820324877.tsoll
sql.0
	2025-11-14 19:59:59.081	debug	pushValueIntoDB called for fritzdect.0.DECT_152820324877.tsoll (type: undefined, ID: 75) and state: {"val":null,"ts":1763146799078,"lc":1763146799078,"ack":true,"q":64,"from":"system.adapter.sql.0"}
sql.0
	2025-11-14 19:59:59.078	info	enabled logging of e3dc-rscp.0.EMS.AUTARKY, Alias=false, 35 points now activated
sql.0
	2025-11-14 19:59:59.078	info	enabled logging of e3dc-rscp.0.EMS.BAT_SOC, Alias=false, 34 points now activated
sql.0
	2025-11-14 19:59:59.077	info	enabled logging of e3dc-rscp.0.EMS.POWER_GRID, Alias=false, 33 points now activated
sql.0
	2025-11-14 19:59:59.077	info	enabled logging of e3dc-rscp.0.EMS.POWER_HOME, Alias=false, 32 points now activated
sql.0
	2025-11-14 19:59:59.077	info	enabled logging of e3dc-rscp.0.EMS.POWER_BAT, Alias=false, 31 points now activated
sql.0
	2025-11-14 19:59:59.077	info	enabled logging of e3dc-rscp.0.EMS.POWER_PV, Alias=false, 30 points now activated
sql.0
	2025-11-14 19:59:59.077	info	enabled logging of e3dc-rscp.0.EMS.MAX_CHARGE_POWER, Alias=false, 29 points now activated
sql.0
	2025-11-14 19:59:59.076	info	enabled logging of 0_userdata.0.E3DC.Ertrag_PV-Zaun_Aktuell, Alias=false, 28 points now activated
sql.0
	2025-11-14 19:59:59.076	info	enabled logging of 0_userdata.0.E3DC.Erzeugung_aktuell_gesammt, Alias=false, 27 points now activated
sql.0
	2025-11-14 19:59:59.076	info	enabled logging of fritzdect.0.DECT_152820324877.tsoll, Alias=false, 26 points now activated
sql.0
	2025-11-14 19:59:59.076	info	enabled logging of fritzdect.0.DECT_152820324877.tist, Alias=false, 25 points now activated
sql.0
	2025-11-14 19:59:59.076	info	enabled logging of fritzdect.0.DECT_152820324877.battery, Alias=false, 24 points now activated
sql.0
	2025-11-14 19:59:59.075	info	enabled logging of sonoff.0.Wifi-Steckdose.ENERGY_Power, Alias=false, 23 points now activated
sql.0
	2025-11-14 19:59:59.075	info	enabled logging of sonoff.0.Wifi-Steckdose.ENERGY_Today, Alias=false, 22 points now activated
sql.0
	2025-11-14 19:59:59.075	info	enabled logging of sonoff.0.Wifi-Steckdose.ENERGY_Total, Alias=false, 21 points now activated
sql.0
	2025-11-14 19:59:59.075	info	enabled logging of sonoff.0.Wifi-Steckdose.POWER, Alias=false, 20 points now activated
sql.0
	2025-11-14 19:59:59.074	info	enabled logging of mqtt.0.FBH_EG.VENTIL5, Alias=false, 19 points now activated
sql.0
	2025-11-14 19:59:59.074	info	enabled logging of mqtt.0.FBH_EG.VENTIL4, Alias=false, 18 points now activated
sql.0
	2025-11-14 19:59:59.074	info	enabled logging of mqtt.0.FBH_EG.VENTIL3, Alias=false, 17 points now activated
sql.0
	2025-11-14 19:59:59.074	info	enabled logging of mqtt.0.FBH_EG.VENTIL2, Alias=false, 16 points now activated
sql.0
	2025-11-14 19:59:59.073	info	enabled logging of mqtt.0.FBH_EG.VENTIL1, Alias=false, 15 points now activated
sql.0
	2025-11-14 19:59:59.072	info	enabled logging of mqtt.0.Badsensor.humidity, Alias=false, 14 points now activated
sql.0
	2025-11-14 19:59:59.072	info	enabled logging of mqtt.0.Badsensor.temperature, Alias=false, 13 points now activated
sql.0
	2025-11-14 19:59:59.072	info	enabled logging of kecontact.1.statistics.lastChargeAmount, Alias=false, 12 points now activated
sql.0
	2025-11-14 19:59:59.072	info	enabled logging of kecontact.1.eTotal, Alias=false, 11 points now activated
sql.0
	2025-11-14 19:59:59.072	info	enabled logging of kecontact.1.ePres, Alias=false, 10 points now activated
sql.0
	2025-11-14 19:59:59.071	info	enabled logging of kecontact.1.currentUser, Alias=false, 9 points now activated
sql.0
	2025-11-14 19:59:59.071	info	enabled logging of kecontact.1.enableUser, Alias=false, 8 points now activated
sql.0
	2025-11-14 19:59:59.071	info	enabled logging of kecontact.1.plug, Alias=false, 7 points now activated
sql.0
	2025-11-14 19:59:59.071	info	enabled logging of kecontact.0.statistics.lastChargeAmount, Alias=false, 6 points now activated
sql.0
	2025-11-14 19:59:59.070	info	enabled logging of kecontact.0.eTotal, Alias=false, 5 points now activated
sql.0
	2025-11-14 19:59:59.070	info	enabled logging of kecontact.0.ePres, Alias=false, 4 points now activated
sql.0
	2025-11-14 19:59:59.070	info	enabled logging of kecontact.0.currentUser, Alias=false, 3 points now activated
sql.0
	2025-11-14 19:59:59.070	info	enabled logging of kecontact.0.enableUser, Alias=false, 2 points now activated
sql.0
	2025-11-14 19:59:59.069	info	enabled logging of kecontact.0.plug, Alias=false, 1 points now activated
sql.0
	2025-11-14 19:59:59.047	error	Cannot select SELECT id, name FROM `iobroker`.sources;: Error: Unknown column 'id' in 'field list'
sql.0
	2025-11-14 19:59:59.047	debug	Return connection to pool: 0 now
sql.0
	2025-11-14 19:59:59.041	debug	Borrow connection from pool: 1 now
sql.0
	2025-11-14 19:59:59.041	debug	SELECT id, name FROM `iobroker`.sources;
sql.0
	2025-11-14 19:59:59.039	debug	Return connection to pool: 0 now
sql.0
	2025-11-14 19:59:59.027	debug	Borrow connection from pool: 1 now
sql.0
	2025-11-14 19:59:59.027	debug	SELECT id, type, name FROM `iobroker`.datapoints;
sql.0
	2025-11-14 19:59:59.027	info	Connected to mysql
sql.0
	2025-11-14 19:59:59.026	debug	Return connection to pool: 0 now
sql.0
	2025-11-14 19:59:59.026	debug	Response: {"code":"ER_TABLE_EXISTS_ERROR","errno":1050,"sqlState":"42S01","sqlMessage":"Table 'ts_counter' already exists","sql":"CREATE TABLE `iobroker`.ts_counter (id INTEGER, ts BIGINT, val REAL);"}
sql.0
	2025-11-14 19:59:59.024	debug	CREATE TABLE `iobroker`.ts_counter (id INTEGER, ts BIGINT, val REAL);
sql.0
	2025-11-14 19:59:59.019	debug	Borrow connection from pool: 1 now
sql.0
	2025-11-14 19:59:59.019	debug	Return connection to pool: 0 now
sql.0
	2025-11-14 19:59:59.018	debug	Response: {"code":"ER_TABLE_EXISTS_ERROR","errno":1050,"sqlState":"42S01","sqlMessage":"Table 'ts_bool' already exists","sql":"CREATE TABLE `iobroker`.ts_bool (id INTEGER, ts BIGINT, val BOOLEAN, ack BOOLEAN, _from INTEGER, q INTEGER, PRIMARY KEY(id, ts));"}
sql.0
	2025-11-14 19:59:59.016	debug	CREATE TABLE `iobroker`.ts_bool (id INTEGER, ts BIGINT, val BOOLEAN, ack BOOLEAN, _from INTEGER, q INTEGER, PRIMARY KEY(id, ts));
sql.0
	2025-11-14 19:59:59.011	debug	Borrow connection from pool: 1 now
sql.0
	2025-11-14 19:59:59.011	debug	Return connection to pool: 0 now
sql.0
	2025-11-14 19:59:59.010	debug	Response: {"code":"ER_TABLE_EXISTS_ERROR","errno":1050,"sqlState":"42S01","sqlMessage":"Table 'ts_string' already exists","sql":"CREATE TABLE `iobroker`.ts_string (id INTEGER, ts BIGINT, val TEXT, ack BOOLEAN, _from INTEGER, q INTEGER, PRIMARY KEY(id, ts));"}
sql.0
	2025-11-14 19:59:59.009	debug	CREATE TABLE `iobroker`.ts_string (id INTEGER, ts BIGINT, val TEXT, ack BOOLEAN, _from INTEGER, q INTEGER, PRIMARY KEY(id, ts));
sql.0
	2025-11-14 19:59:59.003	debug	Borrow connection from pool: 1 now
sql.0
	2025-11-14 19:59:59.002	debug	Return connection to pool: 0 now
sql.0
	2025-11-14 19:59:59.002	debug	Response: {"code":"ER_TABLE_EXISTS_ERROR","errno":1050,"sqlState":"42S01","sqlMessage":"Table 'ts_number' already exists","sql":"CREATE TABLE `iobroker`.ts_number (id INTEGER, ts BIGINT, val REAL, ack BOOLEAN, _from INTEGER, q INTEGER, PRIMARY KEY(id, ts));"}
sql.0
	2025-11-14 19:59:59.000	debug	CREATE TABLE `iobroker`.ts_number (id INTEGER, ts BIGINT, val REAL, ack BOOLEAN, _from INTEGER, q INTEGER, PRIMARY KEY(id, ts));
sql.0
	2025-11-14 19:59:58.992	debug	Borrow connection from pool: 1 now
sql.0
	2025-11-14 19:59:58.992	debug	Return connection to pool: 0 now
sql.0
	2025-11-14 19:59:58.991	debug	Response: {"code":"ER_TABLE_EXISTS_ERROR","errno":1050,"sqlState":"42S01","sqlMessage":"Table 'datapoints' already exists","sql":"CREATE TABLE `iobroker`.datapoints (id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, name TEXT, type INTEGER);"}
sql.0
	2025-11-14 19:59:58.988	debug	CREATE TABLE `iobroker`.datapoints (id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, name TEXT, type INTEGER);
sql.0
	2025-11-14 19:59:58.980	debug	Borrow connection from pool: 1 now
sql.0
	2025-11-14 19:59:58.979	debug	Return connection to pool: 0 now
sql.0
	2025-11-14 19:59:58.978	debug	Response: {"code":"ER_TABLE_EXISTS_ERROR","errno":1050,"sqlState":"42S01","sqlMessage":"Table 'sources' already exists","sql":"CREATE TABLE `iobroker`.sources (id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, name TEXT);"}
sql.0
	2025-11-14 19:59:58.974	debug	CREATE TABLE `iobroker`.sources (id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, name TEXT);
sql.0
	2025-11-14 19:59:58.945	debug	Borrow connection from pool: 1 now
sql.0
	2025-11-14 19:59:58.818	info	starting. Version 3.0.1 in /opt/iobroker/node_modules/iobroker.sql, node: v20.19.5, js-controller: 7.0.7
sql.0
	2025-11-14 19:59:58.503	debug	Plugin sentry Initialize Plugin (enabled=true)

Was mir noch aufgefallen war, bei z.B. dem Fehler " WHERE name='system.adapter.kecontact.0" dass >system.adapter.kecontact.0< gar keinen Symbol hat um Daten in die SQL-Datenbank zu schreiben hat.

Der IoBroker läuft in einer VM auf einer Synology DS720+ und die MySQL-Datenbank direkt auf der Synology NAS und das Ganze seit geschätzt 2 Jahren ohne Probleme.
Vielleicht hast Du ja noch eine Idee was ich mal prüfen könnte.

Gruß
Onkel Tom

[Homoran]

@onkel-tom sagte in Fehlermeldungen vom SQL-Adapter - vermutlich etwas verstellt:

gar keinen Symbol hat um Daten in die SQL-Datenbank zu schreiben

bitte keine 2.5k Microfilmstreifen!

Das ist ein Verzeichnis!
Historisietrn kann man nur Werte, und due sind nur in Datenpunkten

[Onkel-Tom]

@homoran
Hallo Homoran,
das ist ja auch das was mich an der Fehlermeldung wundert. Im Log steht, dass es ein Problem mit z.B. "system.adapter.kecontact.0" gibt was man eigentlich gar nicht loggen kann da es ja keine Werte erzeugt.

[fastfoot]

@onkel-tom steht doch da!

Cannot select SELECT id FROM iobroker.sources WHERE name='system.adapter.sql.0';:
Error: Unknown column 'id' in 'field list'

prüfe mal die Felder der Tabelle sources ob es da ein Feld id gibt

[Onkel-Tom]

@fastfoot
Vielen, vielen Dank. Genau das war der Fehler!!!
Dann hatte es wohl doch nichts mit dem gefummel in den Objekten zu tun.
Keine Ahnung wieso, aber das Feld ID hatte den Namen 23 warum auch immer.
Bzgl. steht doch da -> lesen und verstehen sind manchmal verschieden Dinge ;-)
Leider kenne ich mich mit SQL nicht so aus habe aber in den letzten 2 Tagen viel gelernt.
Bin froh dass es jetzt wieder läuft. :grinning:

Gruß
Onkel Tom

[fastfoot]

@onkel-tom sagte in Fehlermeldungen vom SQL-Adapter - vermutlich etwas verstellt:

Keine Ahnung wieso,

das war bestimmt der iobroker-Teufel, der befällt öfter mal arglose User und lässt sie Dinge tun, an die sie sich später partout nicht mehr erinnern können :-)

[Onkel-Tom]

@fastfoot
war bestimmt ein digitaler Schluckauf :grinning:

[Dr. Bakterius]

@onkel-tom sagte in Fehlermeldungen vom SQL-Adapter - vermutlich etwas verstellt:

Auf die Datenbank kann ich noch über myPHPAdmin zugreifen und da scheint alles ok zu sein.

War es dann also doch nicht. :stuck_out_tongue: