Recent changes to bugs

#64 OSX database corruption on edit

2016-01-10T12:46:59.434000Z

ah, reported on github as well :-)

OSX database corruption on edit

2016-01-10T12:14:41.877000Z

I am editing my sqlite database for Android application on OSX 10.11.2. I have both AndroidStudio and SQLiteBrowser (3.8.0) opened. My database is broken after hours of editing and saving on each change. There must be something in the backround chaning the database file, maybe AndroidStudio, or the AndroidVirtualMachine. Please introduce backround file change detection. I have lost my hours of work two times already. SQLiteBrowser does not verify the written file, so I am writing into pure space and the results are lost.

OSX 10.11.2
Version 3.8.0
Qt Version 4.8.7
SQLCipher Version 3.8.10.2

#63 Crash on open or create database while field editing

2014-07-30T11:04:51.116000Z

Thanks for the bug report. We've recently fixed several bugs that might be the cause of this. Would you be ok to try our latest nightly build, to see if that works for you? (it should)

http://rp.oldsch00l.com/sqlitebrowser/sqlitebrowser.exe.xz
(.xz is a compression type. Use 7-zip to uncompress it)

Btw, we're moving to GitHub, so please use the GitHub Issues area if further problems (not related to this one) happen. :)

https://github.com/sqlitebrowser/sqlitebrowser/issues

Regards and best wishes,

Justin Clift

Crash on open or create database while field editing

2014-07-28T17:19:08.778000Z

Program version: SQLite Database Browser 3.2.0 for Windows 32 bits
Reproduce problem:

Open SQLite Database Browser 3.2.0
Open a Database with some data.
Go to Browser Data tab.
Select table with some contents
Click once on a existing row
Press F2 (Now you can edit field contents)
Press Open Database
Select Database and try to open it.

At this point the program crashes.

Can't browse data on large tables

2013-12-18T08:39:08.221000Z

I can't browse data on large tables. i just wanted to know if there are exactly as much entrys in that table that theoretical should be there. theoretical there should be about 17 million entrys. when i try to browse data it seems like you try to load all entrys, it would be enough to load the 1000 entrys that are displayed on one page and load another 1000 at switching the page. when i try to open it seems that it load very long and then an error appears (attached)

Can not search numerical data

2013-12-15T16:05:42.425000Z

When a table has numerical data, search window does not produce any result (it stays empty). However, search for alphanumeric characters works.

no such function: instr

2013-11-25T10:41:21.011000Z

The instr function was added to sqlite at version:
2012-12-12 (3.7.15)

SQLite Database browser gives the error:
no such function: instr

Connecting to the same database via code does not give this error

delete multiple rows

2013-09-05T15:43:36.956000Z

when selecting multiple records and clicking delete in the "view data" tab, only 1 row is deleted.
This should delete all selected rows

Export ignores non-ASCII charaters

2013-04-26T18:14:01Z

When exporting a table to CSV using a table that contains non-ASCII characters (such as Japanese text), all of those characters are replaced by question marks. The database in this case is set to UTF-8, so you\\\'d expect the export to be UTF-8 as well.

An example is attached - see the `stations` table.

does not compile with qt4.8.4

2013-02-22T11:07:34Z

