Open rohanatlarge opened 2 months ago
Interesting. How about if you do some changes in Options dialog. Are they persisted?
Yes.
Okay. Can you also try to rename your configuration file to some backup name and try running the app with fresh config? I wonder if in that case the issue will disappear. Config is stored at: https://github.com/pawelsalawa/sqlitestudio/wiki/Configuration_directory_location
I completely deleted the folder; uninstalled and re-installed and still the same. In that the previous settings were no longer there. But they would persist again, as I set them up. Just the new window sizing would not persist still.
Did notice that salsoft/sqlitestudio was not there in %APPDATA% It was only there in %LOCALAPPDATA% C:\Users\my_user\AppData\Roaming\SalSoft\sqlitestudio\settings3 -- not here C:\Users\my_user\AppData\Local\SalSoft\sqlitestudio\settings3 -- was here
Tried to add it to other location. Didn't make a difference. App is still touching the one in local.
Okay. Wherever it is - please change it's name, so you start with fresh/empty config. Then try to open some windows, close the app, re-run and tell us if the problem still appears then.
Afterwards you can restore your original file to original name, to restore your settings and remembered databases.
still happens
Okay. One more thing to check. Please run SQLiteStudio from command line like this:
cd installation-directory-of-sqlitestudio
./SQLiteStudio.exe -d --debug-file C:\path\to\file.txt
Note, that the file should not exist and you must have rights to create that file and the parent directory of that file should already exist.
After application starts, open some windows in it and close the app.
Then please open the created log file, scroll down to the end and see if there are any error indicators that could mean interruption of session saving.
Doesn't seem like any errors at any time.
[09:19:37.212] DEBUG: Using configuration directory: C:\Users\hiddenusername\AppData\Local\SalSoft\SQLiteStudio [09:19:37.214] DEBUG: SQLite extension: "C:/Program Files/SQLiteStudio/ext/compress.dll" [09:19:37.214] DEBUG: SQLite extension: "C:/Program Files/SQLiteStudio/ext/csv.dll" [09:19:37.214] DEBUG: SQLite extension: "C:/Program Files/SQLiteStudio/ext/decimal.dll" [09:19:37.214] DEBUG: SQLite extension: "C:/Program Files/SQLiteStudio/ext/eval.dll" [09:19:37.214] DEBUG: SQLite extension: "C:/Program Files/SQLiteStudio/ext/icu.dll" [09:19:37.214] DEBUG: SQLite extension: "C:/Program Files/SQLiteStudio/ext/ieee754.dll" [09:19:37.214] DEBUG: SQLite extension: "C:/Program Files/SQLiteStudio/ext/percentile.dll" [09:19:37.214] DEBUG: SQLite extension: "C:/Program Files/SQLiteStudio/ext/rot13.dll" [09:19:37.214] DEBUG: SQLite extension: "C:/Program Files/SQLiteStudio/ext/series.dll" [09:19:37.214] DEBUG: SQLite extension: "C:/Program Files/SQLiteStudio/ext/sqlar.dll" [09:19:37.214] DEBUG: SQLite extension: "C:/Program Files/SQLiteStudio/ext/uint.dll" [09:19:37.214] DEBUG: SQLite extension: "C:/Program Files/SQLiteStudio/ext/uuid.dll" [09:19:37.214] DEBUG: SQLite extension: "C:/Program Files/SQLiteStudio/ext/zorder.dll" [09:19:37.691] DEBUG: Following plugins found: ("ScriptingPython", "DbSqliteWx", "RegExpImport", "XmlExport", "DbAndroid", "CsvExport", "PythonSyntaxHighlighterPlugin", "DbSqliteCipher", "HtmlExport", "PdfExport", "MultiEditorImagePlugin", "Printing", "CsvImport", "ConfigMigration", "SqlExport", "SqlFormatterSimplePlugin", "JsonExport", "SqlEnterpriseFormatter", "ScriptingTcl") [09:19:37.691] DEBUG: DbSqliteWx loaded: C:\Program Files\SQLiteStudio\plugins\DbSqliteWx.dll [09:19:37.692] DEBUG: RegExpImport loaded: C:\Program Files\SQLiteStudio\plugins\RegExpImport.dll [09:19:37.692] DEBUG: XmlExport loaded: C:\Program Files\SQLiteStudio\plugins\XmlExport.dll [09:19:37.693] DEBUG: CsvExport loaded: C:\Program Files\SQLiteStudio\plugins\CsvExport.dll [09:19:37.694] DEBUG: PythonSyntaxHighlighterPlugin loaded: C:\Program Files\SQLiteStudio\plugins\PythonSyntaxHighlighter.dll [09:19:37.694] DEBUG: DbSqliteCipher loaded: C:\Program Files\SQLiteStudio\plugins\DbSqliteCipher.dll [09:19:37.695] DEBUG: HtmlExport loaded: C:\Program Files\SQLiteStudio\plugins\HtmlExport.dll [09:19:37.696] DEBUG: PdfExport loaded: C:\Program Files\SQLiteStudio\plugins\PdfExport.dll [09:19:37.697] DEBUG: MultiEditorImagePlugin loaded: C:\Program Files\SQLiteStudio\plugins\MultiEditorImage.dll [09:19:37.699] DEBUG: Printing loaded: C:\Program Files\SQLiteStudio\plugins\Printing.dll [09:19:37.700] DEBUG: CsvImport loaded: C:\Program Files\SQLiteStudio\plugins\CsvImport.dll [09:19:37.701] DEBUG: ConfigMigration loaded: C:\Program Files\SQLiteStudio\plugins\ConfigMigration.dll [09:19:37.702] DEBUG: SqlExport loaded: C:\Program Files\SQLiteStudio\plugins\SqlExport.dll [09:19:37.703] DEBUG: JsonExport loaded: C:\Program Files\SQLiteStudio\plugins\JsonExport.dll [09:19:37.707] DEBUG: SqlEnterpriseFormatter loaded: C:\Program Files\SQLiteStudio\plugins\SqlEnterpriseFormatter.dll [09:19:37.710] DEBUG: ScriptingTcl loaded: C:\Program Files\SQLiteStudio\plugins\ScriptingTcl.dll [09:19:37.945] DEBUG: Loading form file: :\forms\CsvExport.ui [09:19:37.946] DEBUG: Loading form file: :\forms\CsvImportOptions.ui [09:19:37.946] DEBUG: Loading form file: :\forms\htmlexport.ui [09:19:37.946] DEBUG: Loading form file: :\forms\jsonexport.ui [09:19:37.946] DEBUG: Loading form file: :\forms\pdfexport.ui [09:19:37.946] DEBUG: Loading form file: :\forms\plugins\populateconstant.ui [09:19:37.946] DEBUG: Loading form file: :\forms\plugins\populatedictionary.ui [09:19:37.946] DEBUG: Loading form file: :\forms\plugins\populaterandom.ui [09:19:37.946] DEBUG: Loading form file: :\forms\plugins\populaterandomtext.ui [09:19:37.946] DEBUG: Loading form file: :\forms\plugins\populatescript.ui [09:19:37.946] DEBUG: Loading form file: :\forms\plugins\populatesequence.ui [09:19:37.946] DEBUG: Loading form file: :\forms\regexpimport.ui [09:19:37.946] DEBUG: Loading form file: :\forms\sqlenterpriseformatter.ui [09:19:37.946] DEBUG: Loading form file: :\forms\SqlExportCommon.ui [09:19:37.946] DEBUG: Loading form file: :\forms\SqlExportQuery.ui [09:19:37.946] DEBUG: Loading form file: :\forms\XmlExport.ui
So, the Loading form file
messages are the last in file? Did you open log file AFTER you closed SQLiteStudio?
yes.
Note that I opened a file, wrote a simple select query, ran the query and closed the app, while the query was still there. The debug log did not show any of the writing out. If I re-open the app, it reloads the window with the sql-query. So it wrote something out, but that writing did not get logged.
It seems that the application crashes quietly sometime during shutting down.
I've been using SQLiteStudion off and on for long time. I recall this issue from before; it had been reported as an issue; and it had been fixed. After the fix, it used to work for me. I've been through couple of new computer purchases over the years; and have gone from Win7 to Win10 to Win11 over that time frame; and have upgraded SQLiteStudio versions as well. I cannot say exactly when this issue reappeared. It's only recently that I reached out, thinking that maybe there's something simple that I am missing.
I see.
Maybe it's worth trying with the weekly dev build? Have a look at the most recent: https://github.com/pawelsalawa/sqlitestudio/actions/runs/10241480508
Go for portable packages marked with red, so you don't have to install/uninstall these builds. They differ by Qt version that they are build with. It doesn't really matter to you, but you may try both.
Tied up for several hours now. Will be back in a bit and will give it a shot.
Details
On opening a new window (new sql editor, new data window) -- window size is very small. There were many old bugs reported on it and a fix was issued. Somewhere the window sizes are being stored, because I uninstalled and re-installed and all my old settings were still there. So maybe the window sizes were stored and are not getting changed. Is there a way for me to fix the start size of the window. I've got to enlarge the window every time.
Steps to reproduce
Open a new sql editor window using button
Operating system
Windows 11
SQLiteStudio version
Latest 3.4.4