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.
    • 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

                              834
                              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