How to delete ghost SMS from Android

WARNING! You'll lose ALL SMS & MMS data

Connect to your Android using Android Commander by PanPiotr

Make sure Settings->Applications->Development->USB debugging is enabled in phone settings.

Delete MMSSMS.DB file found in

/data/data/com.android.providers.telephony/databases/

Done!