Repository navigation
blog/version-3-13-0-released/ #34
Description
Activity
The UI looks great !!, anyway the IntelliSense of schema was gone. it recognize only sql statements .
The UI looks great !!, anyway the IntelliSense of schema was gone. it recognize only sql statements .
It happens for some databases. It has been reported at #3706 and we will take a look. Please, provide whatever information is useful over there.
Reacted by Justin Clift and IM.ITUI is very good
Reacted by Manuelen windows los caractes "Ñ" se muestr como BLOB
@eribertocz Would you be ok to screenshot that to show us an example? 😄
Good news , out of nowhere, suddenly the IntelliSense started working ...
I'm not sure but I made some changes in the schema just before I've noticed that the IntelliSense working . Good for me .Reacted by Justin CliftRun on Win10 ENG/ITA x64, Database Structure tree not loaded, table list in Browse Data not loaded. Only Execute SQL works, so actually the database connection is open. Happens with existing database or newly created
@davidemorando Oh, that's very unexpected. Would you be ok to provide a screenshot?
- Sure, please find attached *1.png no db schema displayed *2.png no table list in combo box *3.png query for schema working as expected *EN*.png opened a database previously generated with version 3.12.2 *IT*.png (re)opened a database generated from scratch with version 3.13.0
@davidemorando Heh Heh Heh. Slight problem. GitHub doesn't do email attachments, so there's just the list of image names but no actual images.
You'll probably need to use the GitHub web interface or something and paste them in there. Yeah, it's a bit of a pain, sorry. 🤷
Here you are. In case of any issue, https://we.tl/t-oUAAHkV4rd available up to September 18thReacted by Justin CliftThanks, that does help. And yep, that's really weird. My first suspicion is that the database is damaged or "not correct" in some way.
Under the Tools menu in our application there are some things to check for problems:
- Quick Integrity Check
- Integrity Check
- Foreign Key Check
The first two are probably the more important ones to try and see if they show anything unexpected. The last one ("Foreign Key Check") is probably not a bad thing to try anyway, just in case.
So, please try those and let us know how it goes? 😄
newDatabase.zip
All checks are positive and what's weird: every database previously opening with 3.12.2 has no schema visible on 3.13.0
You can find attached a simple database 1 Table 1 Field created with 3.13.0 from scratch: once you close and re-open, schema tree is displayed empty. Just tried with 32bit and 64bit version (zip download) with identical results. Please notice that every database is encoded UTF16leHi, I updated the version to 3.13; every time I open a project I get a message saying that the database is currently in use: I read the lines. Below is the question if I want to cancel "the other operation".
The fact is that there is no "other" operation and the database is not opened by any other process. What could be the condition that generates this problem? Thank you very much for your attention. Greetings
Note: I was unable to attach the image@enrico19640207 , in order to submit attachment do not post by sqlitedbbrowser.org blog but login to #34
If running in Windows OS, verify sqlitedbbrowser.exe is not marked as downloaded from web (right click file->properties), stop antivirus before opening the db and retry. You can use Microsoft Process Monitor, filter on Path= to check who opens handles on it.Thanks for the answer, but it seems too cumbersome and with an uncertain outcome. To me it clearly seems like a problem with the new version, considering that the old version never gave these problems
Update on the issue I posted previously: once opened a db, if you press [Refresh] button the tree with database schema is populated. So the difference with ver. 3.12.2 is: once the database is opened, the schema is not loaded. And I can provide additional information:
a) File -> Open, no warning
b) Drag/Drop a db , no warning
c) File -> open with -> SQLite Db Browser , or run exe + db pathname on commandline : you get "database table is locked"
so a) b) probably the try/catch is silent, c) is explicit.
in any case, the schema table seems available/accessible only when you can press the [Refresh] button
Version 3.13.0 released - DB Browser for SQLite
https://sqlitebrowser.org/blog/version-3-13-0-released/