Trouble Displaying Poster Picture in Activity 2.x view.

subscribing and swinging back later hopefully.

As noted here, I can confirm this problem. However this should be the only relevant difference between the patched version and the current dev, and that was necessary to solve #728576: can only get fbss posts by the user and not posts done to user. (I'm not sure what's wrong here, but if I have to choose, I would rather have #728576 working.)

Subscribing. I have the same problem as pribeh.

This is an error: http://drupalcode.org/viewvc/drupal/contributions/modules/facebook_statu...

 //No need to save both if they are equal. 	     
$result = db_fetch_object(db_query("SELECT pid FROM {facebook_status} WHERE sid = %d", $activity->eid));
$poster = db_fetch_array(db_query("SELECT pid FROM {facebook_status} WHERE sid = %d AND pid <> %d", $activity->eid, $activity->uid));
$realms['facebook_status_poster'] = array($result->pid);
if ($poster['pid']) { 	 
  $realms['facebook_status_poster'] = array($poster); 	 
}

That will produces $realms['facebook_status_poster']['pid'] = SOME_ID

//No need to save both if they are equal. 	     
$poster = db_fetch_array(db_query("SELECT pid FROM {facebook_status} WHERE sid = %d AND pid <> %d", $activity->eid, $activity->uid));
$realms['facebook_status_poster'] = array($result->pid);
if ($poster['pid']) { 	 
  $realms['facebook_status_poster'] = array($poster['pid']); 	 
}

And that produces $realms['facebook_status_poster'][] = SOME_ID
Not sure that fixes this but taking a quick pass at this, I can see thats a problem if only in syntax. The data very well might be saved away correctly.

This is mostly a note for myself.

Actually the first one results in this:

$realms['facebook_status_poster'][]['pid'] = SOME_ID

Of those two, the second seems more logical, although it's possible that the desired result is actually this:

$realms['facebook_status_poster']['pid'] = SOME_ID

...which neither produces.

I'm having the exact same problem. Is there a solution to display the status poster for the latest dev builds for FBSS and Activity? I've been searching and haven't found a detailed solution for this to work.

This issue is still open because there is currently no straightforward solution that does not involve coding.

Re #5 it looks to me like the data is being saved correctly.

I spent the last 20 minutes trying to figure this out and failed. I think one viable solution though would be to write a relationship from Activity to FBSS for Views so that it doesn't have to go through the User table relationship. (One symptom of the current problem is that the poster id has the same value as the owner id for some reason, and it looks like it may be related to complex joins? I'm not sure. Well, either that or something to do with facebook_status_activity_access_grants().)

The important thing should be the activity.uid. No need for a relationship. The activity.uid should always be the person that 'did' something. The bug resides in the main object being wrong somewhere.

Well, here's something weird.

Also, activity.uid is correctly recorded in the database. The problem is with the view, not with the data being recorded.

Well, there's still something very wrong here, but since I can't figure out how to fix the core problem, I've added the Views field Activity: FBSS Poster pic to FBSS dev as a workaround.

Mm? You should not need to load two user pics. The only performance issue is one minor query has to be run per row.

Just committed a change that turns "Activity: FBSS Poster picture" into "Activity: Poster picture." In other words, the field now displays the same as the "User: Picture" field if it's not on an activity message for a status update. This should eliminate any duplicate picture problems.