There are no tables listed in the index creation form except sqlite_master and sqlite_temp_master

[mslavkovski]

Details

Unable to create index with the latest vesion. There are no tables listed in the index creation form except sqlite_master and sqlite_temp_master.

Steps to reproduce

In tab Indexes, add new index.

Operating system

Windows 10

SQLiteStudio version

3.2.1

[mslavkovski]

It seems like it wants to establish a connection to a different database since the dialog needs a while to open.

[pawelsalawa]

How many databases do you have registered in SQLiteStudio?
How do you open this index dialog? Right-click on the database list? Or button from toolbar?
If it's button on toolbar, then which database on the list is selected when you click the button?

[mslavkovski]

I have 3 connections registered. 2 are closed, one is open (Android SQLite). The first one is a local file (SQLite3), the second one is also of type "Android SQLite" but the device does not exist and the connection couldn't be established but I keep it in the list since I often use that device for development.

I'm opening the index dialog by either pressing the Insert key or clicking on the toolbar button. The behaviour is the same when I open the dialog from the context menu from the connections treeview.

There is no database connection displayed in the table designer, only in the script editor.

[pawelsalawa]

What about if you open SQL Editor and execute query: SELECT * FROM sqlite_master;? Does it work? Does it return anything?

[mslavkovski]

It works and with the correct connection, I'm using it all the time manipulating the database content. The query that you suggested is also returning records related to the current database.

[mslavkovski]

Here is a screenshot:

[pawelsalawa]

Please run SQLiteStudio from command line like this: SQLiteStudio.exe -d.
Then reproduce the problem with Index Dialog.
Then hit F12 key and see if there are any disturbing messages. You can also just put the output here if you don't mind and I can have a look.

[mslavkovski]

Here is the output:

[12:37:44.454] DEBUG:    Using configuration directory: "C:/Users/MS/AppData/Roaming/sqlitestudio"
[12:37:45.242] DEBUG:    Following plugins found: ("DbSqlite2", "PdfExport", "HtmlExport", "Printing", "SqlEnterpriseFormatter", "ConfigMigration", "SqlExport", "SqlFormatterSimplePlugin", "RegExpImport", "DbSqliteSystemData", "MultiEditorImagePlugin", "JsonExport", "ScriptingTcl", "XmlExport", "DbSqliteCipher", "CsvExport", "DbSqliteWx", "CsvImport", "DbAndroid")
[12:37:45.244] DEBUG:    "DbSqlite2" loaded: "E:/Install/SQLiteStudio/plugins/DbSqlite2.dll"
[12:37:45.245] DEBUG:    "PdfExport" loaded: "E:/Install/SQLiteStudio/plugins/PdfExport.dll"
[12:37:45.246] DEBUG:    "HtmlExport" loaded: "E:/Install/SQLiteStudio/plugins/HtmlExport.dll"
[12:37:45.251] DEBUG:    "Printing" loaded: "E:/Install/SQLiteStudio/plugins/Printing.dll"
[12:37:45.267] DEBUG:    "SqlEnterpriseFormatter" loaded: "E:/Install/SQLiteStudio/plugins/SqlEnterpriseFormatter.dll"
[12:37:45.269] DEBUG:    "ConfigMigration" loaded: "E:/Install/SQLiteStudio/plugins/ConfigMigration.dll"
[12:37:45.271] DEBUG:    "SqlExport" loaded: "E:/Install/SQLiteStudio/plugins/SqlExport.dll"
[12:37:45.272] DEBUG:    "RegExpImport" loaded: "E:/Install/SQLiteStudio/plugins/RegExpImport.dll"
[12:37:45.273] DEBUG:    "DbSqliteSystemData" loaded: "E:/Install/SQLiteStudio/plugins/DbSqliteSystemData.dll"
[12:37:45.275] DEBUG:    "MultiEditorImagePlugin" loaded: "E:/Install/SQLiteStudio/plugins/MultiEditorImage.dll"
[12:37:45.276] DEBUG:    "JsonExport" loaded: "E:/Install/SQLiteStudio/plugins/JsonExport.dll"
[12:37:45.281] DEBUG:    "ScriptingTcl" loaded: "E:/Install/SQLiteStudio/plugins/ScriptingTcl.dll"
[12:37:45.283] DEBUG:    "XmlExport" loaded: "E:/Install/SQLiteStudio/plugins/XmlExport.dll"
[12:37:45.307] DEBUG:    "DbSqliteCipher" loaded: "E:/Install/SQLiteStudio/plugins/DbSqliteCipher.dll"
[12:37:45.309] DEBUG:    "CsvExport" loaded: "E:/Install/SQLiteStudio/plugins/CsvExport.dll"
[12:37:45.311] DEBUG:    "DbSqliteWx" loaded: "E:/Install/SQLiteStudio/plugins/DbSqliteWx.dll"
[12:37:45.313] DEBUG:    "CsvImport" loaded: "E:/Install/SQLiteStudio/plugins/CsvImport.dll"
[12:37:45.371] DEBUG:    Using ADB binary: "adb.exe"
[12:37:46.406] DEBUG:    "DbAndroid" loaded: "E:/Install/SQLiteStudio/plugins/DbAndroid.dll"
[12:37:46.446] DEBUG:    Loading form file: ":/forms/CsvExport.ui"
[12:37:46.446] DEBUG:    Loading form file: ":/forms/CsvImportOptions.ui"
[12:37:46.446] DEBUG:    Loading form file: ":/forms/htmlexport.ui"
[12:37:46.446] DEBUG:    Loading form file: ":/forms/jsonexport.ui"
[12:37:46.446] DEBUG:    Loading form file: ":/forms/pdfexport.ui"
[12:37:46.447] DEBUG:    Loading form file: ":/forms/plugins/populateconstant.ui"
[12:37:46.447] DEBUG:    Loading form file: ":/forms/plugins/populatedictionary.ui"
[12:37:46.447] DEBUG:    Loading form file: ":/forms/plugins/populaterandom.ui"
[12:37:46.447] DEBUG:    Loading form file: ":/forms/plugins/populaterandomtext.ui"
[12:37:46.447] DEBUG:    Loading form file: ":/forms/plugins/populatescript.ui"
[12:37:46.447] DEBUG:    Loading form file: ":/forms/plugins/populatesequence.ui"
[12:37:46.447] DEBUG:    Loading form file: ":/forms/regexpimport.ui"
[12:37:46.448] DEBUG:    Loading form file: ":/forms/sqlenterpriseformatter.ui"
[12:37:46.448] DEBUG:    Loading form file: ":/forms/SqlExportCommon.ui"
[12:37:46.448] DEBUG:    Loading form file: ":/forms/SqlExportQuery.ui"
[12:37:46.448] DEBUG:    Loading form file: ":/forms/XmlExport.ui"
[12:37:49.552] DEBUG:    Update QProcess finished with code: 1
[12:38:13.312] CRITICAL: Error reading response from Android socket: ""

