[android] "Message not sent" error message

Related messages
"Message not sent" "Touch to review the message and try again."
"메시지를 보내지 못함" "메시지를 검토한 다음 다시 시도해 보세요."

Some people solved this issue with apps like "Handcent SMS", but I have no luck.
I thought something bad record in sms/mms database table may produce the issue.
Then I started to dig into SQLite database file directly and solved the issue quite easily.

0. root permission is required.

1. import database files from [/data/data/com.android.providers.telephony/database] folder in the phone to the computer.

2. backup all database files before something goes wrong. (ie. compress the folder as one zip-archive)

2. download and install [SQLite Database Browser]. http://sourceforge.net/projects/sqlitebrowser/

3. open [mmssms.db] in [SQLite Database Browser].

4. select [Browse Data] tab.

5. select [pdu] table and insert [0] in [read] filter, then select and delete record with [Delete Record] button where the [read] column is [0]. repeat this on [sms] and [threads] table.

6. select [pending_msgs] table and delete all record with [Delete Record] button. repeat this on [sr_pending] table.

7. select [Write Changes] in [File] menu.

8. export(overwrite) [mmssms.db] file to [/data/data/com.android.providers.telephony/database] folder in the phone.


by 플라밍고 | 2014/05/29 18:24 | 트랙백 | 덧글(0)

트랙백 주소 : http://puremon.egloos.com/tb/2145353
☞ 내 이글루에 이 글과 관련된 글 쓰기 (트랙백 보내기) [도움말]

:         :


비공개 덧글

<< 이전 페이지     다음 페이지 >>