When adding the relationship Activity: Target User to a view, I start getting the following error:

Unknown column 'activity_targets.uid' in 'on clause' SELECT activity.aid AS aid, users_activity.picture AS users_activity_picture, users_activity.uid AS users_activity_uid, users_activity.name AS users_activity_name, activity.created AS activity_created, activity.data AS activity_data, activity.module AS activity_module, activity.operation AS activity_operation, activity.type AS activity_type FROM activity activity INNER JOIN users users_activity ON activity.uid = users_activity.uid LEFT JOIN activity_targets activity_targets ON activity.aid = activity_targets.aid LEFT JOIN users users_activity_targets ON activity_targets.uid = users_activity_targets.uid

Comments

jazzdrive3’s picture

jazzdrive3 commented

Could this be an issue with upgrading from the normal 6 1.2 version?

sirkitree’s picture

sirkitree commented

1.2 to 1.x-dev or 1.2 to 2.x-dev?

jazzdrive3’s picture

jazzdrive3 commented

1.2 to 1.x-dev

jazzdrive3’s picture

jazzdrive3 commented

Any clues on this? What I'm trying to do it get an aggregate of friends activity in the feed as well.

Thanks.

sirkitree’s picture

sirkitree commented

1.x-dev is not supported. I suggest moving back to the supported version.

jazzdrive3’s picture

jazzdrive3 commented

1.2 doesn't have views integration though, does it? Are no bug fixes being done to 1.x-dev?

sirkitree’s picture

sirkitree commented

I don't have time to actively try to fix bugs, but I will review patches that come in.

jazzdrive3’s picture

jazzdrive3 commented

Ok, found the error in the activity.views.inc file.

Line 120 it has:

'relationship field' => 'uid',

It needs to be:

'relationship field' => 'target_uid',

Not sure how to do formal patch files.

Scott Reynolds’s picture

Scott Reynolds commented

http://drupal.org/patch/create

jazzdrive3’s picture

jazzdrive3 commented

How about on windows? Is there an easy way to do it in notepad++?

Thanks.

Scott Reynolds’s picture

Scott Reynolds commented

http://drupal.org/node/60234

Is there an easy way to do it in notepad++

http://tinyurl.com/ykjboyx

jazzdrive3’s picture

jazzdrive3 commented

Oh so clever with the lmgtfy. Do you honestly think I had not already tried several different queries before asking the question? I'm not a complete retard.

Before rolling your eyes in tortured exasperation and trying to make someone feel like an idiot, a simple answer like "The compare plugin can help you do that" will save you some time in the future. Or just don't answer at all if it's such a burden.

Even then, the compare plugin doesn't create a patch file. So I guess the answer is "no".

Scott Reynolds’s picture

Scott Reynolds commented

trying to make someone feel like an idiot

Not trying to do that. Merely trying to point out that you have the skills to find the tools to solve your problem. The patch/create link has a bunch of solutions on how to create a patch on windows. That is how I found it. Did you try any of these here? http://drupal.org/node/324

Now I leave this issue alone as I have become a distraction and this has now gone off topic. My apologies just felt like I was the only one looking and you were demanding. Thank you for finding the problem.

sirkitree’s picture

sirkitree commented
Status: Active » Closed (won't fix)

closing. 1.x no longer supported.