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
Comment #1
Scott Reynolds commentedYou need to make sure that your default language has Activity templates set up for them.
Comment #2
sirkitree commentedPlease reopen if this is still a problem.