Hello,

I tried adding activity comments to a view and the query error's out on the CID field:

SELECT activity.aid AS aid, COALESCE(activity_personal_messages.message, activity_messages.message) AS activity_messages_message, comment, cid, nid, thread, uid, subject, 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 = '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 WHERE activity.status <> 0 ORDER BY activity_aid DESC LIMIT 0, 25

When I check the db, no CID field, I check the install field no CID field... am I missing something?

Comments

rjdjohnston’s picture

Status: Active » Closed (fixed)