view: activity/all

Drupal: 6.19
Activity: the latest released

error:
* user warning: Unknown column 'a.status' in 'field list' query: SELECT a.aid, a.status as activity_status, u.status as user_status, n.status as node_status FROM activity a INNER JOIN users u ON a.uid = u.uid INNER JOIN node n ON a.nid = n.nid WHERE a.uid <> 0 AND a.type = 'comment' AND a.eid = 0 in /****/sites/all/modules/activity/activity.module on line 348.
* user warning: Unknown column 'activity.status' in 'where clause' query: SELECT COUNT(*) FROM (SELECT activity.aid AS 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 = 'zh-hans') 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 = 1 AND activity_personal_targets.language = 'zh-hans') LEFT JOIN activity_messages activity_personal_messages ON activity_personal_targets.amid = activity_personal_messages.amid WHERE activity.status <> 0 ) count_alias in /****/sites/all/modules/views/includes/view.inc on line 745.
* user warning: Unknown column 'activity.status' in 'where clause' query: SELECT 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 = 'zh-hans') 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 = 1 AND activity_personal_targets.language = 'zh-hans') LEFT JOIN activity_messages activity_personal_messages ON activity_personal_targets.amid = activity_personal_messages.amid WHERE activity.status <> 0 ORDER BY activity_aid DESC LIMIT 0, 50 in /****/sites/all/modules/views/includes/view.inc on line 771.

thanks guys!

Comments

Scott Reynolds’s picture

Scott Reynolds commented
Title: activitis don't show » Unknown column a.status
Status: Active » Reviewed & tested by the community

You have to run update.php. Specifically, activity_update_6203

sirkitree’s picture

sirkitree commented
Component: User interface » Code
Assigned: » Unassigned
Status: Reviewed & tested by the community » Active

Not sure why this is RTBC. There is no patch here. Please close the issue if running update as suggest fixes your issue.

_shy’s picture

_shy
Primary language Ukrainian
Location Ukraine, Lutsk 🇺🇦
commented
Status: Active » Closed (outdated)

D6 reached its EOL back in February 2016, and there is no active release for D6 for this module anymore.
Development or support is not planned for D6. All D6-related issues are marked as outdated in a bunch.

If the issue remains relevant for D10+ versions, merge requests with proposed solutions for a new module version (D10+) are welcome in a new follow-up issue.

Thanks!

Now that this issue is closed, review the contribution record.

As a contributor, attribute any organization that helped you, or if you volunteered your own time.

Maintainers, credit people who helped resolve this issue.