Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Problem related to incorrect activity records - some object_id in column 'activity' was filled with nonexistent objects. Probably this happened when I restored site from backup after crush. I was need to execute next query to find broken ids:

SELECT activity.id as aid FROM activity LEFT JOIN askbot_post ON activity.object_id=askbot_post.id WHERE askbot_post.id IS NULL;