[HTC Rezound] derek4484:
I got it to work finally. I'll explain how I had to do it. The instructions above (post #11) were not quite correct for my phone (stock rooted).

Downloaded the sqlite3 and libnscurses files and placed on SD card.

Used Root Explorer to cut and paste them into the appropriate folders because I couldnt push them because the system/xbin and system/lib folders were read only.

Using root explorer while the phone is plugged in via USB to my computer and debugging turned on, I went to the /system/xbin folder and mounted it r/w with the button in the upper right corner (in root explorer).

Started ADB.

adb shell

su

cd system

cd xbin

chmod 777 sqlite3

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');"

I absolutely had to become superuser (the SU command) right after entering the shell or else the chmod command wouldnt work, and without that command the last sqlite command doesnt work. That entire bunch of text should be entered in one continuous command. Also, I was not able to get it to work properly if I cut the text from the browser window here and pasted it into the command (DOS) window. It acted all weird. I had to type the entire thing letter by letter and then proof read it before I hit ENTER. That was the only way I was able to get it to work for me. YMMV.

Also, please note that in the post up above (post #11) that details these commands there is some extra garbage at the end of his that is not required and is because he cut and pasted from the terminal window into the window here. What you see up above on mine is all that is required.

After you enter the big long command it'll just return right back to the "#" prompt in the command window. that means the command executed. Then just type "exit" twice (once to exit SU mode and once to exit shell mode), then reboot the phone. And it should be working. At least it does for me. I can now use SMS popup and it brings in contact photos that are sync'd from facebook friends. SMS popup always brought in photos for me if I had set them as contact photos manually, it just never brought in the facebook sync'd photos. It does now.

BTW, the reason for this is because the official facebook app syncs photos to contacts but it sets them so that 3rd party apps cannot access them. The other way around this is to use Friendcaster to sync your facebook friends/photos to your contacts and turn off sync in the facebook app. I was doing that before. Using facebook app for everything except syncing, I let friendcaster sync and everything worked nicely.

One other note about facebook sync. The samsung phones that have touchwiz, have a samsung made facebook sync under "accounts and sync" that worked flawlessly and allowed 3rd party apps to use the photos. If you installed facebook app on a samsung phone and went to accounts and sync, there would be two facebook icons, one was samsung's and one was facebook's; as long as you use the samsung one it worked great, if you picked the wrong one then the photos would not be accessible by other apps.