After upgrading to 7.3 things went quite well for a while, but now the view for one of my groups seems to be horrifically broken - it keeps changing the title of the page to %1, and pulls what appear to be random articles belonging to different groups.

I finally built a different view that pulls the articles out in a different way than using OG, and that has gotten the site to run again - but I don't understand what is going on. CLearing the views cache makes the regular group title come back for a little while, but the nodes it is pulling up are still wrong.

This is with views 1.6.

It also returns this error whenever I access the page

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= og_ancestry. INNER JOIN node_access na ON na.nid = node.nid LEFT JOIN node n ' at line 1 query: SELECT DISTINCT(node.nid), node.sticky AS node_sticky, node.created AS node_created_created FROM node node LEFT JOIN og_ancestry og_ancestry ON . = og_ancestry. INNER JOIN node_access na ON na.nid = node.nid LEFT JOIN node n ON node.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public'))) AND ((n.moderate != 1)) AND ( (node.status = '1') AND (og_ancestry.group_nid = 3) ) ORDER BY node_sticky DESC, node_created_created DESC LIMIT 0, 20 in /var/www/drupalexp/includes/database.mysqli.inc on line 151.

The other organic groups on the site seem to continue to work properly.

Comments

steve hanson’s picture

After looking at this a little more, it appears that its just not filtering by organic group at all due to the error and is showing all of the nodes when going to an organic groups page. ANd now all of the organic groups are acting the same way.

moshe weitzman’s picture

Status: Active » Closed (duplicate)

it sounds like your default views are not being picked up which has been reported elsewhere. try to look around in admin/build/views page.

steve hanson’s picture

It appears that this is a duplicate of #278982 =

After the 7.3 upgrade all kinds of bad juju happens if you have comments or attachments turned on for the group node type. After turning those off for the node type, everything went back to normal.

christefano’s picture

This issue is a duplicate of #278469.