maemo.org - Talk - View Single Post - sqlite databases suddenly read-only.

	mece	2014-01-26 , 23:13
	Posts: 1,111 \| Thanked: 1,985 times \| Joined on Aug 2009 @ Åbo, Finland	#1

I suddenly have a very annoying problem. Seems I can't write to or create new sqlite databases from qml. It's not just some random apps I've messed about with but stuff like twitter and FBReader that I have been using for years without problem.
for example something like this

Code:

var db = openDatabaseSync("Test", "1.0", "Test", 1000000);
db.transaction( function(tx) {
    tx.executeSql('CREATE TABLE IF NOT EXISTS TEST (testcolumn VARCHAR(32) NOT NULL, othercolumn TINYINT NOT NULL DEFAULT 0)');

Tells me QSqlQuery:

repare: database not open

doing the same thing with an existing database (that was created before this happened) results in
Error: unable to open database file Unable to fetch row

I can read from existing databases just fine.

I checked the file permissions and they were correct, and even tried making directory (which is ~/.local/share/data/QML/OfflineStorage/Databases by default) 777 and existing databases 666 and it didn't make any difference.

these are the library versions installed:

libqt4-sql-sqlite 4.7.4~git20120327-0maemo1+0m8
libsqlite3-0 3.7.7-2+maemo2+0m6

Incredibly annoying when FBReader doesn't remember what page I was on because it can't write to the db.

The problem appeared around the time I added caldav sync to google last week.

Any ideas are welcome.

__________________
Class .. : Meddler, Thread watcher, Developer, Helper
Humor .. : [********--] Alignment: Pacifist
Patience : [*****-----] Weapon(s): N900, N950, Metal music
Agro ... : [----------] Relic(s) : N95, NGage, Tamyia Wild One
Try Tweed Suit for your hardcore twittering needs
http://twitter.com/mece66
I like my coffee black, like my metal.

Quote & Reply |