Problem with case tracker

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
geodaniel's picture
Posted by geodaniel on May 9, 2006 at 11:29am

The site is looking good Moshe. However, I got caught up in an SQL error when I navigated into the cases tab in the search page.

Warning: Unknown table 'n' in on clause query: SELECT * FROM node INNER JOIN node_access na ON na.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') OR (na.gid = 0 AND na.realm = 'og_all') OR (na.gid = 30 AND na.realm = 'og_subscriber') OR (na.gid = 326 AND na.realm = 'og_subscriber') OR (na.gid = 162 AND na.realm = 'og_subscriber') OR (na.gid = 303 AND na.realm = 'og_subscriber'))) AND type = 'casetracker_project' in /var/www/groups.drupal.org/htdocs/includes/database.mysql.inc on line 120

It looks like it should start SELECT * FROM node n INNER JOIN

Comments

fixed?

Posted by moshe weitzman on May 13, 2006 at 4:47pm
moshe weitzman's picture

please confirm that the casetracker team has fixed this and the search page works as designed.