Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Could not add database (Any Database Type/Engine Fails) #3530

Open
lavanyadeepak opened this issue Jun 10, 2019 · 5 comments

Comments

@lavanyadeepak
Copy link

commented Jun 10, 2019

I have tried selecting each of the database type in the dropdown but getting the standard message

Could not add database <lavanyadeepak.db>

Is there some log generated on what exactly is failing when trying to open the file?

image

@pawelsalawa

This comment has been minimized.

Copy link
Owner

commented Jun 10, 2019

Do you know what database engine was this file created with in the first place?

@lavanyadeepak

This comment has been minimized.

Copy link
Author

commented Jun 10, 2019

@pawelsalawa

This comment has been minimized.

Copy link
Owner

commented Jun 10, 2019

SQLite 2 & 3 are not encrypted, thus you could see a literal "SQLite 3" or "SQLite 2" in file header when you open it with notepad. That being said, if it was either of these two, SQLiteStudio would open them without an issue.

If it's one of encrypted SQLite databases, you need to know correct password. Unfortunately there is no way to know if the password is incorrect, or if the file is not SQLite database at all. You either know it's SQLite file, you know which algorithm was used (SQLCipher, WxSQLite3, System.Data.SQLite) and what was the password, or you don't know them and you won't be able to open it. Sorry.

There is a way to show error message of connection test (answering your question from original post), but I don't think it will help you much. Anyway, to see the message you need to start SQLiteStudio in debug mode (from command line: SQLiteStudio.exe -d). Then in the application hit F12 key, it will open debug console. Then you can try opening your database. After error, you can look into debug console to see error message.

@lavanyadeepak

This comment has been minimized.

Copy link
Author

commented Jun 14, 2019

Here is my debug information:

[18:11:42.567] DEBUG: Using configuration directory: "C:/Users/LavanyaDeepak/AppData/Roaming/sqlitestudio"
[18:11:43.158] DEBUG: Following plugins found: ("SqlExport", "SqlFormatterSimplePlugin", "PdfExport", "MultiEditorImagePlugin", "ConfigMigration", "XmlExport", "RegExpImport", "DbSqliteCipher", "HtmlExport", "DbSqlite2", "ScriptingTcl", "JsonExport", "DbSqliteSystemData", "DbSqliteWx", "CsvImport", "DbAndroid", "SqlEnterpriseFormatter", "CsvExport", "Printing")
[18:11:43.159] DEBUG: "SqlExport" loaded: "C:/Program Files/SQLiteStudio/plugins/SqlExport.dll"
[18:11:43.160] DEBUG: "PdfExport" loaded: "C:/Program Files/SQLiteStudio/plugins/PdfExport.dll"
[18:11:43.161] DEBUG: "MultiEditorImagePlugin" loaded: "C:/Program Files/SQLiteStudio/plugins/MultiEditorImage.dll"
[18:11:43.163] DEBUG: "ConfigMigration" loaded: "C:/Program Files/SQLiteStudio/plugins/ConfigMigration.dll"
[18:11:43.164] DEBUG: "XmlExport" loaded: "C:/Program Files/SQLiteStudio/plugins/XmlExport.dll"
[18:11:43.165] DEBUG: "RegExpImport" loaded: "C:/Program Files/SQLiteStudio/plugins/RegExpImport.dll"
[18:11:43.166] DEBUG: "DbSqliteCipher" loaded: "C:/Program Files/SQLiteStudio/plugins/DbSqliteCipher.dll"
[18:11:43.167] DEBUG: "HtmlExport" loaded: "C:/Program Files/SQLiteStudio/plugins/HtmlExport.dll"
[18:11:43.169] DEBUG: "DbSqlite2" loaded: "C:/Program Files/SQLiteStudio/plugins/DbSqlite2.dll"
[18:11:43.173] DEBUG: "ScriptingTcl" loaded: "C:/Program Files/SQLiteStudio/plugins/ScriptingTcl.dll"
[18:11:43.174] DEBUG: "JsonExport" loaded: "C:/Program Files/SQLiteStudio/plugins/JsonExport.dll"
[18:11:43.175] DEBUG: "DbSqliteSystemData" loaded: "C:/Program Files/SQLiteStudio/plugins/DbSqliteSystemData.dll"
[18:11:43.176] DEBUG: "DbSqliteWx" loaded: "C:/Program Files/SQLiteStudio/plugins/DbSqliteWx.dll"
[18:11:43.177] DEBUG: "CsvImport" loaded: "C:/Program Files/SQLiteStudio/plugins/CsvImport.dll"
[18:11:43.186] DEBUG: "SqlEnterpriseFormatter" loaded: "C:/Program Files/SQLiteStudio/plugins/SqlEnterpriseFormatter.dll"
[18:11:43.187] DEBUG: "CsvExport" loaded: "C:/Program Files/SQLiteStudio/plugins/CsvExport.dll"
[18:11:43.192] DEBUG: "Printing" loaded: "C:/Program Files/SQLiteStudio/plugins/Printing.dll"
[18:11:43.194] DEBUG: Loading form file: ":/forms/CsvExport.ui"
[18:11:43.194] DEBUG: Loading form file: ":/forms/CsvImportOptions.ui"
[18:11:43.194] DEBUG: Loading form file: ":/forms/htmlexport.ui"
[18:11:43.194] DEBUG: Loading form file: ":/forms/jsonexport.ui"
[18:11:43.194] DEBUG: Loading form file: ":/forms/pdfexport.ui"
[18:11:43.194] DEBUG: Loading form file: ":/forms/plugins/populateconstant.ui"
[18:11:43.194] DEBUG: Loading form file: ":/forms/plugins/populatedictionary.ui"
[18:11:43.194] DEBUG: Loading form file: ":/forms/plugins/populaterandom.ui"
[18:11:43.194] DEBUG: Loading form file: ":/forms/plugins/populaterandomtext.ui"
[18:11:43.194] DEBUG: Loading form file: ":/forms/plugins/populatescript.ui"
[18:11:43.195] DEBUG: Loading form file: ":/forms/plugins/populatesequence.ui"
[18:11:43.195] DEBUG: Loading form file: ":/forms/regexpimport.ui"
[18:11:43.195] DEBUG: Loading form file: ":/forms/sqlenterpriseformatter.ui"
[18:11:43.195] DEBUG: Loading form file: ":/forms/SqlExportCommon.ui"
[18:11:43.195] DEBUG: Loading form file: ":/forms/SqlExportQuery.ui"
[18:11:43.195] DEBUG: Loading form file: ":/forms/XmlExport.ui"
[18:11:43.312] DEBUG: Error from notify manager: "Could not add database D:\Projects\LDTestBench.db: ; ; ; ; "
[18:11:43.315] DEBUG: Error from notify manager: "Could not add database D:\Projects\LDTestBench.db to list."
[18:11:46.896] DEBUG: Update QProcess finished with code: 1

@pawelsalawa

This comment has been minimized.

Copy link
Owner

commented Jun 14, 2019

It means even SQLite library does not provide concrete error message. Sorry, I won't be able to tell you anything more.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.