That's not as easy to answer as I would like, but it's from qtcontacts-sqlite
0.2.0 onward, which I think is in sailfish OS 2.0.1.1 :-)
Thanks,
Matt
From: devel-boun...@lists.sailfishos.org [devel-boun...@lists.sailfishos.org]
on behalf of Tone Kastlunger [users
Okay, I added the pragma_version; everything seems fine and legit -
contacts show and load faster than before!.
Out of curiosity, which update upgrades to version 16?
On Tue, Oct 27, 2015 at 9:37 AM, Matthew Vogt
wrote:
> Hmm, it shouldn't be possible to have a malformed database after doing th
Hmm, it shouldn't be possible to have a malformed database after doing the
import. I have no idea how that could happen.
If you don't update the user_version to the correct version, then at each boot
the first process to open the database will look at the version and try to run
all the scripts
Here's what I did:
a) I followed your instructions, this gave me a new database (with imported
contacts) and the integrity errors as per the mail above;
b) I did a
mv contacts.db broken.db;
sqlite3 contacts.db
.read ../temp/dump.sql
c) i did NOT run this : sqlite3 new-db/contacts.db "pragma u
Hi Tone.
Are you saying that you created a new database by using sqlite3 to import the
dump you previously, and then you ran "pragma integrity_check;" on that new
database, and found errors? That should be unpossible...
You have no contacts in the people app? Can you try using contacts-tool a
Okay! After doing it from the sqlite3 shell another time, the
integrity_check succeeded on the new file.
Thanks!
On Tue, Oct 27, 2015 at 9:10 AM, Tone Kastlunger
wrote:
> Hey Matthew;
> thanks for the fast reply!
>
> Here's what I get from the new DB (after having run sqlite3
> qtcontacts-sqli
Hey Matthew;
thanks for the fast reply!
Here's what I get from the new DB (after having run sqlite3
qtcontacts-sqlite/contacts.db "pragma integrity_check;" on the newly
created db):
[nemo@Jolla Contacts]$ sqlite3 qtcontacts-sqlite/contacts.db "pragma
integrity_check;"
*** in database main ***
On
