pe, 2010-03-12 kello 10:41 +0000, Stuart Pullinger kirjoitti: > > > 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
I can confirm this workaround not working for contacts imported from SIM with pisi. Too bad I don't know anything about sqlite so I don't know where to go from here. _______________________________________________ Shr-User mailing list [email protected] http://lists.shr-project.org/mailman/listinfo/shr-user
