SQLITE error when adding ANY device

Try using the v6.x app or v7.4.1 or lower.
This while the “note” feature for devices was introduced in v7.4.2.

And:
Start Homey in recovery mode, and perform the so called “Full software download”.
This will install the firmware from scratch.
All things you added will be unaffected.
But keeping a backup at hand is always a good plan.

Howto