Ghost sms problem on my xdaIIi

[ezone]

Hi, I'm having a a slight problem with my XDA2. After an accidental hard reset when I was changing my simcard, I restored it using activesync but now there's a rather annoying problem with the sms menu where there's one sms that I cannot delete. The annoying part is when that sms counts as unread and now the today screen constantly shows I have one unread message when in truth there's none. I tried moving the messages to another folder but now I have another undeletable sms in my drafts folder(and when i try to open these messages, a blank message comes up even though the content summary shows perfectly well on the message list screen). I also have one more corrupted message in my inbox that shows [no sender] and [no subject] which remains at the top of the list and cant even be opened. I try to open it, the messafe opening screen transition comes out but then nothing happens. I'm sorry if I may seem ranting on but this is my first pda and I'd rather not lose all the SMS i keep in my archive folder. Any help is appreciated. Oh, after reading some posts here to find a solution, no, I'm not using Sprite Backup or anything.

[rs_andy]

I have exactly the same problem except I have more ghost messages, I am using sprite backup though if that has any relevance...?

any ideas?

[omniwolf]

yeah i had the second problem with the sms u can't open on my xda II, but i had hundreds that i couldn't view or delete.

seemed the only way to fix it was to hard reset.. but u might try and get that pocket mechanic i think it is, where you can edit the system databases.. just a thought.

[AE]

You may use dbView to directly delete these messages from WinCE database (make backup first).
Most probably this message is located somewhere in fldrXXXX data table.