|
我的情况,运行; t. v8 m* j, t0 Q
delete from com_palm_messaging_data_ChatThread where chatAddress="+86137!@#@$#@$#";
5 L: G& L4 ?4 s时出现Error: no such collation sequence: LOCALIZED_SECONDARY
+ D: i' j# \. q, N0 J/ ^) ?
V3 }! f3 U7 H* `" q解决办法,在sqlite>下加载,语句如下
. K9 _% }) K a, a* k6 q; H.load /usr/lib/sqlite3_palm_extension.so
- B, \9 J4 N; V之后再次运行 delete,没有错误提示了。1 {- N; h" V3 V7 N
& K9 b: ?. e6 Y! Y/ Y
delete之后,还是无法调用message,删除com_palm_pim_FolderEntry表下的相关短信,这个表是总表,保存着所有短信,com_palm_messaging_data_ChatThread只是保存短信对话的最后一条,语句如下& i( t# X! _+ X8 d9 e- {8 o9 @2 n
delete from com_palm_pim_FolderEntry where fromAddress="+86137!@#@$#@$#";
6 T6 r" `0 @4 A2 [2 h+ [8 x6 _0 Q+ i8 T. i
注意是fromAddress,不再是之前的chatAddress了
! C0 {6 f: _4 X; c$ K5 Z/ K i7 S: [9 C% G
删完之后,久违的短信窗口打开了。
# N, y+ e, y* |# p" H f1 I( A
. m2 B& t X4 M+ M, H0 c# V工具 SQLite Expert9 U+ f. h6 i- `8 q5 `1 j# |9 Y
python2.7- K2 b8 a8 X. N& e$ @
novaproxy.py
I( W, d) C& |, E8 w1 F5 [ putty+ G! A6 M- d6 s- |4 D* E. @
5 m4 x+ g: }- h
; v5 M0 @& r0 X p+ ?7 G$ ?
! o9 J' n! t! t$ u- r3 K |
|