Hi Brajesh,
i know you have the mediapress plugin.
But in my theme i have now the rtMedia plugin.The problem is, that anonymous and rtMedia comes in conflict. When i visit other profiles and i try to open the profiles activities, i get this error:
[Unknown column ‘mySQl-db_bp_activity_meta.activity_id’ in ‘where clause’]
Only if i logged in with super-admin, i can see other activities on member-profile /activities.
If i logged in with normal-user-account, i get the above error message or buddy tell me, there is no privat activities on member-profile.If i disable one of the plugins (anonymous or rtMedia) all works fine.
Can you help me, please? I have also written rtMedia support.
Thanks !! π πThe exact error message:
SELECT DISTINCT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name FROM mySQL_bp_activity a LEFT JOIN mySQL_users u ON a.user_id = u.ID LEFT JOIN mySQL_rt_rtm_media m ON ( a.id = m.activity_id AND m.blog_id = β1β ) LEFT JOIN mySQL_rt_rtm_activity ra ON ( a.id = ra.activity_id and ra.blog_id = β1β ) WHERE ( ( ( a.user_id = β14β AND a.hide_sitewide = 0 ) OR ( a.component = βfriendsβ AND a.secondary_item_id = β14β ) ) ) AND a.is_spam = 0 AND ( mySQL_bp_activity_meta.activity_id IS NULL ) AND a.type NOT IN (βlast_activityβ) AND (NOT EXISTS (SELECT m.activity_id FROM mySQL_bp_activity_meta m WHERE m.meta_key=βrtmedia_privacyβ AND m.activity_id=a.id) OR ( (ra.privacy is NULL OR ra.privacy <= 0) OR ((ra.privacy=20) OR (a.user_id=2 AND ra.privacy >= 40) OR (ra.privacy=40 AND a.user_id IN (β85β,β64β,β20β,β12β,β23β,β8β²,β16β,β17β,β32β,β24β))) ) ) ORDER BY a.date_recorded DESC LIMIT 0, 20
—–
Or i have incorrectly install the anonymous plugin?
(But it works in my theme!)Hi Sebastian,
This is a problem at the end of RT Media.Anonymous activity does not do any sql query directly. All we do is filter
‘bp_has_activities’ and pass a meta_query argument. BuddyPress handles the rest. Please ask the RT Media guys to look into it, most probably thy are doing direct query/filtering on the activities which is conflicting with the activity meta query.Closing this as It is related to 3rd party plugin and hoping that they should have dealt with it by now.
The topic ‘ [Resolved] Anonymous Plugin with rtMedia (conflict)’ is closed to new replies.