Chapter 8. Questions and Answers

Table of Contents

Known Issues
8.1. How I can report a bug?
8.2. My editor (data grid or output log etc.) GUI disappeared. Is it broken?

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.

Known Issues

1. I'm getting: Query Error: SQL logic error or missing database
2. I cannot update a value in the data grid
3. Editing or deleting rows changes or deletes other rows.
4. I'm getting: Cannot recreate original index/trigger
5. I'm getting: Error: No Fields to update

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.