Hope it helps.

[pawelsalawa]

Okay, we will need to do more extensive debug. Please run it this time with SQLiteStudio.exe -d --debug-sql.

This will produce A LOT of debug messages, containing all SQL queries executed on the database. There's no need to post them all here. I'd like to see (if you don't mind) the query that is executed prior to this CRITICAL error.

[mslavkovski]

Here are the last few entries including the one before the error:

[12:42:55.009] DEBUG:    Update QProcess finished with code: 1
[12:42:59.514] DEBUG:    "SQL dev_marjan_itnnovate_eu.db0> SELECT name FROM main.sqlite_master WHERE type = ?;" (flags: "" )
[12:42:59.514] DEBUG:        SQL arg> 0 = QVariant(QString, "table")
[12:43:04.536] CRITICAL: Error reading response from Android socket: ""
[12:43:04.537] DEBUG:    "SQL dev_marjan_itnnovate_eu.db0> PRAGMA collation_list" (flags: "" )
[12:42:59.514] DEBUG:    "SQL dev_marjan_itnnovate_eu.db0> SELECT name, type FROM main.sqlite_master;" (flags: "" )
[12:43:04.601] DEBUG:    "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[12:43:04.601] DEBUG:        SQL arg> 0 = QVariant(QString, "Colors")
[12:43:04.601] DEBUG:        SQL arg> 1 = QVariant(QString, "SqlEditorLineNumAreaBg")
[12:43:08.441] DEBUG:    "SQL dev_marjan_itnnovate_eu.db0> SELECT name FROM main.sqlite_master WHERE type = ?;" (flags: "" )
[12:43:08.441] DEBUG:        SQL arg> 0 = QVariant(QString, "index")

[mslavkovski]

Just a quick update... I have removed all closed connections and left only the current one.
It works!

[pawelsalawa]

I don't know what was the cause of it then :/ I could not reproduce it locally.

[mslavkovski]

I will try to reproduce it again and will let you know if that's OK with you.

[mslavkovski]

@pawelsalawa I managed to reproduce it again:

1. Keep the current connection open.
2. Add another connection. (It is added to the bottom of the tree).
3. Close the new connection and move it to the top keeping the old one open.
4. Try to add an index to the connected database (IT WORKS).
5. Restart the SQLiteStudio
6. Try to add index (IT DOES NOT WORK). :/

[pawelsalawa]

Works for me :(

Is there a way for you to record what you're doing?
I'm pretty sure that there is some important move that you're doing, which I'm missing and you are not even aware that it matters.

[mslavkovski]

@pawelsalawa I have recorded a video (with not exact steps that I've described earlier) but I'm showing a working and not working situation. How can I send you the video? It's 30MB

[pawelsalawa]

If you zip it, are you able to attach it here to the post?

[mslavkovski]

Can I send you a direct a direct google drive link? But I don't want everyone to see my desktop so I sent you a linked in request and I can send you a message there with the link.

[pawelsalawa]

Issue created #3967