I get this message when accessing www.domain.com/project:

* user warning: 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 'DISTINCT(term_data.tid), term_data.name AS term_data_name, term_data.vid A' at line 1 query: SELECT COUNT(*) FROM (SELECT DISTINCT(term_data.tid) AS DISTINCT(term_data.tid), term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.description AS term_data_description FROM term_data term_data LEFT JOIN term_hierarchy term_hierarchy ON term_data.tid = term_hierarchy.tid LEFT JOIN forum_access fa ON term_data.tid = fa.tid LEFT JOIN acl acl_fa ON acl_fa.name = term_data.tid AND acl_fa.module = 'forum_access' LEFT JOIN acl_user aclu_fa ON aclu_fa.acl_id = acl_fa.acl_id AND aclu_fa.uid = 3 WHERE ((fa.grant_view >= 1 AND fa.rid IN (2, 3, 5, 6, 7, 8, 9, 10, 11)) OR fa.tid IS NULL OR aclu_fa.uid = 3) AND ( (term_data.vid in ('1')) AND (term_hierarchy.parent = 0) )) count_alias in /path/to/drupal/sites/default/modules/views/includes/view.inc on line 705.
* user warning: 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 'DISTINCT(term_data.tid), term_data.name AS term_data_name, term_data.vid A' at line 1 query: SELECT DISTINCT(term_data.tid) AS DISTINCT(term_data.tid), term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.description AS term_data_description FROM term_data term_data LEFT JOIN term_hierarchy term_hierarchy ON term_data.tid = term_hierarchy.tid LEFT JOIN forum_access fa ON term_data.tid = fa.tid LEFT JOIN acl acl_fa ON acl_fa.name = term_data.tid AND acl_fa.module = 'forum_access' LEFT JOIN acl_user aclu_fa ON aclu_fa.acl_id = acl_fa.acl_id AND aclu_fa.uid = 3 WHERE ((fa.grant_view >= 1 AND fa.rid IN (2, 3, 5, 6, 7, 8, 9, 10, 11)) OR fa.tid IS NULL OR aclu_fa.uid = 3) AND ( (term_data.vid in ('1')) AND (term_hierarchy.parent = 0) ) LIMIT 0, 30 in /path/to/drupal/sites/default/modules/views/includes/view.inc on line 731.

Any idea what is causing this?

Comments

dww’s picture

dww
we/he/they
commented
Priority: Critical » Normal
Status: Active » Closed (duplicate)

Are you using views or project_solr?

Assuming you're using views, these pages are known and documented not to be working yet:

From the 6.x-1.x-dev release notes:

There are still a number of known bugs we need to resolve before an official release, particularly in the project browsing views.

In particular:
#76726: Refactor project module to use Views [meta issue]
#357925: Provide default project browsing views that don't depend on project_release

jfha73’s picture

jfha73 commented

I'm using Views

dww’s picture

dww
we/he/they
commented

Right. Known to be broken and not currently unsupported...

jfha73’s picture

jfha73 commented

Sorry I did not read those documents, but I did try installing the Solr framework but after enabling it it did not let me go anywhere, just blank screens, I tried assigning more memory to PHP but even with 1024M of memory use, it still showed me just blank pages, so I guess I will have to stick to Views until you guys resolve this issue.

Ryanbach’s picture

Ryanbach commented

Subscribing.

dww’s picture

dww
we/he/they
commented

@Ryanbach: This issue is "duplicate", which means nothing else should happen here. Only the original issue(s) this one points to are still open and valid for further discussion.