I tried to record 'the last person who updated a node'.
I saw a new row created at table 'activity', but this page is always empty:

http://localhost/d6/admin/settings/activity/maintenance

using devel module, I captured the sql:

SELECT activity.aid AS aid, users_activity.name AS users_activity_name, users_activity.uid AS users_activity_uid, COALESCE(activity_personal_messages.message, activity_messages.message) AS activity_messages_message, activity.type AS activity_type, activity.op AS activity_op, activity.created AS activity_created, 'activity_batch_controls:page_1' AS view_name FROM activity activity 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 = 'en') 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 = 'en') LEFT JOIN activity_messages activity_personal_messages ON activity_personal_targets.amid = activity_personal_messages.amid ORDER BY activity_created DESC LIMIT 0, 50

two issues I saw, one is 'activity_targets.uid = 0', another is: language = 'en'
because my default language is not 'en', I also noticed my activity_targets table is empty, any clues?

Comments

Scott Reynolds’s picture

Category: bug » support

You need to make sure that your default language has Activity templates set up for them.

sirkitree’s picture

Status: Active » Closed (fixed)

Please reopen if this is still a problem.