Hi there,
I am very new to php and I know VERY little. I have installed Activity Log and setup some rules. I then re-generated the recent activity and navigated to the default "activities" page to find the following error and I have no idea what any of it means.
user warning: Unknown column 'gp624_activity_log_templates.pid' in 'IN/ALL/ANY subquery' query: SELECT COUNT(*) FROM (SELECT activity_log_messages.mid AS mid FROM gp624_activity_log_messages activity_log_messages LEFT JOIN gp624_activity_log_templates activity_log_templates ON activity_log_messages.tid = activity_log_templates.tid WHERE (activity_log_templates.display_type = 'web') AND (gp624_activity_log_templates.pid NOT IN (SELECT pid FROM gp624_activity_log_disabled_types WHERE uid = 1)) AND ( viewer_id = 0 OR viewer_id = 1 OR (viewer_id < 0 AND viewer_id <> -1) ) ) count_alias in /home/glopals/public_html/sites/all/modules/views/includes/view.inc on line 805.
user warning: Unknown column 'gp624_activity_log_templates.pid' in 'IN/ALL/ANY subquery' query: SELECT activity_log_messages.mid AS mid, activity_log_templates.tid AS activity_log_templates_tid, activity_log_messages.aids AS activity_log_messages_aids, activity_log_messages.created AS activity_log_messages_created, activity_log_messages.last_updated AS activity_log_messages_last_updated, activity_log_messages.stream_owner_id AS activity_log_messages_stream_owner_id, activity_log_messages.stream_owner_type AS activity_log_messages_stream_owner_type, activity_log_messages.viewer_id AS activity_log_messages_viewer_id, activity_log_messages.target_id AS activity_log_messages_target_id, activity_log_messages.target_type AS activity_log_messages_target_type, activity_log_messages.acting_uid AS activity_log_messages_acting_uid, activity_log_messages.cached AS activity_log_messages_cached, activity_log_templates.rule AS activity_log_templates_rule, activity_log_templates.action_label AS activity_log_templates_action_label, activity_log_templates.template AS activity_log_templates_template, activity_log_templates.group_template AS activity_log_templates_group_template, activity_log_templates.group_summary AS activity_log_templates_group_summary, activity_log_templates.collapse_method AS activity_log_templates_collapse_method, activity_log_templates.pid AS activity_log_templates_pid, activity_log_templates.eval_input AS activity_log_templates_eval_input, activity_log_templates.resources AS activity_log_templates_resources, activity_log_templates.cacheable AS activity_log_templates_cacheable, activity_log_templates.display_type AS activity_log_templates_display_type FROM gp624_activity_log_messages activity_log_messages LEFT JOIN gp624_activity_log_templates activity_log_templates ON activity_log_messages.tid = activity_log_templates.tid WHERE (activity_log_templates.display_type = 'web') AND (gp624_activity_log_templates.pid NOT IN (SELECT pid FROM gp624_activity_log_disabled_types WHERE uid = 1)) AND ( viewer_id = 0 OR viewer_id = 1 OR (viewer_id < 0 AND viewer_id <> -1) ) ORDER BY activity_log_messages_last_updated DESC LIMIT 0, 20 in /home/glopals/public_html/sites/all/modules/views/includes/view.inc on line 810.
Any help would be greatly appreciated!
Thanks,
Chris
Comments
Comment #1
icecreamyou commentedThis has been fixed in dev (along with tons of other things) -- it's a duplicate of #1273288: Activity stream incompatible with table prefixes. I would reinstall instead of upgrading directly though, you'll save yourself some trouble.