Sqliteman Bugtracker - ISSUES

0000181: Search... in Export Data should default to the directory where a CSV was last saved

It would be nice if the "Search..." button in the Export Data dialog would remember the directory where Sqliteman last saved a CSV.

Ideally, the "last save directory" would be associated with each SQLite database that has been recently opened and the "last save directory" for each recently-opened SQLite database would persist across instances of Sqliteman. That is, if I open up `/home/myaccount/data.db` in Sqliteman, run a query, and export the query results to `/home/myaccount/data.csv`, then closing & re-opening Sqliteman on `/home/myaccount/data.db` would remember that the last save directory for `/home/myaccount/data.db` is `/home/myaccount`.

Even if a decision is made not to persist this information, it would be useful if Sqliteman would remember the last save directory of the current instance; i.e., if I export the results of a different query, the "Search..." file chooser would default to the last directory where I exported data.

0000178: Sqliteman displays three error dialogs when creating temporary tables or views

Steps to reproduce:

1. Open an SQLite database with Sqliteman.
2. In the SQL Editor, type: CREATE TEMPORARY TABLE tmp (a INTEGER);
3. Select the entire `CREATE TEMPORARY TABLE` statement and click the "Run SQL" button.

Sqliteman will show three error dialogs. The first says "Error while the list of table: no such table: temp.sqlite_master Unable to execute statement." The second says "Error while the list of view: no such table: temp.sqlite_master Unable to execute statement." The third says "Error while the list of the system catalogue: no such table: temp.sqlite_master Unable to execute statement."

Clicking "OK" on all three error dialogs, the GUI refreshes and displays a "temp" entry in the Object Browser. But, the number of tables and views in "temp" are both 0, even though the temporary table does exist.

0000180: Fix typo "Do you want do"

When there are unsaved changes in the SQL Editor, upon clicking the Close Window button, a dialog appears with the prompt "Document has been changed. Do you want do save its content?"

I suggest "Document has been changed. Do you want to save the contents?"

0000179: Provide a way to cancel the window closing operation

If I accidentally click the "Close Window" button, there is no way to cancel closing the window on the dialog asking whether I want to save the contents of the SQL Editor.

It would be nice if in addition to the "Yes" and "No" options there was a "Cancel" option.

0000115: NULL, CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP as a default

i cannot create table with those default values! evenif i do it with sql editor
i cannot add row with it! sqlitemanager insert text 'CURRENT_...' or 'NULL' into grid cell! it has to leave it alone to database or parse it to right datetime or null!

i have:
CREATE TABLE "test" (
"kol1" TEXT DEFAULT CURRENT_TIMESTAMP,
"kol2" TEXT,
"kol3" TEXT DEFAULT NULL
)

when i use create tabel dialog i get!!!:
CREATE TABLE "test" (
"kol1" TEXT DEFAULT ("CURRENT_TIMESTAMP"),
"kol2" TEXT,
"kol3" TEXT DEFAULT ("NULL")
)

even if i do create table with sqleditor to right statement, in the grid is insert wrong default values!

here is from sqlite.org from CREATE TABLE help:
http://www.sqlite.org/lang_createtable.html [^]

The DEFAULT constraint specifies a default value to use when doing an INSERT. The value may be NULL, a string constant or a number. Starting with version 3.1.0, the default value may also be one of the special case-independant keywords CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP. If the value is NULL, a string constant or number, it is literally inserted into the column whenever an INSERT statement that does not specify a value for the column is executed. If the value is CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP, then the current UTC date and/or time is inserted into the columns. For CURRENT_TIME, the format is HH:MM:SS. For CURRENT_DATE, YYYY-MM-DD. The format for CURRENT_TIMESTAMP is "YYYY-MM-DD HH:MM:SS".

0000177: No FTS3 support

I am trying to open an existing DB and I get the following message:
Error while getting the fileds of ft: no such module: FTS3 Unable to execute statement.

First of all there is a spelling mistake, it should be "fields" not "fileds"! lol

Secondly, it has something to do with FTS3 so I am assuming this needs to be included?

Thanks

0000176: Misleading error message when opening database locked by other application

When Firefox (3.6.20) is opened, if I try to open its cookies.sqlite database with sqliteman, I get an error message saying "Unable to open or create cookies.sqlite. It is probably not a database".

After closing Firefox, sqliteman succeeds in opening the same database.

Perhaps sqliteman could detect that the database is locked and report that as the cause.

This is under GNU/Linux (Fedora 14).

0000175: Too many records updated/deleted in Data Viewer

Sqliteman seems to be ignoring Sqlite's ROWID primary key when updating the database due to a field value being changed in the Full View tab of the Data Viewer. So if multiple rows have the same values for all other fields then all the rows are updated when one row is editted. Similarly "Remove Row" will delete all rows with similar values.

