maemo.org - Talk

maemo.org - Talk (https://talk.maemo.org/index.php)
-   MeeGo / Harmattan (https://talk.maemo.org/forumdisplay.php?f=45)
-   -   sqlite databases suddenly read-only. (https://talk.maemo.org/showthread.php?t=92529)

mece 2014-01-26 23:13

sqlite databases suddenly read-only.
 
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::prepare: 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.


All times are GMT. The time now is 07:56.

vBulletin® Version 3.8.8