From Organic Design
Revision as of 09:02, 4 October 2011 by Nad (talk | contribs) (Posting wiki changes to the users wall: truncation due to varbinary(32))

I'm doing a job that requires a MediaWiki to post recentchanges to facebook wall. I started with wall posts with the facebook PHP SDK, which I got working ok, except for one difference which is that the siteURL is now set from the "website" section of "Select how your app integrates with Facebook" in the "edit App" screen.

Here's the post that my test script did:


Logging in to the wiki with Facebook account

In installed the facebook extension so that users can use their Facebook account to login to the wiki. This requires some database tables to be set up first by running the update.php maintenance script.

  • The Facebook SQL filenames needed to be prepending with the database table prefix before running the maintenance script.
  • I had to make all the permissions on the wiki open so that the extension could create an account.
  • See info about the extension configuration here.

Posting wiki changes to the users wall

I got that working with the following settings:


But there seems to be something wrong with the preferences and I had to comment out a condition in FacebookPushEvent.php on line 169:

   if( !$wgUser->getOption( self::$PREF_TO_DISABLE_ALL ) ) {

// if( $wgUser->getOption( $prefName ) ) {


// }



Further investigation shows that the problem is due to the up_properties field of the user_properties table is of type varbinary(32) so is truncated to 32 characters.