[HTC Rezound] pkopalek:
First try, HTC Sync On,

Acted like it worked. Superuser was installed. But the first 'adb shell rm -r xxxxxx' commands returned 'file not found' errors.

Superuser was there, but nothing.

Tried again. This time, no errors. It rebooted the phone. (kept it plugged into computer). HTC boot screen for 5 minutes.........

I unplug the USB cable. Screen goes black. But the charging (orange) light stays on. I push the power button. THe screen lights up (but is 100% black). I push the power button and hold it. The screen goes off and so does the charging light this time. Now, nothing happens. Power button does nothing. Nothing does anything.

Battery pull and replace.

Boots up just fine.

No root, or superuser.apk, or anything.

Try again this time using Charge Only.

Works as smooth as butter.

The lesson for me was to not use HTC Sync, but to use Charge Only. None of those adb commands in the script need HTC Sync to work. So that part is unnecessary. The only reason that might help is that if your computer already has drivers installed for when your phone is in HTC Sync mode, but not for when it's in Charge Only mode...... but I don't think it even shows up as a different device when you switch it.

So I think Charge Only was the victor here. Love it.

Going to use the facebook contact photo fix script so that Facebook photos show up in Google Voice and other places:

adb shell sqlite3 /data/data/com.android.providers.contacts/databases/contacts2.db "CREATE TRIGGER unrestrict_new_data AFTER INSERT ON raw_contacts BEGIN UPDATE raw_contacts SET is_restricted=0 WHERE _id=NEW._id and NEW.is_restricted!=0 and NEW.account_type in ('com.facebook.auth.login'); END; CREATE TRIGGER unrestrict_updated_data AFTER UPDATE OF is_restricted ON raw_contacts BEGIN UPDATE raw_contacts SET is_restricted=0 WHERE _id=NEW._id and NEW.is_restricted!=0 and NEW.account_type in ('com.facebook.auth.login'); END; UPDATE raw_contacts SET is_restricted=0 WHERE is_restricted!=0 AND account_type in ('com.facebook.auth.login');"

winning. That should stay through a reboot.

If anyone else wants to do the facebook contact photo fix, i attached the two files you need.

these are the steps i took (yes I know you can do them with shorter hand, but i did them this way, so i'm writing it here)

adb push sqlite3 /system/xbin

adb shell

cd system

cd xbin

chmod 777 sqlite3

exit

adb push libncurses.so /system/lib

adb shell sqlite3 /data/data/com.android.providers.contacts/databases/contacts2.db "CREATE TRIGGER unrestrict_new_data AFTER INSERT ON raw_contacts BEGIN UPDATE raw_contacts SET is_restricted=0 WHERE _id=NEW._id and NEW.is_restricted!=0 and NEW.account_type in ('com.facebook.auth.login'); END; CREATE TRIGGER unrestrict_updated_data AFTER UPDATE OF is_restricted ON raw_contacts BEGIN UPDATE raw_contacts SET is_restricted=0 WHERE _id=NEW._id and NEW.is_restricted!=0 and NEW.account_type in ('com.facebook.auth.login'); END; UPDATE raw_contacts SET is_restricted=0 WHERE is_restricted!=0 AND account_type in ('com.facebook.auth.login');"

Done and done.

If you try the last command again

adb shell sqlite3 /data/data/com.android.providers.contacts/databases/contacts2.db "CREATE TRIGGER unrestrict_new_data AFTER INSERT ON raw_contacts BEGIN UPDATE raw_contacts SET is_restricted=0 WHERE _id=NEW._id and NEW.is_restricted!=0 and NEW.account_type in ('com.facebook.auth.login'); END; CREATE TRIGGER unrestrict_updated_data AFTER UPDATE OF is_restricted ON raw_contacts BEGIN UPDATE raw_contacts SET is_restricted=0 WHERE _id=NEW._id and NEW.is_restricted!=0 and NEW.account_type in ('com.facebook.auth.login'); END; UPDATE raw_contacts SET is_restricted=0 WHERE is_restricted!=0 AND account_type in ('com.facebook.auth.login');"

It should say trigger unrestrict_new_data already exists. If it doesn't, it probably didn't work!