maemo.org - Talk - How to delete multiple SMS messages

maemo.org - Talk (https://talk.maemo.org/index.php)

- MeeGo / Harmattan (https://talk.maemo.org/forumdisplay.php?f=45)

- - How to delete multiple SMS messages (https://talk.maemo.org/showthread.php?t=83344)

Re: How to delete multiple SMS messages

Leinad,

I use in firefox an extension named "SQLite Manager" (but then my SQL skills are non-existent so I don't know if this is what you are looking for)...My meta.db is over >110MB as you can see from the ls -l I posted so 40MB is pretty ok :)

Also on your phone you can use sqlite3 to explore...

I'm running the grep now...let's see what happens...

Edit: Grep doesn't do anything for me too...Just keeps running...

Re: How to delete multiple SMS messages

You have these file access problems because the /home/user/.cache/tracker attributes do not allow listing of the directory to anyone but users who belong to group "metadata":

Code:

juice@firefly:~$ 

juice@firefly:~$ 

juice@firefly:~$ ssh user@n9usb 

user@n9usb's password: 



BusyBox v1.20.0.git (MeeGo 3:1.20-0.2+0m8) built-in shell (ash)

Enter 'help' for a list of built-in commands.



~ $ devel-su

Password: 



BusyBox v1.20.0.git (MeeGo 3:1.20-0.2+0m8) built-in shell (ash)

Enter 'help' for a list of built-in commands.



~ # 

~ # ls -la /home/user/.cache/

total 72

drwxr-xr-x   15 user     users         4096 Oct  3 14:12 .

drwxrwxrwx   71 user     users         4096 Nov 13 15:55 ..

drwxr-xr-x    3 user     users         4096 Jun 25 15:48 Nokia

drwxr-xr-x    3 user     users         4096 Jun 21 12:19 Till Harbaum

drwxr-xr-x    2 user     users         4096 Nov 15 18:50 contactsd

drwxr-xr-x    3 user     users         4096 Aug  2 11:24 data

drwxr-xr-x    2 user     users         4096 Aug  6 17:37 farsight

drwx------    4 user     users         4096 Jun 28 20:15 libkok

drwxr-xr-x    2 user     users        16384 Oct 21 01:40 media-art

drwx------    2 user     users         4096 Oct  3 14:42 menus

drwxr-xr-x    5 user     users         4096 Jun 21 15:07 music-suite

drwxr-xr-x    4 user     users         4096 Jun 21 15:07 nmsrestapi

drwx------    2 user     users         4096 Jun 21 09:35 rygel

d---rwx---    2 metadata metadata      4096 Nov 15 13:42 tracker

drwxr-xr-x    3 user     users         4096 Jun 21 12:04 video-suite

~ #

Access to the file/directory is of course possible when you are root. (and for the record, of course I also run my device in open mode, else all this stuff wouldn't be possible)

So, I just tarred the whole tracker directory; "tar -cvf trackercache.tar /home/user/.cache/tracker" and then copied it off to my desktop using sftp.

I used sqlitebrowser (version 2.0.0~beta1+ds.1-2 that comes with ubuntu 12.04, but I suppose any version works...) to extract the DB as a CSV file.
Additionally I used python sqlite package "apsw" to test reading the DB file.

Re: How to delete multiple SMS messages

May i know who created the native message app in Nokia N9 it self...

Re: How to delete multiple SMS messages

Quote:

Originally Posted by thedead1440 (Post 1294818)

I use in firefox an extension named "SQLite Manager" (but then my SQL skills are non-existent so I don't know if this is what you are looking for)...My meta.db is over >110MB as you can see from the ls -l I posted so 40MB is pretty ok :)

This Firefox-Addon works great, better than all the stuff i downloaded before. SQLite is not my native "dialect", but i have to deal with mySQL everyday :)

Quote:

Originally Posted by thedead1440 (Post 1294818)

I'm running the grep now...let's see what happens...
Edit: Grep doesn't do anything for me too...Just keeps running...

It ran at least 2 hours on my phone and looked like it was freezing,maybe give it some time more (8h over night?)

Quote:

Originally Posted by juiceme (Post 1294841)

You have these file access problems because the /home/user/.cache/tracker attributes do not allow listing of the directory to anyone but users who belong to group "metadata":

Yep. i noticed that too :)

Quote:

Originally Posted by juiceme (Post 1294841)

Access to the file/directory is of course possible when you are root.

Nope. (for proof, see my putty-log, i was logged in as root)

Quote:

Originally Posted by juiceme (Post 1294841)

(and for the record, of course I also run my device in open mode, else all this stuff wouldn't be possible)

Nope. possible without open mode, thanks to Ariadne :)

Did a tracker reset and some things more to report, but i will do it tomorrow... got to go to sleep now :)

Re: How to delete multiple SMS messages

Ok will leave it to run over-night tonight; will report after 24 hrs as its 1035 here now :D

However, I don't think we'll get anything interesting except for the freezing part which I too experienced yesterday :)

Re: How to delete multiple SMS messages

Let me know, here it's 03:38 ;)

Re: How to delete multiple SMS messages

any further improvement???

Re: How to delete multiple SMS messages

Hi friends , Till now there is no solution for multiselection and delete on the message application.

Can anyone confirm it that it'll be available in sailfish...