maemo.org - Talk

maemo.org - Talk (https://talk.maemo.org/index.php)
-   Maemo 5 / Fremantle (https://talk.maemo.org/forumdisplay.php?f=40)
-   -   [Announce] Updated sqlite3 for Fremantle (https://talk.maemo.org/showthread.php?t=85587)

nick_stokes 2012-08-30 17:31

Re: [Announce] Updated sqlite3 for Fremantle
 
Is it possible to do without clean database? I kept about 7000 sms, do not want to delete.

overclock is used when necessary, but the reason is not exactly the point.

freemangordon 2012-08-30 17:43

Re: [Announce] Updated sqlite3 for Fremantle
 
Quote:

Originally Posted by nick_stokes (Post 1258032)
Is it possible to do without clean database? I kept about 7000 sms, do not want to delete.

overclock is used when necessary, but the reason is not exactly the point.

The point is that overclock could lead to corrupted data (conversations db in your case) if done unwise. And you definitely suffer from a corrupted database.

You could try to use ovi suite to backup your sms-es, don't know if that works though.

misiak 2012-08-30 17:53

Re: [Announce] Updated sqlite3 for Fremantle
 
Quote:

Originally Posted by nick_stokes (Post 1258032)
Is it possible to do without clean database? I kept about 7000 sms, do not want to delete.

overclock is used when necessary, but the reason is not exactly the point.

You can try doing things as described here: http://www.parorrey.com/blog/technol...on-nokia-n900/ this guy shows three possible solutions from which only one includes deleting database.

woody14619 2012-08-30 17:54

Re: [Announce] Updated sqlite3 for Fremantle
 
I would also humbly suggest glogarchiver. It can store, sort, search, and view the database much more efficiently. This allows you to not only export them (as csv) but also allows you to clean out your primary database for better performance. I find that having over a few thousand entries tends to make the whole thing slow down. Not only that, but this one database stores all kinds of info, including in/out call info, SMS data, IM messages, and more.

There is also a simple way to clean out and compact your existing database, which is useful if yours has become corrupted or you do a lot of deleting. I don't recall the exact command now, but you can power search for "sqlite dump" and the name of the database file (evl.db?).

Edit: Misiak linked to a good article about the second thing above.

mr_pingu 2012-08-30 17:55

Re: [Announce] Updated sqlite3 for Fremantle
 
Quote:

Originally Posted by nick_stokes (Post 1258000)
I have a problem with this update.
At random new calls are no longer recorded in the database, incoming messages can be seen only once and can not be coming at all. Reboot helps only to a certain point, the relationship did not understand.
Is it possible to downgrade? How?
Strains constantly reboot the phone ..

These corrupted databases were also quite common on the original version too. Don't think we can easily blame this version. Didn't use this version myself though.. But the corrupted database bug has occured once on me ;)

See here: http://talk.maemo.org/showthread.php?p=987808

nick_stokes 2012-08-30 21:29

Re: [Announce] Updated sqlite3 for Fremantle
 
Thank you all for your help!
Made according to instructions, see what happens :)

artpra 2012-08-31 08:48

Re: [Announce] Updated sqlite3 for Fremantle
 
I`m running this sqlite3 version since day one (now with CSSU Thumb) - started with clean database: removed previous and rebooted before installation.
Zero problems and faster sms browsing (scrolling up into sms conversation history).
CSSU worthy package IMHO.

marmistrz 2012-08-31 11:14

Re: [Announce] Updated sqlite3 for Fremantle
 
Quote:

Originally Posted by nick_stokes (Post 1258000)
I have a problem with this update.
At random new calls are no longer recorded in the database, incoming messages can be seen only once and can not be coming at all. Reboot helps only to a certain point, the relationship did not understand.
Is it possible to downgrade? How?
Strains constantly reboot the phone ..

You can downgrade by
Code:

# apt-get install sqlite3=3.6* libsqlite3-0=3.6*
in case you would suspect that newer sqlite3 is to be blamed somewhere.

Thanks to misiak, freemangordon, woody14619 and mr_pingu for assistance when I was out :)

nick_stokes 2012-08-31 19:05

Re: [Announce] Updated sqlite3 for Fremantle
 
The fact that the problem exists only appeared after the update, recently nothing else installed. But I did VACUUM and do not watch more than a day to the problem. It is possible that this was an unfortunate coincidence. In any case, thank you for your support!


All times are GMT. The time now is 18:38.

vBulletin® Version 3.8.8