ioBroker / ioBroker.sql

Store history data in SQL Database: MySQL, PostgreSQL or SQLite
MIT License
45 stars 25 forks source link

sql has an invalid jsonConfig #348

Closed Norb1204 closed 1 month ago

Norb1204 commented 6 months ago

No existing issues.

Describe the bug

Beim Öffnen/Editieren des SQL-Adapters kommt folgende Warnmeldung:

2024-01-17 13:16:58.205 - warn: admin.0 (758) sql has an invalid jsonConfig: [{"instancePath":"/items/dbTab/items/_testConnection/type","schemaPath":"#/definitions/componentType/enum","keyword":"enum","params":{"allowedValues":["alive","autocomplete","cron","fileSelector","text","textSendTo","number","port","color","checkbox","chips","header","slider","ip","user","room","func","select","icon","image","panel","password","file","sendTo","staticText","custom","pattern","table","instance","language","setState","certificate","certificates","staticImage","staticLink","divider","objectId","selectSendTo","autocompleteSendTo","checkLicense","uuid"]},"message":"must be equal to one of the allowed values"},{"instancePath":"/items/dbTab","schemaPath":"#/properties/items/patternProperties/%5E.%2B/allOf/8/if","keyword":"if","params":{"failingKeyword":"then"},"message":"must match \"then\" schema"}]

To Reproduce

  1. SQL-Adapter (v2.2.0) öffnen
  2. Warnmeldung kommt

Expected behavior

keine Warnmeldung

Screenshots & Logfiles

image

Adapter version

v6.13.15

js-controller version

5.0.17

Node version

v18.17.1

Operating system

linux (Raspberry Pi 4)

Additional context

No response

mcm1957 commented 6 months ago

This is a (real) bug to be fixed at the SQL Adapter. Issue should be moved to ioBroker/ioBroker.sql

see https://github.com/ioBroker/ioBroker.sql/blob/53df1868c52ce217511c30e46dee52848d9409b2/admin/jsonConfig.json#L138

'type': 'sento' 

should be

type: 'sendTo'