Table of Contents
8.1. | How I can report a bug? |
For this version you need to visit the github issues page, and click on New issue. | |
8.2. | My editor (data grid or output log etc.) GUI disappeared. Is it broken? |
Well... no. 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 be visible isn't, you're probably using MS Windows (or some strange Qt4 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. |
1. | I'm getting: Query Error: SQL logic error or missing database |
You can get this error on some INSERT statement 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. | |
2. | I cannot update a value in the data grid |
You cannot edit the data in a view or in a read-only database. 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. | |
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. | |
4. | I'm getting: Cannot recreate original index/trigger |
This problem occurs when altering a table if an index or 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. | |
5. | I'm getting: Error: No Fields to update |
This problem occurs if all fields have defaults which are CURRENT_TIMESTAMP, CURRENT_DATE, CURRENT_TIME, or expressions. The Qt library can't insert a record with this structure. For the workaround see here. This has been reported as a bug, but Qt say it isn't. |