Hello all, i already made a post @ Announcements, consider it not posted, cause i think it has more to do with FA then with Announcements. (im still a bit new, but im learning Fast)
I already did some more trial n error on the subject and this is what ive figured out so far
I installled a clean system, enabled forum, installed ACL 5.x-1.x-dev
made a nice forum, etc, and then, i installed Announcements
host/announcements shows u a nice list with announcements, but as soon as i install FA, this happends :
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 'nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid ' at line 1 query: SELECT COUNT(*) FROM node n INNER JOIN announcements a ON n.nid = a.nid INNER JOIN node_access na ON na.nid = 1213892573.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'forum_access'))) AND ( n.type='announcements' AND a.expiration_date > 0 ) in /includes/database.mysql.inc on line 172.
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 'nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid ' at line 1 query: SELECT n.nid FROM node n INNER JOIN announcements a ON n.nid = a.nid INNER JOIN node_access na ON na.nid = 1213892573.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'forum_access'))) AND ( n.type='announcements' AND a.expiration_date > 0 ) ORDER BY n.sticky DESC, a.publish_date DESC LIMIT 0, 10 in /includes/database.mysql.inc on line 172.
when i try to remove FA the forum_access jumps back to node_access and Fails.
when u uninstall, still no solution, u just end up with a corrupted db.
so, clean install Drup5.7
enable forum
install acl (dev or stable)
install announcements (stable or previous versions), check if its working with the anonymous user (it will)
then install FA, reload the host/announcements page from a NOT authenticated user, u will see the above sql error.
logged in users have no problem @ all.
also tested it on acl 1.6, and others
and ive tried previous versions of FA
i can not get a combination of acl+fa+announce working with any of the mods versions.
more info available, running php5 / mysql5 / apache2
regards, Rob
ps, if u need more info, let me know, also if this is old news, please tell me (where and how to fix it / get the patch etc...)
and later tonight ill have more time to make a descent table of what is not working with what version and to dive into acl, and see what that does with the sql query.
ill also make a nice report with devel for every attempt i do, and make it available on my site.
Comments
Comment #1
rob c commentedplease take note of the post @ Announcements, http://drupal.org/node/272303
im closing this, cause it seems like its a Full announcements issue.
Comment #2
salvisThanks!