sqlite file location format

Posted on
Thu Oct 12, 2017 4:20 pm
siclark offline
Posts: 438
Joined: Jun 13, 2017
Location: UK

sqlite file location format

I have got my sql logger config in a mess and it managed to blank out the sqlite file location, and now I get these errors

SQL Logger Error plugin runConcurrentThread function returned or failed (will attempt again in 10 seconds)
SQL Logger Error Error in plugin execution UiClosed1:

Traceback (most recent call last):
File "plugin.py", line 645, in closedPrefsConfigUi
File "plugin.py", line 473, in _connectToSqlDb
ValueError: invalid literal for int() with base 10: ''

Is this related? I have even removed the sql lite file and as its not creating a new version, I'm sure the various combinations I am using in there are wrong.

What should it be?

Posted on
Fri Oct 13, 2017 8:49 am
siclark offline
Posts: 438
Joined: Jun 13, 2017
Location: UK

Re: sqlite file location format

I get the same thing with trying to use new postgres setup or SQLite with or without an existing file.
Is there an issue in my indigo setup rather than the db file?
How do I force indigo to create a new SQLite file?

Posted on
Fri Oct 13, 2017 9:06 am
kw123 offline
User avatar
Posts: 5822
Joined: May 12, 2013
Location: Dallas, TX

sqlite file location format

Shutdown indigo server
Delete SQLite file
Restart indigo server
Should reset the SQLite environment


Sent from my iPhone using Tapatalk

Posted on
Fri Oct 13, 2017 11:54 am
siclark offline
Posts: 438
Joined: Jun 13, 2017
Location: UK

Re: sqlite file location format

Cheers but Still get same error message. This happens whether or not I have an SQLite file or whether it's SQLite or postgres.

Posted on
Fri Oct 13, 2017 3:56 pm
matt (support) offline
Site Admin
User avatar
Posts: 18606
Joined: Jan 27, 2003
Location: Texas

Re: sqlite file location format


Image

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 1 guest