Test database created with this script:-

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE "A" (
"A1" INTEGER NOT NULL,
"A2" TEXT NOT NULL
);
INSERT INTO "A" VALUES(1,'One');
INSERT INTO "A" VALUES(2,'Two');
INSERT INTO "A" VALUES(1,'One');
INSERT INTO "A" VALUES(3,'Three');
COMMIT;

Using Data Viewer to edit/delete either first or third row will change both rows instead of just the specified row.

This behaviour can be bypassed by explicitly declaring the ROWID field and specifying Null for it in the insert statements. But the above definition is quite valid for an Sqlite database. The ROWID is also the safest and fastest way of specifying the record to be updated/deleted.

Suggest retrieve ROWID from database when filling Data Viewer from table and displaying it in column or in numbered button at start of each row. Updates/deletes can then be simpler/faster as they only need WHERE ROWID=? to specify which row.

Using Sqliteman Version 1.2.2 with Qt version 4.7.2 on Ubuntu 11.04 Linux with Sqlite from Ubuntu repository (libsqlite3-0 version 3.7.4-2ubuntu5).

0000174: Need help with linker error on windows

I get the following linking errors while trying to compile sqliteman on windows 7 x64. Can you please help me figure out the problems here. I have attached the complete output from cmake mingw32-make with the case.

Thanks,

