Active Topics
-
List of well performing apps on Leste (34)
to Maemo 7 / Leste by biketool - 9 hrs, 45 mins ago -
Maemo repository (5)
to Community by dredlok706 - 2 days, 4 hrs ago -
Re-commissioning N9 in 2018 (127)
to MeeGo / Harmattan by smatkovi - 2 days, 7 hrs ago -
Porting apps to Leste (41)
to Maemo 7 / Leste by Arno_11 - 3 days, 1 hr ago -
N900 is not recognizable on any of my devices (windows 10,7, xp) What can I do? (1)
to Nokia N900 by nieldk - 4 days, 13 hrs ago - more...
I don't know if this has already been discussed somewhere else, but I didn't know how to remove very old messages without remove the whole conversation. Then I wrote this little script. Hope this helps someone else too.
#!/bin/sh if [ $# -eq 0 ]; then echo "usage: $(basename $0) <db file> \"YYYY-MM-DD HH:MM\"" exit 1 fi db=$1 sqlite=sqlite3 # timestamp date=$(date +%s --date="$2") echo "${sqlite} ${db} \"DELETE FROM Events WHERE storage_time<'$date';\"" ${sqlite} ${db} "DELETE FROM Events WHERE storage_time<'$date';" echo "${sqlite} ${db} \"SELECT event_id FROM GroupCache;\"" ids=$(${sqlite} ${db} "SELECT event_id FROM GroupCache;") for id in $ids; do echo "${sqlite} ${db} \"SELECT remote_uid FROM Events WHERE id='$id';\"" number=$(${sqlite} ${db} "SELECT remote_uid FROM Events WHERE id='$id';") echo "${sqlite} ${db} \"SELECT COUNT(id) FROM Events WHERE remote_uid='$number';\"" total_events=$(${sqlite} ${db} "SELECT COUNT(id) FROM Events WHERE remote_uid='$number';") echo "${sqlite} ${db} \"UPDATE GroupCache SET total_events='$total_events' WHERE event_id='$id';\"" ${sqlite} ${db} "UPDATE GroupCache SET total_events='$total_events' WHERE event_id='$id';" echo "${sqlite} ${db} \"UPDATE GroupCache SET read_events='$total_events' WHERE event_id='$id';\"" ${sqlite} ${db} "UPDATE GroupCache SET read_events='$total_events' WHERE event_id='$id';" done exit 0Note, it's the first time I play with the rtcom database.
PS. I used it and everything still works fine, but I suggest you to DO A BACKUP before!