# SQLITE error when adding ANY device **URL:** \ **Category:** Questions & Help\ **Tags:** advancedflow\ **Created:** [January 23, 2024, 7:26pm UTC](https://community.homey.app/t/sqlite-error-when-adding-any-device/102103 "2024-01-23T19:26:53Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Andreas\_Elbing](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/andreas_elbing/32/98971_2.png) [@Andreas\_Elbing](https://community.homey.app/u/Andreas_Elbing)\ **Post date:** [January 23, 2024, 7:26pm UTC](https://community.homey.app/t/sqlite-error-when-adding-any-device/102103/1 "2024-01-23T19:26:53Z")
I have bought a used Homey early 2018. It is factory reset and added to a newly created Homey account. An advanced flow license has been purchased and added. I got a “The access token was not found” during installing of the Homey but it was solved by hitting retry. It is now up and running on my wifi and accessible both locally and over internet. Installing apps is no problem, but when adding a devices I get the error message “SQLITE\_ERROR: table Device has no column named note” in a red info box in the web app and the device is never added. It doesn’t matter what device it is, I have tried Tesla, Netatmo and others. Even Homeys virtual button device gives the same error message (after activating the experimental feature of virtual devices). I find it strange that I find no references to users with this problem and I do no know what to try next. Any advice? Cheers, Andreas ![Screenshot 2024-01-23 at 20.05.02](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/7/3/73806b12248fad9791e75126648730311f8013a3.png) ---
**Author:** ![Peter\_Kawa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_kawa/32/173848_2.png) [@Peter\_Kawa](https://community.homey.app/u/Peter_Kawa)\ **Post date:** [January 23, 2024, 9:12pm UTC](https://community.homey.app/t/sqlite-error-when-adding-any-device/102103/2 "2024-01-23T21:12:52Z")
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. > ![Screenshot_20240123-222319_Chrome](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/6/9/69db646866fa23415e7b5b6d3957b201fd3d04c9.jpeg) > [@Startup loop homey pro 2019](https://community.homey.app/t/startup-loop-homey-pro-2019/93854/3): > > for Android previous app versions still can be downloaded from [apkpure.com](https://apkpure.com/homey-%E2%80%94-a-better-smart-home/app.homey/versions) or [apkmirror.com](https://www.apkmirror.com/?post_type=app_release&searchtype=apk&s=homey) 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 > [@\[HowTo\]\[Pro\] Restarting Homey Pro to Recovery Mode - Adv. Options From Mobile](https://community.homey.app/t/howto-pro-restarting-homey-pro-to-recovery-mode-adv-options-from-mobile/61222): > > This option is only for Homey (Pro) models “Early 2016”, “Early 2018” and “Early 2019” so Only the White Ball’s Sometimes you need the extra options, things hidden for normal use, for example: Full Firmware download Complete Reset to sell your old Homey Or maybe you just want to change Homey’s WiFi. There are now a couple of extra options in the mobile Apps, so no need to use an FireFox or Chome Browser with flags enabled to press the Alt- key on your keyboard. Just use your App from no… ---
**Author:** ![Dijker](https://avatars.discourse-cdn.com/v4/letter/d/b9bd4f/32.png) [@Dijker](https://community.homey.app/u/Dijker)\ **Post date:** [January 23, 2024, 9:15pm UTC](https://community.homey.app/t/sqlite-error-when-adding-any-device/102103/3 "2024-01-23T21:15:27Z")
> [@Peter\_Kawa](#): > > All things you added will be unaffected. After that full download I would recommend to factory reset and start over with a new Database… ---
**Author:** ![Peter\_Kawa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_kawa/32/173848_2.png) [@Peter\_Kawa](https://community.homey.app/u/Peter_Kawa)\ **Post date:** [January 23, 2024, 9:22pm UTC](https://community.homey.app/t/sqlite-error-when-adding-any-device/102103/4 "2024-01-23T21:22:05Z")
I updated my comment. The database does not know about the ‘notes’ feature as it seems, introduced with mobile app v7.4.2 But agreed, a fresh factory resetted Homey is the best plan here. ---
**Author:** ![Andreas\_Elbing](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/andreas_elbing/32/98971_2.png) [@Andreas\_Elbing](https://community.homey.app/u/Andreas_Elbing)\ **Post date:** [January 23, 2024, 10:38pm UTC](https://community.homey.app/t/sqlite-error-when-adding-any-device/102103/5 "2024-01-23T22:38:42Z")
A full software download fixed my problem. Thanks a lot for your support. I will now have a good night’s sleep 😀 ---
**Author:** ![Peter\_Kawa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_kawa/32/173848_2.png) [@Peter\_Kawa](https://community.homey.app/u/Peter_Kawa)\ **Post date:** [January 23, 2024, 11:35pm UTC](https://community.homey.app/t/sqlite-error-when-adding-any-device/102103/6 "2024-01-23T23:35:51Z")
Nice to hear! Sleep tight