Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. Error/Bug
    4. Fehler bei SQL 1.4.2

    NEWS

    • Neuer Blog: Fotos und Eindrücke aus Solingen

    • ioBroker@Smart Living Forum Solingen, 14.06. - Agenda added

    • ioBroker goes Matter ... Matter Adapter in Stable

    Fehler bei SQL 1.4.2

    This topic has been deleted. Only users with topic management privileges can see it.
    • sissiwup
      sissiwup last edited by

      @apollon77:

      Hast Du normal aktualisiert oder vom github aktualisiert? Musst von Githuvb holen weil erstmal nur da der Fehler gefixt ist (zum testen) `

      Habe ich jetzt:

      SQL 1.4.4

      bei admin gibt es aber:

      $ ./iobroker url "https://github.com/ioBroker/ioBroker.admin/tarball/master" admin
      install https://github.com/ioBroker/ioBroker.admin/tarball/master
      npm install https://github.com/ioBroker/ioBroker.admin/tarball/master --production --prefix "/opt/iobroker" (System call)
      npm WARN
       enoent ENOENT: no such file or directory, open '/opt/iobroker/node_modules/buildmail/package.json'npm WARN enoent ENOENT: no such file or directory, open '/opt/iobroker/node_modules/commist/package.json'
      npm WARN enoent ENOENT: no such file or directory, open '/opt/iobroker/node_modules/concat-stream/package.json'
      npm WARN enoent ENOENT: no such file or directory, open '/opt/iobroker/node_modules/duplexify/package.json'
      npm WARN enoent ENOENT: no such file or directory, open '/opt/iobroker/node_modules/follow-redirects/package.json'
      npm WARN enoent ENOENT: no such file or directory, open '/opt/iobroker/node_modules/glob-stream/package.json'
      npm WARN enoent ENOENT: no such file or directory, open '/opt/iobroker/node_modules/imap/package.json'
      
      ERROR: host.zotac Cannot install https://github.com/ioBroker/ioBroker.admin/tarball/master: 1
      ERROR: process exited with code 25
      
      1 Reply Last reply Reply Quote 0
      • apollon77
        apollon77 last edited by

        Admin brauchst DU an sich nicht vom Github. Der Bugfix von mir war in sql drin.

        1 Reply Last reply Reply Quote 0
        • sissiwup
          sissiwup last edited by

          @apollon77:

          Admin brauchst DU an sich nicht vom Github. Der Bugfix von mir war in sql drin. `

          Ok,

          nach Neustart Rega kommt jetzt:

          hm-rega.0	2017-02-17 14:31:30.565	info	hm-rega.0 added/updated 66 variables
          zotac	2017-02-17 14:31:28.887	info	host.zotac Restart adapter system.adapter.sql.0 because enabled
          zotac	2017-02-17 14:31:28.886	error	host.zotac instance system.adapter.sql.0 terminated with code 0 (OK)
          hm-rega.0	2017-02-17 14:31:28.824	info	hm-rega.0 got 66 variables
          sql.0	2017-02-17 14:31:27.924	warn	sql.0 Exception: TypeError: Cannot read property 'sql.0' of undefined
          sql.0	2017-02-17 14:31:27.924	error	sql.0 TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:42:49) at emitTwo (events.js:106:13) at Adapter.emit (eve
          sql.0	2017-02-17 14:31:27.924	error	sql.0 uncaught exception: Cannot read property 'sql.0' of undefined
          sql.0	2017-02-17 14:31:27.922	warn	sql.0 Exception: TypeError: Cannot read property 'sql.0' of undefined
          sql.0	2017-02-17 14:31:27.922	error	sql.0 TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:42:49) at emitTwo (events.js:106:13) at Adapter.emit (eve
          sql.0	2017-02-17 14:31:27.920	error	sql.0 uncaught exception: Cannot read property 'sql.0' of undefined
          hm-rega.0	2017-02-17 14:31:27.874	info	hm-rega.0 deleted 0 programs
          hm-rega.0	2017-02-17 14:31:27.874	info	hm-rega.0 added/updated 89 programs
          hm-rega.0	2017-02-17 14:31:27.553	info	hm-rega.0 got 89 programs
          
          1 Reply Last reply Reply Quote 0
          • apollon77
            apollon77 last edited by

            Ich kapiere es nicht …

            Schau bitte mal auf der Platte in /opt/iobroker/node_modules/iobroker.sql/main.js in Zeile 42. Diese sollte mit dem Github Update so aussehen:

                    (obj.common.history && obj.common.history[adapter.namespace]) ||
            
            

            Wenn nein ändere Sie mal so, dann hast Du irgendwie doch das upfdate von Github nicht bekommen (was komisch wäre). Aber erstmal egal 🙂

            1 Reply Last reply Reply Quote 0
            • sissiwup
              sissiwup last edited by

              Hallo,

              da steht:

              38 var adapter = utils.adapter('sql');
                   39 adapter.on('objectChange', function (id, obj) {
                   40     if (obj && obj.common && (
                   41             // todo remove history sometime (2016.08) - Do not forget object selector in io-package.json
                   42         (obj.common.history && obj.common.history[adapter.namespace]) ||
                   43         (obj.common.custom  && obj.common.custom[adapter.namespace])) &&
                   44         (obj.common.custom[adapter.namespace].enabled)
                   45     ) {
                   46         if (!sqlDPs[id] && !subscribeAll) {
              
              
              1 Reply Last reply Reply Quote 0
              • apollon77
                apollon77 last edited by

                jetzt kapier ichs nimmer … versuch nochmal nicht das beim letzten update nicht neu gestartet war und deswegen noch das alte lief ... 😉

                ANsonsten kann ichs echt nicht mehr verstehen weil jetzt auch die Spaltennummer nicht mehr 49 sein kann ...

                1 Reply Last reply Reply Quote 0
                • sissiwup
                  sissiwup last edited by

                  Hallo,

                  Neustart hat er heute Nacht automatisch gemacht.

                  Restart REGA-Adapter:

                  hm-rega.0	2017-02-18 10:57:05.154	info	added/updated 66 variables
                  hm-rega.0	2017-02-18 10:57:04.640	info	got 66 variables
                  zotac	2017-02-18 10:57:04.637	info	host.zotac Restart adapter system.adapter.sql.0 because enabled
                  zotac	2017-02-18 10:57:04.636	error	host.zotac instance system.adapter.sql.0 terminated with code 6 (uncaught exception)
                  sql.0	2017-02-18 10:57:03.650	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.650	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                  sql.0	2017-02-18 10:57:03.650	error	uncaught exception: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.650	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.650	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                  sql.0	2017-02-18 10:57:03.650	error	uncaught exception: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.650	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.650	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                  sql.0	2017-02-18 10:57:03.650	error	uncaught exception: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.649	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.649	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                  sql.0	2017-02-18 10:57:03.648	error	uncaught exception: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.648	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.647	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                  sql.0	2017-02-18 10:57:03.647	error	uncaught exception: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.647	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.647	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                  sql.0	2017-02-18 10:57:03.646	error	uncaught exception: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.646	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.646	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                  sql.0	2017-02-18 10:57:03.644	error	uncaught exception: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.644	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.644	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                  sql.0	2017-02-18 10:57:03.644	error	uncaught exception: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.644	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.644	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                  sql.0	2017-02-18 10:57:03.643	error	uncaught exception: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.643	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.643	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                  sql.0	2017-02-18 10:57:03.643	error	uncaught exception: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.643	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.643	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                  sql.0	2017-02-18 10:57:03.643	error	uncaught exception: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.643	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.643	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                  sql.0	2017-02-18 10:57:03.642	error	uncaught exception: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.344	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                  sql.0	2017-02-18 10:57:03.318	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                  sql.0	2017-02-18 10:57:03.316	error	uncaught exception: Cannot read property 'sql.0' of undefined
                  hm-rega.0	2017-02-18 10:57:03.278	info	deleted 0 programs
                  hm-rega.0	2017-02-18 10:57:03.278	info	added/updated 89 programs
                  hm-rega.0	2017-02-18 10:57:02.944	info	got 89 programs
                  hm-rega.0	2017-02-18 10:57:00.781	info	added/updated rooms to enum.room
                  
                  1 Reply Last reply Reply Quote 0
                  • apollon77
                    apollon77 last edited by

                    Jetzt ists auch ne andere Zeilennummer 🙂

                    Kannst Du mir einen gefallen tun (sonst muss ich weiter raten): Überleg mal welcher der hm-Datenpunkte die DU loggst der ist der am längsten loggt. Un bei den gehst DU in der "Objekte"-Ansicht auf den Stift rechts am Ende. Dort auf "Raw-Ansicht (Experten only)" und schick mir mal das JSON was Du da siehst. Dann sollte das simpel sein final zu fixen weil ich das Problem jetzt im Blick hab

                    1 Reply Last reply Reply Quote 0
                    • sissiwup
                      sissiwup last edited by

                      {
                        "common": {
                          "name": "HZ-01:4.ACTUAL_TEMPERATURE",
                          "type": "number",
                          "unit": "°C",
                          "role": "value.temperature",
                          "def": 0,
                          "min": -10,
                          "max": 56,
                          "read": true,
                          "write": false,
                          "custom": {
                            "history.0": {
                              "enabled": true,
                              "changesOnly": true,
                              "minLength": 480,
                              "maxLength": 960,
                              "retention": 0,
                              "debounce": 10000
                            },
                            "sql.0": {
                              "enabled": true,
                              "changesOnly": false,
                              "debounce": 1000,
                              "retention": 63072000
                            }
                          }
                        },
                        "native": {
                          "CONTROL": "HEATING_CONTROL.TEMPERATURE",
                          "ID": "ACTUAL_TEMPERATURE",
                          "TYPE": "FLOAT",
                          "UNIT": "�C",
                          "DEFAULT": 0,
                          "FLAGS": 1,
                          "MAX": 56,
                          "MIN": -10,
                          "OPERATIONS": 5,
                          "TAB_ORDER": 5
                        },
                        "acl": {
                          "object": 1638,
                          "owner": "system.user.admin",
                          "ownerGroup": "system.group.administrator",
                          "state": 1638
                        },
                        "_id": "hm-rpc.0.MEQ0008905.4.ACTUAL_TEMPERATURE",
                        "type": "state"
                      }
                      
                      1 Reply Last reply Reply Quote 0
                      • apollon77
                        apollon77 last edited by

                        Der kanns nicht sein … aber naja ... versuch mal neu mit der github version ... und nach install (ist dann die 1.4.5) neu startenvom sql Adapter und dann versuch nochmal

                        1 Reply Last reply Reply Quote 0
                        • sissiwup
                          sissiwup last edited by

                          Hallo,

                          welcher der wirklich älteste ist, weiss ich nicht, habe einen recht alten ausgewählt.

                          Mit neuer Version 1.4.5:

                          sql.0	2017-02-19 15:36:24.010	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:24.010	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:24.010	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:24.010	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:24.010	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:24.010	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:24.010	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:24.010	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:24.010	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:24.010	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:24.010	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:24.009	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:24.009	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:24.009	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:24.009	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:24.009	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:24.009	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:24.009	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:24.009	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:24.009	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:24.009	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.694	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.694	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:23.693	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.570	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.569	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:23.569	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.569	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.569	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:23.569	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.569	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.569	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:23.569	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.569	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.569	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:23.569	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.569	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.569	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:23.568	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.568	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.568	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:23.568	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.568	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.568	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:23.568	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.562	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.562	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:23.562	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.562	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.562	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:23.562	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.562	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.562	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:23.562	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.561	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.561	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:23.561	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.561	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.561	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:23.561	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.561	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.561	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:23.560	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.306	warn	Exception: TypeError: Cannot read property 'sql.0' of undefined
                          sql.0	2017-02-19 15:36:23.306	error	TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js
                          sql.0	2017-02-19 15:36:23.305	error	uncaught exception: Cannot read property 'sql.0' of undefined
                          hm-rega.0	2017-02-19 15:36:23.278	info	deleted 0 programs
                          hm-rega.0	2017-02-19 15:36:23.278	info	added/updated 89 programs
                          hm-rega.0	2017-02-19 15:36:22.923	info	got 89 programs
                          hm-rega.0	2017-02-19 15:36:21.147	info	added/updated rooms to enum.rooms
                          hm-rega.0	2017-02-19 15:36:20.872	info	added/updated functions to enum.functions
                          hm-rega.0	2017-02-19 15:36:20.385	info	added/updated 26 favorites to enum.favorites
                          hm-rega.0	2017-02-19 15:36:20.077	info	time difference local-ccu 0s
                          hm-rega.0	2017-02-19 15:36:20.004	info	ReGaHSS 192.168.1.11 up
                          hm-rega.0	2017-02-19 15:36:18.934	info	subscribe hm-rpc.0.BidCoS-RF.50.PRESS_SHORT
                          hm-rega.0	2017-02-19 15:36:18.917	info	starting. Version 1.4.3 in /opt/iobroker/node_modules/iobroker.hm-rega, node: v6.9.2
                          host.zotac	2017-02-19 15:36:17.848	info	instance system.adapter.hm-rega.0 started with pid 397
                          host.zotac	2017-02-19 15:36:15.410	info	instance system.adapter.hm-rega.0 terminated with code 0 (OK)
                          hm-rega.0	2017-02-19 15:36:15.343	info	terminating
                          host.zotac	2017-02-19 15:36:15.287	info	stopInstance system.adapter.hm-rega.0 killing pid 19130
                          host.zotac	2017-02-19 15:36:15.287	info	stopInstance system.adapter.hm-rega.0
                          host.zotac	2017-02-19 15:36:15.284	info	object change system.adapter.hm-rega.0
                          host.zotac	2017-02-19 15:34:42.429	info	Update repository "default" under "conf/sources-dist.json"
                          iobroker	2017-02-19 15:34:42.114	info	exit 0
                          
                          1 Reply Last reply Reply Quote 0
                          • apollon77
                            apollon77 last edited by

                            Also irgendwie hat Install von Github nicht geklappt oder restart hat gefehlt.Zeilennnummer des Fehlers passen wieder nicht zur neuen Version 🙂

                            Ab Zeile 40 muss es so aussehen: https://github.com/ioBroker/ioBroker.sq … ain.js#L40

                            1 Reply Last reply Reply Quote 0
                            • sissiwup
                              sissiwup last edited by

                              Hallo,

                              der sql-Adapter ist immer neu gestartet. Der Rest natürlich nicht.

                              Aber nach Neustart heute Nacht kommt folgendes:

                              admin.0	2017-02-20 11:53:06.174	info	received all states
                              admin.0	2017-02-20 11:53:05.196	info	Subscribe on all states again
                              admin.0	2017-02-20 11:52:33.385	info	Unsubscribe from all states, except system's, because over 3 seconds the number of events is over 200 (in last second 0)
                              hm-rega.0	2017-02-20 11:52:30.021	info	got state values
                              hm-rega.0	2017-02-20 11:52:25.223	info	request state values
                              hm-rega.0	2017-02-20 11:52:25.221	info	deleted 0 variables
                              hm-rega.0	2017-02-20 11:52:25.220	info	added/updated 66 variables
                              hm-rega.0	2017-02-20 11:52:24.707	info	got 66 variables
                              hm-rega.0	2017-02-20 11:52:23.758	info	deleted 0 programs
                              hm-rega.0	2017-02-20 11:52:23.757	info	added/updated 89 programs
                              hm-rega.0	2017-02-20 11:52:23.430	info	got 89 programs
                              hm-rega.0	2017-02-20 11:52:22.050	info	added/updated rooms to enum.rooms
                              hm-rega.0	2017-02-20 11:52:21.348	info	added/updated functions to enum.functions
                              hm-rega.0	2017-02-20 11:52:20.867	info	added/updated 26 favorites to enum.favorites
                              hm-rega.0	2017-02-20 11:52:20.517	info	time difference local-ccu 1s
                              hm-rega.0	2017-02-20 11:52:20.439	info	ReGaHSS 192.168.1.11 up
                              hm-rega.0	2017-02-20 11:52:19.394	info	subscribe hm-rpc.0.BidCoS-RF.50.PRESS_SHORT
                              hm-rega.0	2017-02-20 11:52:19.377	info	starting. Version 1.4.3 in /opt/iobroker/node_modules/iobroker.hm-rega, node: v6.9.2
                              host.zotac	2017-02-20 11:52:18.155	info	instance system.adapter.hm-rega.0 started with pid 31795
                              host.zotac	2017-02-20 11:52:15.724	info	instance system.adapter.hm-rega.0 terminated with code 0 (OK)
                              hm-rega.0	2017-02-20 11:52:15.652	info	terminating
                              host.zotac	2017-02-20 11:52:15.607	info	stopInstance system.adapter.hm-rega.0 killing pid 21557
                              host.zotac	2017-02-20 11:52:15.605	info	stopInstance system.adapter.hm-rega.0
                              host.zotac	2017-02-20 11:52:15.598	info	object change system.adapter.hm-rega.0
                              host.zotac	2017-02-20 11:46:03.026	info	instance system.adapter.tankerkoenig.0 terminated with code 0 (OK)
                              
                              1 Reply Last reply Reply Quote 0
                              • apollon77
                                apollon77 last edited by

                                Ja das sieht doch dann nach "kein Fehler mehr "aus, oder ?! :-)))

                                1 Reply Last reply Reply Quote 0
                                • First post
                                  Last post

                                Support us

                                ioBroker
                                Community Adapters
                                Donate

                                823
                                Online

                                31.8k
                                Users

                                80.0k
                                Topics

                                1.3m
                                Posts

                                2
                                20
                                1759
                                Loading More Posts
                                • Oldest to Newest
                                • Newest to Oldest
                                • Most Votes
                                Reply
                                • Reply as topic
                                Log in to reply
                                Community
                                Impressum | Datenschutz-Bestimmungen | Nutzungsbedingungen
                                The ioBroker Community 2014-2023
                                logo