Wave of Web

I have done this thing quite a few times. But the thing is the users whom I sent the Skype message by mistake used to be online at the same time and I couldn’t do anything before the message got delivered. But few days back I was on Skype and my mouse betrayed me! I clicked on someone’s profile and just dragged it to some other Skype contact! So basically I just shared the contact details with the second guy. Though they already knew each other and in each other’s contact list in Skype, I had some spare time and as the user was offline I thought there must be some way if I want to clear this mess

But apparently Skype doesn’t have any option to do so. I searched through Google and after quite a few heartbreaks I found a way around that really worked. It requires a bit of tinkering with database, but it’s not that hard as it sounds

So you will require SQLite Database Browser as it will help you to execute queries on selected db file easily using GUI. You can download and install it from here. Now you need to find the main.db file for your username that you use to log in to Skype. I am in Windows 7 and I can point out where you can find this file in Windows operating system. It should be something like:

C:\Users\<Windows account username>\AppData\Roaming\Skype\<Skype username>

Inside that folder you will find main.db file. First take a backup of this file and then browse and open this file from SQLite Database Browser. Now execute this query:

select author,identities,dialog_partner,body_xml from messages where sending_status = 1

It will show all the unsent messages that are still pending in your Skype account.

Now execute this query to delete all the unsent Skype messages:

delete from messages where sending_status = 1

And if you want to delete only the messages for a particular Skype contact use this query:

delete from messages where dialog_partner = "username" and sending_status = 1

The username should be the Skype username of the contact whom you sent the message mistakenly.

Related posts:

1. Directly Send Screenshot From Skype Without Storing Image Locally
2. Solve Apache “The requested operation has failed!” Error in Windows
3. Gmail Offline Version is Out for Google Chrome