Closed (fixed)
Project:
Activity
Version:
6.x-2.x-dev
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
14 Oct 2010 at 22:30 UTC
Updated:
18 Oct 2010 at 00:24 UTC
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
Comment #1
rjdjohnston commented