Hi
When i want to compile version 2b with qt4.8.4 in fedora 18 this error happend :
[alireza@127 sqlitebrowser]$ qmake-qt4
[alireza@127 sqlitebrowser]$ make
cd sqlitebrowser/ && make -f Makefile
make[1]: Entering directory `/home/alireza/archives/deb/trunk/sqlitebrowser/sqlitebrowser'
g++ -c -pipe -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -O2 -Wall -W -D_REENTRANT -DQT_NO_DEBUG -DQT_QT3SUPPORT_LIB -DQT3_SUPPORT -DQT_GUI_LIB -DQT_CORE_LIB -DQT_SHARED -I/usr/lib64/qt4/mkspecs/linux-g++ -I. -I/usr/include/QtCore -I/usr/include/QtGui -I/usr/include/Qt3Support -I/usr/include -Isqlite_source -I.moc -o .obj/extendedmainform.o extendedmainform.cpp
In file included from findform.h:24:0,
from form1.h:31,
from extendedmainform.h:4,
from extendedmainform.cpp:1:
sqlitedb.h: In constructor ‘DBBrowserField::DBBrowserField()’:
sqlitedb.h:44:36: error: call of overloaded ‘QString(int)’ is ambiguous
sqlitedb.h:44:36: note: candidates are:
In file included from /usr/include/QtCore/qobject.h:48:0,
from /usr/include/QtCore/qiodevice.h:46,
from /usr/include/QtCore/qdatastream.h:46,
from /usr/include/QtCore/qmetatype.h:49,
from /usr/include/QtCore/qvariant.h:48,
from form1.h:4,
from extendedmainform.h:4,
from extendedmainform.cpp:1:
/usr/include/QtCore/qstring.h:421:12: note: QString::QString(const QByteArray&)
/usr/include/QtCore/qstring.h:419:12: note: QString::QString(const char*)
In file included from /usr/include/QtCore/qobject.h:48:0,
from /usr/include/QtCore/qiodevice.h:46,
from /usr/include/QtCore/qdatastream.h:46,
from /usr/include/QtCore/qmetatype.h:49,
from /usr/include/QtCore/qvariant.h:48,
from form1.h:4,
from extendedmainform.h:4,
from extendedmainform.cpp:1:
/usr/include/QtCore/qstring.h:725:8: note: QString::QString(const QString&)
In file included from /usr/include/QtCore/qobject.h:48:0,
from /usr/include/QtCore/qiodevice.h:46,
from /usr/include/QtCore/qdatastream.h:46,
from /usr/include/QtCore/qmetatype.h:49,
from /usr/include/QtCore/qvariant.h:48,
from form1.h:4,
from extendedmainform.h:4,
from extendedmainform.cpp:1:
/usr/include/QtCore/qstring.h:89:5: note: QString::QString(QChar)
/usr/include/QtCore/qstring.h:88:14: note: QString::QString(const QChar*)
In file included from findform.h:24:0,
from form1.h:31,
from extendedmainform.h:4,
from extendedmainform.cpp:1:
sqlitedb.h: In constructor ‘DBBrowserIndex::DBBrowserIndex()’:
sqlitedb.h:58:36: error: call of overloaded ‘QString(int)’ is ambiguous
sqlitedb.h:58:36: note: candidates are:
In file included from /usr/include/QtCore/qobject.h:48:0,
from /usr/include/QtCore/qiodevice.h:46,
from /usr/include/QtCore/qdatastream.h:46,
from /usr/include/QtCore/qmetatype.h:49,
from /usr/include/QtCore/qvariant.h:48,
from form1.h:4,
from extendedmainform.h:4,
from extendedmainform.cpp:1:
/usr/include/QtCore/qstring.h:421:12: note: QString::QString(const QByteArray&)
/usr/include/QtCore/qstring.h:419:12: note: QString::QString(const char*)
In file included from /usr/include/QtCore/qobject.h:48:0,
from /usr/include/QtCore/qiodevice.h:46,
from /usr/include/QtCore/qdatastream.h:46,
from /usr/include/QtCore/qmetatype.h:49,
from /usr/include/QtCore/qvariant.h:48,
from form1.h:4,
from extendedmainform.h:4,
from extendedmainform.cpp:1:
/usr/include/QtCore/qstring.h:725:8: note: QString::QString(const QString&)
In file included from /usr/include/QtCore/qobject.h:48:0,
from /usr/include/QtCore/qiodevice.h:46,
from /usr/include/QtCore/qdatastream.h:46,
from /usr/include/QtCore/qmetatype.h:49,
from /usr/include/QtCore/qvariant.h:48,
from form1.h:4,
from extendedmainform.h:4,
from extendedmainform.cpp:1:
/usr/include/QtCore/qstring.h:89:5: note: QString::QString(QChar)
/usr/include/QtCore/qstring.h:88:14: note: QString::QString(const QChar*)
In file included from findform.h:24:0,
from form1.h:31,
from extendedmainform.h:4,
from extendedmainform.cpp:1:
sqlitedb.h: In constructor ‘DBBrowserTable::DBBrowserTable()’:
sqlitedb.h:73:36: error: call of overloaded ‘QString(int)’ is ambiguous
sqlitedb.h:73:36: note: candidates are:
In file included from /usr/include/QtCore/qobject.h:48:0,
from /usr/include/QtCore/qiodevice.h:46,
from /usr/include/QtCore/qdatastream.h:46,
from /usr/include/QtCore/qmetatype.h:49,
from /usr/include/QtCore/qvariant.h:48,
from form1.h:4,
from extendedmainform.h:4,
from extendedmainform.cpp:1:
/usr/include/QtCore/qstring.h:421:12: note: QString::QString(const QByteArray&)
/usr/include/QtCore/qstring.h:419:12: note: QString::QString(const char*)
In file included from /usr/include/QtCore/qobject.h:48:0,
from /usr/include/QtCore/qiodevice.h:46,
from /usr/include/QtCore/qdatastream.h:46,
from /usr/include/QtCore/qmetatype.h:49,
from /usr/include/QtCore/qvariant.h:48,
from form1.h:4,
from extendedmainform.h:4,
from extendedmainform.cpp:1:
/usr/include/QtCore/qstring.h:725:8: note: QString::QString(const QString&)
In file included from /usr/include/QtCore/qobject.h:48:0,
from /usr/include/QtCore/qiodevice.h:46,
from /usr/include/QtCore/qdatastream.h:46,
from /usr/include/QtCore/qmetatype.h:49,
from /usr/include/QtCore/qvariant.h:48,
from form1.h:4,
from extendedmainform.h:4,
from extendedmainform.cpp:1:
/usr/include/QtCore/qstring.h:89:5: note: QString::QString(QChar)
/usr/include/QtCore/qstring.h:88:14: note: QString::QString(const QChar*)
make[1]: *** [.obj/extendedmainform.o] Error 1
make[1]: Leaving directory `/home/alireza/archives/deb/trunk/sqlitebrowser/sqlitebrowser'
make: *** [sub-sqlitebrowser-make_default] Error 2