Linking CXX executable sqliteman.exe
Info: resolving QsciLexerSQL::staticMetaObject by linking to __imp___ZN12
QsciLexerSQL16staticMetaObjectE (auto-import)
Info: resolving QsciScintilla::staticMetaObject by linking to __imp___ZN1
3QsciScintilla16staticMetaObjectE (auto-import)
c:/qt/2010.05/mingw/bin/../lib/gcc/mingw32/4.4.0/../../../../mingw32/bin/ld.exe:
warning: auto-importing has been activated without --enable-auto-import specifi
ed on the command line.
This should work unless it involves constant data structures referencing symbols
from auto-imported DLLs.
CMakeFiles\sqliteman.dir/objects.a(litemanwindow.cpp.obj):litemanwindow.cpp:(.te
xt+0x754c): undefined reference to `_imp___ZN13QSQLiteDriverC1EP7QObject'
CMakeFiles\sqliteman.dir/objects.a(qsql_sqlite.cpp.obj):qsql_sqlite.cpp:(.text+0
xf3): undefined reference to `_imp___ZTV13QSQLiteDriver'
CMakeFiles\sqliteman.dir/objects.a(qsql_sqlite.cpp.obj):qsql_sqlite.cpp:(.text+0
x12b): undefined reference to `_imp___ZTV13QSQLiteDriver'
CMakeFiles\sqliteman.dir/objects.a(qsql_sqlite.cpp.obj):qsql_sqlite.cpp:(.text+0
x15b): undefined reference to `_imp___ZTV13QSQLiteDriver'
CMakeFiles\sqliteman.dir/objects.a(qsql_sqlite.cpp.obj):qsql_sqlite.cpp:(.text+0
x19b): undefined reference to `_imp___ZTV13QSQLiteDriver'
CMakeFiles\sqliteman.dir/objects.a(qsql_sqlite.cpp.obj):qsql_sqlite.cpp:(.text+0
x1f3): undefined reference to `_imp___ZTV13QSQLiteDriver'
CMakeFiles\sqliteman.dir/objects.a(qsql_sqlite.cpp.obj):qsql_sqlite.cpp:(.text+0
x24b): more undefined references to `_imp___ZTV13QSQLiteDriver' follow
CMakeFiles\sqliteman.dir/objects.a(qsql_sqlite.cpp.obj):qsql_sqlite.cpp:(.text+0
x1bf4): undefined reference to `_imp___ZN13QSQLiteDriver16staticMetaObjectE'
CMakeFiles\sqliteman.dir/objects.a(qsql_sqlite.cpp.obj):qsql_sqlite.cpp:(.text+0
x1dfc): undefined reference to `_imp___ZN13QSQLiteDriver16staticMetaObjectE'
CMakeFiles\sqliteman.dir/objects.a(qsql_sqlite.cpp.obj):qsql_sqlite.cpp:(.text+0
x2004): undefined reference to `_imp___ZN13QSQLiteDriver16staticMetaObjectE'
CMakeFiles\sqliteman.dir/objects.a(qsql_sqlite.cpp.obj):qsql_sqlite.cpp:(.text+0
x2171): undefined reference to `_imp___ZN13QSQLiteDriver16staticMetaObjectE'
CMakeFiles\sqliteman.dir/objects.a(qsql_sqlite.cpp.obj):qsql_sqlite.cpp:(.text+0
x246c): undefined reference to `_imp___ZN13QSQLiteDriver16staticMetaObjectE'
CMakeFiles\sqliteman.dir/objects.a(moc_qsql_sqlite.cxx.obj):moc_qsql_sqlite.cxx:
(.text+0x15): more undefined references to `_imp___ZN13QSQLiteDriver16staticMeta
ObjectE' follow
collect2: ld returned 1 exit status
mingw32-make[2]: *** [sqliteman/sqliteman.exe] Error 1
mingw32-make[1]: *** [sqliteman/CMakeFiles/sqliteman.dir/all] Error 2
mingw32-make: *** [all] Error 2

C:\Code\sqliteman\Sqliteman>mingw32-make

0000153: AUTOINCREMENT lost after ALTER table

I have a table with " SRC_SK INTEGER PRIMARY KEY AUTOINCREMENT, " column as the primary key.

When I use the GUI to alter table to add more columns the "PRIMARY KEY AUTOINCREMENT" clause is lost from the altered table.

I can add it back in by altering the table again and adding the full clause in the "type" column.

This can be a real pain to debug as my application expects autogenerated keys and cannot handle a "null" key.

0000171: Suggest to have tabbed SQL editor

it would be nice to have tabs on the editor so I could work on multiple SQL scripts at a time without having to close one and reload another (e.g. tweaking DDL and DML at the same time)

0000173: Text search function in reverse does not work

WHen searching for text FORWARD in the SQL editor it works perfectly, but when searching bacwards (using the green arrow pointing left) it does not work at all.

0000172: SQL Editor drops some new lines in the script

Sometimes (every couple of days) I would save a script from SQL editor, then reopen and some of the lines have been merged into one as in this example:

"
DELETE FROM VALIDATIONREPORT WHERE headerid = new.odmheaderid AND declarationnumber = 'N/A' AND issuetype = 'Invalid data in ODM Export Record'
AND validationcheck = 'Load data into ' || new.odmname || ' Header';
END;DROP TRIGGER IF EXISTS ODMSHIPINSERT;
"
This script will not run until I manually re-edit the file and add the missing new lines as in this example:

"
DELETE FROM VALIDATIONREPORT WHERE headerid = new.odmheaderid AND declarationnumber = 'N/A' AND issuetype = 'Invalid data in ODM Export Record'
AND validationcheck = 'Load data into ' || new.odmname || ' Header';
END;
DROP TRIGGER IF EXISTS ODMSHIPINSERT;
"

0000170: Issue sqlite shell commands from sqliteman SQL editor

Unless I'm doing something wrong I cannot issue shell commands from editor"

.separator " "
.import RECORD.TXT FILELODER ;

Query Error: near ".": syntax error Unable to execute statement

.separator " "
.import RECORD.TXT FILELODER ;

Maybe editor could have an escape character that would interpret the commands as shell commands not SQL?

0000169: Truncate table from GUI fails

From GUI - Full View, "Remove row" works but "Truncate Table" seems not to do anything on my tables (regardless if "Commit" button is clicked.

0000168: Homepage wind32 download link points to OS/2 version

On the page <http://sqliteman.com/page/4.html> [^] the MS Windows - Download from Sqliteman area at sourceforge.net immediately downloads the OS/2 version. It does not show a listing

0000109: edited rows indicator

you have nice red indicator of deleted rows, if you could add indicator of edited and new added it would be nice. because if i have many edited rows i dont remember rather to commit transaction or not, if i want to see data in another table.

0000159: Blob preview resizes too slowly when main window changes its size.

When Blob preview is activated in the data viewer and resize the main window (horizontally or vertically) to a smaller size, the change of size of the image and the tab view become very slow. The Tab takes a minor size and the image a major size (different sizes that the final size of each object). Then the first one starts growing --slowly-- as other decreases.

I know that this bug is a minor severity, but it is very annoying when you handle tables that contain blob data in them.

0000023: updatable selects

see comments bellow

When viewing the results of a table, buttons to insert rows, delete, etc. are always disabled, even when a select * query is running!

0000107: context menu on cells

it should be easy:):) id like to have a context menu on cells:
1. insert NULL value,
2. open advanced editor

i know when i double click i have buttons, but for me easier is use context menu. if you do this you'll like it for sure! :)

0000154: provide command history

Thank you for the good sqliteman work. I enjoy working with the program.

It would be nice if sqliteman had a history of the commands given via the window on the upper right.

0000167: Build 1.2 on Mac OS X

I'm trying to build the project on Mac OS X. I installed cmake but when I run it's complain about scintilla. I don't know how can install scintilla on Mac.

I have also Qt Creator 2.0.80 (Snapshot-from-2.0-branch) installed on the Mac. Is that possible to have a Qt Creator project for Sqliteman I guess it will be easier to create a binary for each platform.

0000134: DATA Type TEXT COLLATE IUNICODE used across 2 tables creates error

I can't remember the exact command at the moment but its when using values from 2 tables that have collate iunicode it complains that it dosen't recognise the collate iunicode.

When I find a real example I will post additional information.

0000166: panel arrangement becomes unusable

left hand site of panel just went missing, had to find and then delete config to get it working again.

here is old config which makes GUI unusable;

[General]
lastDatabase=/home/simon/.config/chromium/Default/databases/file__0/11
checkQtVersion=true

[window]
geometry=@ByteArray(\x1\xd9\xd0\xcb\0\x1\0\0\0\0\0\x3\0\0\0y\0\0\x6<\0\0\x4|\0\0\0\x3\0\0\0y\0\0\x6<\0\0\x4|\0\0\0\0\0\0)
size=@Size(1594 1028)
splitter=@ByteArray(\0\0\0\xff\0\0\0\0\0\0\0\x2\0\0\x1(\0\0\x1\xa5\x1\0\0\0\x6\x1\0\0\0\x1)

[objectbrowser]
show=false

[sqleditor]
show=false
splitter=@ByteArray(\0\0\0\xff\0\0\0\0\0\0\0\x2\0\0\x1\xaf\0\0\x2_\x1\0\0\0\x6\x1\0\0\0\x2)
filename=

[dataviewer]
splitter=@ByteArray(\0\0\0\xff\0\0\0\0\0\0\0\x2\0\0\x1x\0\0\x2\x13\0\0\0\0\x6\x1\0\0\0\x2)

[recentDocs]
files=/home/simon/.opera/pstorage/02/09/00000000, /home/simon/.opera/pstorage/02/11/00000000, /home/simon/.config/chromium/Default/databases/file__0/11, /home/simon/.config/chromium/Default/databases/http_html5demos.com_0/2, /home/simon/.config/chromium/Default/databases/http_html5demos.com_0/3, /home/simon/.config/chromium/Default/databases/Databases.db

[prefs]
languageComboBox=0
styleComboBox=0
recentlyUsedSpinBox=5
openLastDB=true
openLastSqlFile=true
nullCheckBox=true
nullAliasEdit={null}
nullBgButton=@Variant(\0\0\0\x43\x1\xff\xff\xff\xff\xfe\xfe\xcd\xcd\0\0)
blobCheckBox=true
blobAliasEdit={blob}
blobBgButton=@Variant(\0\0\0\x43\x1\xff\xff\xff\xff\xfe\xfe\xcd\xcd\0\0)
cropColumnsCheckBox=false
sqleditor\font=@Variant(\0\0\0@\0\0\0\x16\0\x41\0n\0\x64\0\x61\0l\0\x65\0 \0M\0o\0n\0o@$\0\0\0\0\0\0\xff\xff\xff\xff\x5\x1\0\x32\x10)
sqleditor\fontSize=10
sqleditor\useActiveHighlightCheckBox=true
sqleditor\activeHighlightButton=@Variant(\0\0\0\x43\x1\xff\xff\xe1\xe1\xed\xed\xff\xff\0\0)
sqleditor\useTextWidthMarkCheckBox=true
sqleditor\textWidthMarkSpinBox=60
sqleditor\useCodeCompletion=false
sqleditor\completionLengthBox=3
sqleditor\useShortcuts=false
sqleditor\shortcuts=@Variant(\0\0\0\b\0\0\0\0)
qscintilla\syDefaultColor=@Variant(\0\0\0\x43\x1\xff\xff\x80\x80\x80\x80\x80\x80\0\0)
qscintilla\syKeywordColor=@Variant(\0\0\0\x43\x1\xff\xff\0\0\0\0\x7f\x7f\0\0)
qscintilla\syNumberColor=@Variant(\0\0\0\x43\x1\xff\xff\0\0\x7f\x7f\x7f\x7f\0\0)
qscintilla\syStringColor=@Variant(\0\0\0\x43\x1\xff\xff\x7f\x7f\0\0\x7f\x7f\0\0)
qscintilla\syCommentColor=@Variant(\0\0\0\x43\x1\xff\xff\0\0\x7f\x7f\0\0\0\0)

[data]
dateTimeFormat=MM/dd/yyyy

[dataExport]
format=0
destination=0
headers=true
encoding=UTF-8
eol=0

0000161: Documentation not in place in Ubuntu .deb

The help contents entry in the Help menu refers to a directory that does not exist. I guess it's a typo.

It tries to go to /usr/share/doc/sqlitemanen/index.html, while the actual file is in /usr/share/doc/sqliteman/en/index.html, so it looks like a / is missing.