Skype chats and missed calls keep reappearing
I've only seen persistent missed calls so far. These seem to occur when connection drops during a call and an immediate subsequent call from the other side is not answered.
This worked for me:
update Messages set consumption_status = 0 where type = 30 and consumption_status != 0;
(Probably you can drop the whole where clause without messing up anything, but I haven't tried.)
Right click the notification events in Skype and select "Delete Event"
I had the same problem and ended up fixing it as follows:
- backup ~/.Skype/your_skype_login/main.db
- open it with some sqlite viewer (I used SQLite Database Browser, a nice QT-based GUI)
- use some website to convert the date of the annoying unkillable notifications to the Unix timestamp format (don't forget to take the time zone stuff)
- in the table "Messages", delete rows which have timestamps close to the ones obtained in step 3 and corresponding contents of the "author" field (i.e. don't delete messages from other contacts). Interestingly, this also gets rid of the "Missed call" notifications, even though clearing the "Calls" table doesn't have any effect.
- Save the changes back to main.db and start Skype again
To narrow down the messages in question, check the message type is the one of the notification you want to get rid of:
- 61: Chat message
- 30: Call start
- 39: Call end
- 68: File sent
I still don't know where does this bug stem from