Enable Facebook Contact Pictures To Appear In Third Party Apps


facebook-contactsFacebook can automatically sync the contacts on your phone be it Android or be it the iOS. However, while the sync is perfect in most cases  the pictures that are synced for these contacts fail to appear in the third party apps such as the popular Handcent SMS, GO SMS and some third party dialers. The apps developers it seems, just don’t bother with fixing this issue. Lucky for us, XDA-Developers forum member My_Immortal has found a way around this mess. More on it after the jump.

The fix is a walk in the park if you have even the slightest bit of knowledge of how to use a terminal or command prompt. The fix is meant for all Android 2.2 Froyo ROMs.
However before you start with the fix, you need to have ADB installed on your system. See our complete guide on what is ADB and how to install it.


  1. To begin, connect your phone to the PC via USB. Make sure USB debugging is enabled in Settings > Application > Development.
  2. Now run command prompt or terminal and enter the following command (in fact copy paste for your convenience):
    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');"
  3. If you’re using terminal on your phone use the same command as above but removing adb shell.

To make sure that the command made the changes it was meant for, enter it once more and you’ll get an error saying: Error: trigger unrestrict_new_data already exists

All done, reboot your device and you’re good to go! For further queries, visit the following thread at XDA-Developers.

  • Josh

    My GoSMS already gets facebook photos just fine though.

  • Manuel

    Any idea how to get facebook sync back to work on the nexus S (2.3.4) again? I cannot even add a facebook account to the sync options..

    • http://www.addictivetips.com/ Zayed Rehman

      Manuel, apparently thats Google’s doing,
      “…Facebook contacts will no longer appear to be integrated with the Android Contacts app. Since Facebook contacts cannot be exported from the device, the appearance of integration created a false sense of data portability…”