Hi,
It's been about 5 months, and the problem is still not resolved : Admin (or user 1) is not able to see activity from anyone. Activity comments are also invisible.
Every other user can see others' activity.

It doesn't work for User 1, neither with Views, nor anything else. It is a real pain to administer the activity comments.
What am I doing wrong ?

Thanks

Comments

Scott Reynolds’s picture

Scott Reynolds commented
Version: 6.x-2.x-dev » 6.x-1.x-dev
Category: bug » support
Priority: Major » Normal
Status: Active » Postponed (maintainer needs more info)

I believe you are using Activity 1.x not the 2.x version.

The 1.x had a permission called hide activity in the admin/user/permissions page. Unfort, for user 1 that permission is always on no matter what.

Activity1 is no longer supported, please consider switching to 2.x.

artscoop’s picture

artscoop commented
Version: 6.x-1.x-dev » 6.x-2.x-dev
Status: Postponed (maintainer needs more info) » Active

Hello Scott,
I'm using Activity 6.x-2.x-dev

I've found something : The Activity views all fail for User 1. But only if I add the "Activity : Message" field. If I remove it, the view works.

artscoop’s picture

artscoop commented

Here are the Views queries run.
The first one does not have a Message field.
The second is the same View on which I've added a Message field.

1. 

SELECT activity.created AS activity_created, activity.op AS activity_op, activity.type AS activity_type, activity.aid AS aid, activity.aid AS activity_aid FROM activity activity  LEFT JOIN node node_activity ON activity.nid = node_activity.nid INNER JOIN users users_activity ON activity.uid = users_activity.uid ORDER BY activity_aid DESC

2.

SELECT activity.created AS activity_created, activity.op AS activity_op, activity.type AS activity_type, activity.aid AS aid, COALESCE(activity_personal_messages.message, activity_messages.message) AS activity_messages_message, activity.aid AS activity_aid FROM activity activity  LEFT JOIN node node_activity ON activity.nid = node_activity.nid INNER JOIN users users_activity ON activity.uid = users_activity.uid INNER JOIN activity_targets activity_targets ON activity.aid = activity_targets.aid AND (activity_targets.uid = 0 AND activity_targets.language = '***ACTIVITY_LANGUAGE***') INNER JOIN activity_messages activity_messages ON activity_targets.amid = activity_messages.amid LEFT JOIN activity_targets activity_personal_targets ON activity.aid = activity_personal_targets.aid AND (activity_personal_targets.uid = ***CURRENT_USER*** AND activity_personal_targets.language = '***ACTIVITY_LANGUAGE***') LEFT JOIN activity_messages activity_personal_messages ON activity_personal_targets.amid = activity_personal_messages.amid ORDER BY activity_aid DESC

The second is the one that fails if User 1 is logged in, no matter which User's activity I watch.

Scott Reynolds’s picture

Scott Reynolds commented

Are the public messages set up for those Activities ?

artscoop’s picture

artscoop commented

Yes, they are.

Scott Reynolds’s picture

Scott Reynolds commented

Is your site multilingual?

artscoop’s picture

artscoop commented

Hmm, the site is set to French only (only language enabled, and is by default, of course). I thought about the language too, but...

Scott Reynolds’s picture

Scott Reynolds commented

Ya its got to be the language then. If you use the Devel module you will see what Views replaces '***ACTIVITY_LANGUAGE***' with.

sirkitree’s picture

sirkitree commented
Status: Active » Closed (fixed)

The resolution is to setup activity message for you language... I think. Correct me if I'm wrong here Scott. I've not done any multilingual stuff.

troyl’s picture

troyl commented

I had the same issue however, the cause was not the activity comment, but the table indexing by the the DB Tuner module, Thought will share with people so they can try this.

Uncheck all the "Experimental Indexes for Core modules" run cron and it shall work all...

Make sure you rebuild the activity access again.

Cheers