Skip to content
  • Home
  • Aktuell
  • Tags
  • 0 Ungelesen 0
  • Kategorien
  • Unreplied
  • Beliebt
  • GitHub
  • Docu
  • Hilfe
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Standard: (Kein Skin)
  • Kein Skin
Einklappen
ioBroker Logo

Community Forum

donate donate
  1. ioBroker Community Home
  2. Deutsch
  3. Error/Bug
  4. Fehler bei SQL 1.4.2

NEWS

  • Neuer Blogbeitrag: Monatsrückblick - Dezember 2025 🎄
    BluefoxB
    Bluefox
    10
    1
    104

  • Weihnachtsangebot 2025! 🎄
    BluefoxB
    Bluefox
    24
    1
    1.4k

  • UPDATE 31.10.: Amazon Alexa - ioBroker Skill läuft aus ?
    apollon77A
    apollon77
    48
    3
    9.3k

Fehler bei SQL 1.4.2

Geplant Angeheftet Gesperrt Verschoben Error/Bug
20 Beiträge 2 Kommentatoren 1.8k Aufrufe
  • Älteste zuerst
  • Neuste zuerst
  • Meiste Stimmen
Antworten
  • In einem neuen Thema antworten
Anmelden zum Antworten
Dieses Thema wurde gelöscht. Nur Nutzer mit entsprechenden Rechten können es sehen.
  • apollon77A Online
    apollon77A Online
    apollon77
    schrieb am zuletzt editiert von
    #8

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

    Beitrag hat geholfen? Votet rechts unten im Beitrag :-) https://paypal.me/Apollon77 / https://github.com/sponsors/Apollon77

    • Debug-Log für Instanz einschalten? Admin -> Instanzen -> Expertenmodus -> Instanz aufklappen - Loglevel ändern
    • Logfiles auf Platte /opt/iobroker/log/… nutzen, Admin schneidet Zeilen ab
    1 Antwort Letzte Antwort
    0
    • sissiwupS Offline
      sissiwupS Offline
      sissiwup
      schrieb am zuletzt editiert von
      #9

      @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
      

      MfG

      Sissi

      –-----------------------------------------

      1 CCU3 1 CCU2-Gateway 1 LanGateway 1 Pi-Gateway 1 I7 für ioBroker/MySQL


      1 Antwort Letzte Antwort
      0
      • apollon77A Online
        apollon77A Online
        apollon77
        schrieb am zuletzt editiert von
        #10

        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 :-)

        Beitrag hat geholfen? Votet rechts unten im Beitrag :-) https://paypal.me/Apollon77 / https://github.com/sponsors/Apollon77

        • Debug-Log für Instanz einschalten? Admin -> Instanzen -> Expertenmodus -> Instanz aufklappen - Loglevel ändern
        • Logfiles auf Platte /opt/iobroker/log/… nutzen, Admin schneidet Zeilen ab
        1 Antwort Letzte Antwort
        0
        • sissiwupS Offline
          sissiwupS Offline
          sissiwup
          schrieb am zuletzt editiert von
          #11

          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) {
          
          

          MfG

          Sissi

          –-----------------------------------------

          1 CCU3 1 CCU2-Gateway 1 LanGateway 1 Pi-Gateway 1 I7 für ioBroker/MySQL


          1 Antwort Letzte Antwort
          0
          • apollon77A Online
            apollon77A Online
            apollon77
            schrieb am zuletzt editiert von
            #12

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

            Beitrag hat geholfen? Votet rechts unten im Beitrag :-) https://paypal.me/Apollon77 / https://github.com/sponsors/Apollon77

            • Debug-Log für Instanz einschalten? Admin -> Instanzen -> Expertenmodus -> Instanz aufklappen - Loglevel ändern
            • Logfiles auf Platte /opt/iobroker/log/… nutzen, Admin schneidet Zeilen ab
            1 Antwort Letzte Antwort
            0
            • sissiwupS Offline
              sissiwupS Offline
              sissiwup
              schrieb am zuletzt editiert von
              #13

              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
              

              MfG

              Sissi

              –-----------------------------------------

              1 CCU3 1 CCU2-Gateway 1 LanGateway 1 Pi-Gateway 1 I7 für ioBroker/MySQL


              1 Antwort Letzte Antwort
              0
              • apollon77A Online
                apollon77A Online
                apollon77
                schrieb am zuletzt editiert von
                #14

                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

                Beitrag hat geholfen? Votet rechts unten im Beitrag :-) https://paypal.me/Apollon77 / https://github.com/sponsors/Apollon77

                • Debug-Log für Instanz einschalten? Admin -> Instanzen -> Expertenmodus -> Instanz aufklappen - Loglevel ändern
                • Logfiles auf Platte /opt/iobroker/log/… nutzen, Admin schneidet Zeilen ab
                1 Antwort Letzte Antwort
                0
                • sissiwupS Offline
                  sissiwupS Offline
                  sissiwup
                  schrieb am zuletzt editiert von
                  #15
                  {
                    "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"
                  }
                  

                  MfG

                  Sissi

                  –-----------------------------------------

                  1 CCU3 1 CCU2-Gateway 1 LanGateway 1 Pi-Gateway 1 I7 für ioBroker/MySQL


                  1 Antwort Letzte Antwort
                  0
                  • apollon77A Online
                    apollon77A Online
                    apollon77
                    schrieb am zuletzt editiert von
                    #16

                    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

                    Beitrag hat geholfen? Votet rechts unten im Beitrag :-) https://paypal.me/Apollon77 / https://github.com/sponsors/Apollon77

                    • Debug-Log für Instanz einschalten? Admin -> Instanzen -> Expertenmodus -> Instanz aufklappen - Loglevel ändern
                    • Logfiles auf Platte /opt/iobroker/log/… nutzen, Admin schneidet Zeilen ab
                    1 Antwort Letzte Antwort
                    0
                    • sissiwupS Offline
                      sissiwupS Offline
                      sissiwup
                      schrieb am zuletzt editiert von
                      #17

                      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
                      

                      MfG

                      Sissi

                      –-----------------------------------------

                      1 CCU3 1 CCU2-Gateway 1 LanGateway 1 Pi-Gateway 1 I7 für ioBroker/MySQL


                      1 Antwort Letzte Antwort
                      0
                      • apollon77A Online
                        apollon77A Online
                        apollon77
                        schrieb am zuletzt editiert von
                        #18

                        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

                        Beitrag hat geholfen? Votet rechts unten im Beitrag :-) https://paypal.me/Apollon77 / https://github.com/sponsors/Apollon77

                        • Debug-Log für Instanz einschalten? Admin -> Instanzen -> Expertenmodus -> Instanz aufklappen - Loglevel ändern
                        • Logfiles auf Platte /opt/iobroker/log/… nutzen, Admin schneidet Zeilen ab
                        1 Antwort Letzte Antwort
                        0
                        • sissiwupS Offline
                          sissiwupS Offline
                          sissiwup
                          schrieb am zuletzt editiert von
                          #19

                          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)
                          

                          MfG

                          Sissi

                          –-----------------------------------------

                          1 CCU3 1 CCU2-Gateway 1 LanGateway 1 Pi-Gateway 1 I7 für ioBroker/MySQL


                          1 Antwort Letzte Antwort
                          0
                          • apollon77A Online
                            apollon77A Online
                            apollon77
                            schrieb am zuletzt editiert von
                            #20

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

                            Beitrag hat geholfen? Votet rechts unten im Beitrag :-) https://paypal.me/Apollon77 / https://github.com/sponsors/Apollon77

                            • Debug-Log für Instanz einschalten? Admin -> Instanzen -> Expertenmodus -> Instanz aufklappen - Loglevel ändern
                            • Logfiles auf Platte /opt/iobroker/log/… nutzen, Admin schneidet Zeilen ab
                            1 Antwort Letzte Antwort
                            0
                            Antworten
                            • In einem neuen Thema antworten
                            Anmelden zum Antworten
                            • Älteste zuerst
                            • Neuste zuerst
                            • Meiste Stimmen


                            Support us

                            ioBroker
                            Community Adapters
                            Donate

                            835

                            Online

                            32.5k

                            Benutzer

                            81.7k

                            Themen

                            1.3m

                            Beiträge
                            Community
                            Impressum | Datenschutz-Bestimmungen | Nutzungsbedingungen | Einwilligungseinstellungen
                            ioBroker Community 2014-2025
                            logo
                            • Anmelden

                            • Du hast noch kein Konto? Registrieren

                            • Anmelden oder registrieren, um zu suchen
                            • Erster Beitrag
                              Letzter Beitrag
                            0
                            • Home
                            • Aktuell
                            • Tags
                            • Ungelesen 0
                            • Kategorien
                            • Unreplied
                            • Beliebt
                            • GitHub
                            • Docu
                            • Hilfe