> > Adapted from post in other thread: > > > > ----BEGIN SHELL COMMANDS---- > > cd /etc/freesmartphone/opim > > opkg install sqlite3 > > sqlite3 pim.db > > .databases > > .tables > > delete from contacts_generic where value = ''; > .exit
This workaround works for contacts that I have entered onto the phone using the contacts application recently. However, for contacts that used to be stored on the sim (that I recently imported) it doesn't delete the empty fields. It seems that these contacts are stored in the contacts_phonenumber table. Trying this: select * from contacts_phonenumber; shows the empty fields. Trying this: delete from contacts_phonenumber where value = ''; produces the error: Error: no such collation sequence: compare_numbers I'm afraid my knowledge of sqlite3 is not good enough to interpret this error message. I looked at the COLLATE command but couldn't get it to work. Stuart _______________________________________________ Shr-User mailing list [email protected] http://lists.shr-project.org/mailman/listinfo/shr-user
