Chapter 8. Questions and Answers
Prev Next

Chapter 8. Questions and Answers

Table of Contents

8.1. How I can report a bug?
8.2. My editor (data grid or output log etc.) GUI disappeared. Is it broken?
8.3. Known Issues
8.3.1. I'm getting: Query Error: SQL logic error or missing database.
8.3.2. I cannot update a value in the data grid.
8.3.3. Editing or deleting rows changes or deletes other rows.
8.3.4. I'm getting: Cannot recreate original trigger.
8.3.5. Sqliteman's window suddenly disappears.
8.1.

How can I report a bug?
For this version you need to visit the github issues page, and click on New issue. Please provide the output from Help->About... and as much information as you can about how to provoke the bug. If you built it yourself from the sources, please also provide the git commit identifier of the version of the sources that you downloaded.
8.2. My editor (data grid or output log etc.) GUI disappeared. Is it broken?
Probably not....
First try looking under the Database menu: some User Interface elements can be switched on or off. If you accidentally typed a shortcut key that switches a particular User Interface element, you switched it off. Type the shortcut key again or use the menu to make it reappear. Error Log windows may automatically disappear if there is no message to put in them, but will reappear when needed. If some window that should definitely be visible isn't, you're probably using MS Windows (or some strange Qt GUI theme). All GUI parts are connected into so-called sliders (mouse-stretchable borders). Unfortunately Windows native (and some more themes) look does not highlight these borders. Try to catch the changed mouse cursor near the window borders or clear your preferences.
8.3. Known Issues
8.3.1. I'm getting: Query Error: SQL logic error or missing database.
You can get this error on some INSERT statements in the database with triggers. It's a bug in some versions of the Qt library toolkit. It should be fixed in the Qt 4.2.3 and later.
8.3.2. I cannot update a value in the data grid.
You cannot edit the data in a view or in the result of running a query or in a read-only database. If you were trying to edit in the result of running a query, you probably needed sqliteman's Find function instead of the query. If editing fails in a table in a writeable database, this may be a problem with older versions of the Qt library which send an empty string ('') to the database for fields that have a value of NULL and sqlite, doesn't seem to like this. This has been fixed some time before Qt 4.8.6.
8.3.3. Editing or deleting rows changes or deletes other rows.
This problem occurs if you put two or more rows with the exact same field contents into the database. The Qt library gets confused by this. The bug has been reported , but the Qt maintainers won't fix it because they think that multiple rows with the same content are invalid in a database. This author's view is that if they provide a library interface to sqlite, they should support what sqlite, does, not what they think that it ought to do.
8.3.4. I'm getting: Cannot recreate original index/trigger.
This problem occurs when altering a table if a trigger references a column which has been renamed or deleted. It is a known bug in sqliteman but it isn't easy to fix: it may get fixed some time.
8.3.5. Sqliteman's window suddenly disappears.
This can be caused by attempting to load a table which is too large for your machine's memory. The problem is deep inside the Qt sqlite3 driver, and cannot be fixed inside sqliteman. If you don't need the whole table, you can use the Preferences dialog to set the "Rows to read from tables" preference to a number rather than "All".
Prev Questions.html Next
Export Data Contents Chapter 9. Credits and Licence