I just intalled ACL and forum access on my Drupal 5 RC2 website.

I activated the modules, configured the forum. This all seemed to work fine. But when I logged out, I got this message:

* 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 ' 1)) OR fa.tid IS NULL OR aclu.uid = 0) AND (t.tid IN (4, 0) OR query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid LEFT JOIN forum_access fa ON t.tid = fa.tid LEFT JOIN acl acl ON acl.name = t.tid AND acl.module = 'forum_access' LEFT JOIN acl_user aclu ON aclu.acl_id = acl.acl_id AND aclu.uid = 0 LEFT JOIN term_data catd ON t.tid = catd.tid WHERE ((fa.grant_view >= 1 AND fa.rid IN (, 1)) OR fa.tid IS NULL OR aclu.uid = 0) AND (t.tid IN (4, 0) OR catd.vid NOT IN (4)) AND ( r.nid = 6 ) ORDER BY v.weight, t.weight, t.name in /www/htdocs/*edited*/helden/includes/database.mysql.inc on line 167.
* 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 ' 1)) OR fa.tid IS NULL OR aclu.uid = 0) AND (t.tid IN (4, 0) OR query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid LEFT JOIN forum_access fa ON t.tid = fa.tid LEFT JOIN acl acl ON acl.name = t.tid AND acl.module = 'forum_access' LEFT JOIN acl_user aclu ON aclu.acl_id = acl.acl_id AND aclu.uid = 0 LEFT JOIN term_data catd ON t.tid = catd.tid WHERE ((fa.grant_view >= 1 AND fa.rid IN (, 1)) OR fa.tid IS NULL OR aclu.uid = 0) AND (t.tid IN (4, 0) OR catd.vid NOT IN (4)) AND ( r.nid = 4 ) ORDER BY v.weight, t.weight, t.name in /www/htdocs/*edited*/helden/includes/database.mysql.inc on line 167.

This message appears for users who are NOT logged in. Once I am logged in with whatever user, I get no error message.

Comments

chrischris’s picture

(Sorry, just saw that later in this http://drupal.org/node/104535 issue that same SQL bug is also addressed.)

merlinofchaos’s picture

Status: Active » Fixed

This is fixed in 1.4

thehong’s picture

I use ACL 5.x-1.3 and Forum Access 5.x-1.4, after installing and setting up configurations, I go to ?q=forum as a guest, I have an error:

--------------------------

Fatal error: Call to undefined function: user_access() in /home/toila/public_html/modules/forum_access/forum_access.module on line 298

--------------------------

merlinofchaos’s picture

This only happens if you have page caching turned on.

This is fixed in 1.5. Sorry about that.

Anonymous’s picture

Status: Fixed » Closed (fixed)