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
    5
    1
    46

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

                          347

                          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