SQL error

[francois.tremblay5]

Hi,

After adding a new variable in Settings --> Hub Variable, I now got the following error message when trying to access that page.

Anybody had this problem before? Is it fixable without using a old database backup?

---

Platform version: 2.3.7.145

Hardware version: C-7

[csteele]

Make a new database backup and restore that.

The process of exporting then importing a DB, "empties the trash" that might have accumulated.

[francois.tremblay5]

Nice try.... but still same result.

Here what I did

1. Settings--> Backup and Restore

2. Then used "Create and download new local backup" to download a file called "Hubitat-01_2024-01-19~2.3.7.145~manual.lzf" on my computer

3. Then used "Upload local backup and restore to hub" with the file created at step 2,

4. Unit rebooted by itself after the restore operation completed. No error reported while importing the database backup.

[csteele]

In the Logs, that error should exist and reference the device/app that generated it.

Then, disable that app for as long as it takes to assure yourself that it's just the one Rule/App.

That column is usually hidden, but you can change that. Upper Right of the page is a gear icon, click it and get:

Turn that Show App disable box

[francois.tremblay5]

Unfortunately, the problem is still there.

Here what I have in Logs when I click on "Settings -->Hub Variables"

Then, I disabled everything

Screen capture 1 of 2

Screen capture 2 of 2

[francois.tremblay5]

And just to be clear, I still have the same error after I disabled all the Apps.

[csteele]

You aren't naming your variable according to that...
It's wanting to add to the DB using two parameters, one is a null, the other is 'gvDelaiFermentureStoreStore' -- it's objecting to that Null.

[francois.tremblay5]

So, the database is not recoverable?

[thebearmay]

Could try this:

Can’t access Hub Variables

Do you have any / many connectors? If not there is a way to recover from it. If you do have connectors, send me a PM about getting this fixed. Sorry @bertabcd1234, didn't see your post. With no connectors, it is possible to remove the Hub Variables settings-app, which should clear the error and make Hub Variables work again. Doing this is non-destructive of Hub Variables, but would create a problem with connectors (there is a fix for this, but subject would be PM). To remove the Hub Variab…

[francois.tremblay5]

Interesting idea.

Unfortunately, I have one connector.

So, I would like to avoid to swap a problem with another one.

[francois.tremblay5]

@thebearmay You make my day!

Here what I did

1. I deleted my connector using the "Devices" page
2. I go to the status page of "Hub Variable" using the trick

http://hubitat-01.lan/installedapp/status/3

where "hubitat-01.lan" is the local IP address of my hub and "3" the application code ID of "Hub Variable" application

3. I clicked on "Remove Application" or "Remove Hub Variable". I don't remember the exact name of the red button

4. Then, go in "Settings--> Hub Variable"

5. Bingo!

I need to re-do my connector but that was a trivial thing!

In fact, I believe I deserve you a beer! @thebearmay