Active Topics

 


Page 4 of 4 « First 23 4
Reply
Thread Tools
nick_stokes is offline nick_stokes
2012-08-30 , 17:31
Posts: 31 | Thanked: 5 times | Joined on Nov 2011 @ St. Petersburg, Russia
#31
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 is offline freemangordon
2012-08-30 , 17:43
Posts: 3,074 | Thanked: 12,964 times | Joined on Mar 2010 @ Sofia,Bulgaria
#32
Originally Posted by nick_stokes View Post
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.
__________________
Never fear. I is here.

720p video support on N900,SmartReflex on N900,Keyboard and mouse support on N900
Nothing is impossible - Stable thumb2 on n900

Community SSU developer
kernel-power developer and maintainer
 
misiak is offline misiak
2012-08-30 , 17:53
Posts: 805 | Thanked: 1,605 times | Joined on Feb 2010 @ Gdynia, Poland
#33
Originally Posted by nick_stokes View Post
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.
 

The Following 3 Users Say Thank You to misiak For This Useful Post:
woody14619's Avatar
woody14619 is offline woody14619
2012-08-30 , 17:54
Posts: 1,455 | Thanked: 3,309 times | Joined on Dec 2009 @ Rochester, NY
#34
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.
__________________
Maemo Council Member: May 2012 - November 2012
Hildon Foundation founding member.
Hildon Foundation Board of Directors: March 2013 - Jan 15, 2014
Last edited by woody14619; 2012-08-30 at 17:57.
 

The Following 8 Users Say Thank You to woody14619 For This Useful Post:
mr_pingu is offline mr_pingu
2012-08-30 , 17:55
Posts: 1,163 | Thanked: 1,873 times | Joined on Feb 2011 @ The Netherlands
#35
Originally Posted by nick_stokes View Post
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
__________________
N900 loaded with:
CSSU-T (Thumb)
720p recording,
Pierogi, Lanterne, Cooktimer, Frogatto
N9 16GB loaded with:
Kernel-Plus
--
[TCPdump & libpcap | ngrep]
--
donate
 

The Following 2 Users Say Thank You to mr_pingu For This Useful Post:
nick_stokes is offline nick_stokes
2012-08-30 , 21:29
Posts: 31 | Thanked: 5 times | Joined on Nov 2011 @ St. Petersburg, Russia
#36
Thank you all for your help!
Made according to instructions, see what happens
 
artpra's Avatar
artpra is offline artpra
2012-08-31 , 08:48
Posts: 158 | Thanked: 355 times | Joined on Sep 2011
#37
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.
 

The Following 2 Users Say Thank You to artpra For This Useful Post:
marmistrz is offline marmistrz
2012-08-31 , 11:14
Posts: 3,328 | Thanked: 4,476 times | Joined on May 2011 @ Poland
#38
Originally Posted by nick_stokes View Post
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
__________________
If you want to support my work, you can donate by PayPal or Flattr

Projects no longer actively developed: here
Last edited by marmistrz; 2012-08-31 at 11:17.
 
nick_stokes is offline nick_stokes
2012-08-31 , 19:05
Posts: 31 | Thanked: 5 times | Joined on Nov 2011 @ St. Petersburg, Russia
#39
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!
 

The Following User Says Thank You to nick_stokes For This Useful Post:
Reply
Page 4 of 4 « First 23 4

Tags
backport, fremantle, harmattan, sqlite3

« Previous Thread | Next Thread »

 
Forum Jump


All times are GMT. The time now is 10:59.

Contact Us - Home - Archive - Top