Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. Error/Bug
    4. SQL Adapter schreibt numbers in ts_string

    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

    UNSOLVED SQL Adapter schreibt numbers in ts_string

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

      Hallo zusammen,

      ich möchte die Temperatur eines Raspberry über den RPI Adapter per MySQL aufnehmen. Dabei schriebt er mir jedoch die Number in die ts_string Tabelle.
      Einstellungen:
      alt text

      {
        "from": "system.adapter.rpi2.0",
        "user": "system.user.admin",
        "ts": 1596111698665,
        "common": {
          "name": "rpi2.0.temperature.soc_temp",
          "state": "state",
          "role": "value",
          "type": "number",
          "read": true,
          "write": false,
          "custom": {
            "sql.0": {
              "enabled": true,
              "changesOnly": true,
              "debounce": "1000",
              "retention": 0,
              "changesRelogInterval": 0,
              "changesMinDelta": 0,
              "storageType": "Number",
              "aliasId": "",
              "counter": false
            }
          }
        },
        "native": {},
        "acl": {
          "object": 1636,
          "owner": "system.user.admin",
          "ownerGroup": "system.group.administrator",
          "state": 1636
        },
        "_id": "rpi2.0.temperature.soc_temp",
        "type": "state"
      }
      

      VG!

      Systemdata Bitte Ausfüllen
      Hardwaresystem: Proxmox.
      Arbeitsspeicher: 4GB
      Festplattenart: M2 SSD
      Betriebssystem: Ubuntu20.04
      Node-Version: utd
      Nodejs-Version: utd
      NPM-Version: utd
      Installationsart: Manuell
      Image genutzt: Nein
      1 Reply Last reply Reply Quote 0
      • First post
        Last post

      Support us

      ioBroker
      Community Adapters
      Donate

      483
      Online

      31.9k
      Users

      80.1k
      Topics

      1.3m
      Posts

      mysql
      1
      1
      119
      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