Crashing Accounts & Sync after htc sync app removal -- a better fix

---

After flashing damage control 2.3.2 and removing HTC sync apps, the "accounts and sync" control panel was giving me FCs... the sledgehammer advice i found in the DC 2.3.2 announcement was

-If your accounts & sync FC after upgrading from another rom you can try to do the following but be warned you will need to resync everything

Code:

adb remount
adb shell rm /data/system/accounts.db
adb reboot

Yeah, that works, but there's a whole lot of logging-in to do all over again, which is such a bother without a physical keyboard, so here's a modest improvement...

*new & improved* a nice little cryptic incantation to fix the problem without re-syncing...
SO where does the nudge get sent for this to find its way into dconfig??

adb shell
cd /data/system
echo 'delete from accounts where type LIKE "com.htc%";' |sqlite3 accounts.db

--- before I came up with the SQL approach, I did it the hard way ---

adb remount
adb pull /data/system/accounts.db /tmp/

EDIT the accounts.db file (I used the SQLite Manager extension in firefox) and delete all of the com.htc rows from the "accounts" table (I had three for weather, news, and stock applications)...

adb push /tmp/accounts.db /data/system/accounts.db
adb shell reboot

Would anyone care to suggest a more efficient and polished way of doing this same operation? Hmmmmmmmmmm... I guess that'd be an sqlite command-line incantation to be run on the phone...

I just do a factory reset after deleting everything and solves my fc problems.

Wow, thanks! That saved me a lot of headache! I also shortened it into a one-liner:

To check the list beforehand:

adb shell "echo 'select * from accounts;' | sqlite3 /data/system/accounts.db"

To fix the HTC account issues (as per your method):

adb shell "echo 'DELETE FROM accounts WHERE type LIKE \"com.htc%\";' | sqlite3 /data/system/accounts.db"