On every run that calls cron.php, I get the following. I think this is an error with this module, but I can't be sure from the error message and line 66 of database.mysql.inc is nothing like the error reported. I'm unfortunately not conversant enough with MySQL to figure out what's wrong with it.

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 '(p.nid)), p.pid, p.category, p.component, p.priority, p.assigne query: SELECT DISTINCT(n.DISTINCT(p.nid)), p.pid, p.category, p.component, p.priority, p.assigned, p.state, n.title FROM project_issues p INNER JOIN node_access na ON na.nid = p.nid INNER JOIN node n USING(nid) WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0','node_privacy_byrole_role1','node_privacy_byrole_user0')) AND n.status = 1 AND p.state = 2 AND n.changed < 1113680165 in /home/fgs/includes/database.mysql.inc on line 66.

The site was 4.5 with node_privacy_byrole installed; upgraded to 4.6.

Comments

killes@www.drop.org’s picture

killes@www.drop.org commented

This looks as if it was caused by project.module. Did you upgrade this as well?

jack_of_spades’s picture

jack_of_spades commented

Upgraded to CVS, with no change.

ankur’s picture

ankur commented

This looks like an issue with project.module...

Somehow, it is generating a query that doesn't have anything to do with what node_privacy_byrole except that the query accesses a Drupal core database table that node_privacy_byrole inserts data into.

In short, this issue should be re-filed under the project module.... That can be done by clicking on "follow-up" and selecting "Project" from the drop down menu labelled "Project" (yes, it is ironic: you would be using the project module on this site to complain about the project module....).

-Ankur

jack_of_spades’s picture

jack_of_spades commented
Project: node privacy byrole » Project
Component: Code » Projects

As advised.

jack_of_spades’s picture

jack_of_spades commented
Assigned: Unassigned » jack_of_spades

Re-did upgrade to CVS; problem went away.