Dein SQL wurde nicht upgedatet. Es gibt schon 1.0.1 `
Hallo Bluefox
Das Update über die Webkonsole funktionierte nicht, habe es dann über die CMD Konsole erfolgreich ausgeführt.
Nach dem durchstarten des Rechners, funktionierte wieder alles.
Grossen Dank
Fred
Danke.
Werde heute Abend fixen. `
Hallo Bluefox
Nach dem Update am 24.5.2016 läuft der SQL Adapter nicht mehr.
Habe den SQL Adapter deinstalliert und neu installiert ohne Erfolg.
Adapter Info: Verbunden mit Host : falsch
Lebenszeichen: falsch
Beim Starten wird folgendes ins Log geschrieben:
Home_Broker 26 07:59:13.650 warn host.Home_Broker warning: Timeout by read all package.json (87) seconds
Home_Broker 26 07:59:13.601 warn host.Home_Broker warning: Timeout by read all package.json (87) seconds
Home_Broker 26 07:59:11.082 info host.Home_Broker Restart adapter system.adapter.sql.0 because enabled
Home_Broker 26 07:59:11.082 error host.Home_Broker instance system.adapter.sql.0 terminated with code 0 (OK)
Home_Broker 26 07:59:11.064 info host.Home_Broker Restart adapter system.adapter.sql.0 because enabled
Home_Broker 26 07:59:11.063 error host.Home_Broker instance system.adapter.sql.0 terminated with code 0 (OK)
sql.0 26 07:59:11.035 warn sql.0 Exception: TypeError: Cannot set property 'index' of undefined
sql.0 26 07:59:11.035 error TypeError: Cannot set property 'index' of undefined at Statement. (C:\Program Files\ioBroker\node_modules\iobroker.sql\main.js:579:48) –> in Database#all('SELECT id, type, name FROM da
sql.0 26 07:59:11.035 error uncaught exception: Cannot set property 'index' of undefined
sql.0 26 07:59:11.015 info sql.0 Connected to sqlite
sql.0 26 07:59:10.977 info sql.0 starting. Version 1.0.0 in C:/Program Files/ioBroker/node_modules/iobroker.sql
Home_Broker 26 07:59:08.603 info host.Home_Broker instance system.adapter.sql.0 started with pid 6832
Home_Broker 26 07:59:08.593 info host.Home_Broker instance system.adapter.sql.0 started with pid 6832
host-Home_Broker 26 07:58:38.589 info Restart adapter system.adapter.sql.0 because enabled
host-Home_Broker 26 07:58:38.587 error instance system.adapter.sql.0 terminated with code 0 (OK)
sql-0 26 07:58:38.555 info terminating
sql-0 26 07:58:38.542 warn Exception: TypeError: Cannot set property 'index' of undefined
TypeError: 26 07:58:38.539 error at C:\Program Files\ioBroker\node_modules\iobroker.sql\main.js:569:16
TypeError: 26 07:58:38.539 error at SQLClient.execute (C:\Program Files\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\sql-client.js:4:59)
TypeError: 26 07:58:38.539 error at SQLClient.execute (C:\Program Files\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\sql-client.js:87:29)
TypeError: 26 07:58:38.539 error at SQLite3ConnectionFactory.pre_process_sql (C:\Program Files\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\connection-factory.js:4:59)
TypeError: 26 07:58:38.539 error at SQLite3ConnectionFactory.ConnectionFactory.pre_process_sql (C:\Program Files\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\connection-factory.js:42:14)
TypeError: 26 07:58:38.539 error at C:\Program Files\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\sql-client.js:95:36
TypeError: 26 07:58:38.539 error at SQLite3ConnectionFactory.execute (C:\Program Files\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\connection-factory.js:4:59)
TypeError: 26 07:58:38.539 error at SQLite3ConnectionFactory. (C:\Program Files\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\sqlite3-client.js:4:59)
TypeError: 26 07:58:38.539 error at SQLite3ConnectionFactory.execute (C:\Program Files\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\sqlite3-client.js:63:17)
TypeError: 26 07:58:38.539 error --> in Database#all('SELECT id, type, name FROM datapoints;', [], [Function])
TypeError: 26 07:58:38.539 error at Statement. (C:\Program Files\ioBroker\node_modules\iobroker.sql\main.js:579:48)
TypeError: 26 07:58:38.539 error Cannot set property 'index' of undefined
uncaught 26 07:58:38.538 error exception: Cannot set property 'index' of undefined
sql-0 26 07:58:38.525 info Connected to sqlite
sql-0 26 07:58:38.492 info enabled logging of node-red.0.BatSoC
sql-0 26 07:58:38.490 info enabled logging of node-red.0.BatcapW
Kannst du mir ein Tipp geben
Gruss und Danke
Fred
Hallo zusammen
Habe das gleiche Problem nach dem Update! :roll:
Bei mir lässt sich der sqlite3 Adapter nicht mehr starten, keine Verbindung mit Host und die Anzeige der Instanz ist rot…
Hat jemand eine idee ???
Gruss
Fred `
Habe jetzt noch das Log zu der Fehlermeldung:
host-Home_Broker 24 07:41:19.124 info Restart adapter system.adapter.sql.0 because enabled
host-Home_Broker 24 07:41:19.124 error instance system.adapter.sql.0 terminated with code 0 (OK)
sql-0 24 07:41:19.093 info terminating
sql-0 24 07:41:19.078 warn Exception: TypeError: Cannot set property 'index' of undefined
TypeError: 24 07:41:19.078 error at C:\Program Files\ioBroker\node_modules\iobroker.sql\main.js:569:16
TypeError: 24 07:41:19.078 error at SQLClient.execute (C:\Program Files\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\sql-client.js:4:59)
TypeError: 24 07:41:19.078 error at SQLClient.execute (C:\Program Files\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\sql-client.js:87:29)
TypeError: 24 07:41:19.078 error at SQLite3ConnectionFactory.pre_process_sql (C:\Program Files\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\connection-factory.js:4:59)
TypeError: 24 07:41:19.078 error at SQLite3ConnectionFactory.ConnectionFactory.pre_process_sql (C:\Program Files\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\connection-factory.js:42:14)
TypeError: 24 07:41:19.078 error at C:\Program Files\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\sql-client.js:95:36
TypeError: 24 07:41:19.078 error at SQLite3ConnectionFactory.execute (C:\Program Files\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\connection-factory.js:4:59)
TypeError: 24 07:41:19.078 error at SQLite3ConnectionFactory. (C:\Program Files\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\sqlite3-client.js:4:59)
TypeError: 24 07:41:19.078 error at SQLite3ConnectionFactory.execute (C:\Program Files\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\sqlite3-client.js:63:17)
TypeError: 24 07:41:19.078 error –> in Database#all('SELECT id, type, name FROM datapoints;', [], [Function])
TypeError: 24 07:41:19.078 error at Statement. (C:\Program Files\ioBroker\node_modules\iobroker.sql\main.js:579:48)
TypeError: 24 07:41:19.078 error Cannot set property 'index' of undefined
uncaught 24 07:41:19.078 error exception: Cannot set property 'index' of undefined
sql-0 24 07:41:19.062 info Connected to sqlite
sql-0 24 07:41:18.953 info starting. Version 1.0.0 in C:/Program Files/ioBroker/node_modules/iobroker.sql
host-Home_Broker 24 07:41:16.906 info instance system.adapter.sql.0 started with pid 5116
host-Home_Broker 24 07:40:46.908 info Restart adapter system.adapter.sql.0 because enabled
host-Home_Broker 24 07:40:46.908 error instance system.adapter.sql.0 terminated with code 0 (OK)
sql-0 24 07:40:46.877 info terminating
Hallo zusammen
Habe das gleiche Problem nach dem Update! :roll:
Bei mir lässt sich der sqlite3 Adapter nicht mehr starten, keine Verbindung mit Host und die Anzeige der Instanz ist rot…
Hat jemand eine idee ???
Gruss
Fred
