We are planning to upgrade to 6.x, but just found out there is no official 6.x release of taxonomy_access.module (TAC module). Looking at the issue queue, there is surprisingly not many requests for 6.x port, as I think this is pretty popular module. And the last CVS commit was 4 month ago, which is an indication I assume it's not being actively developed for now?
So does anyone use TAC 6.x-dev on your production site? Is 6.x-dev stable enough or are there other alternative modules we can use? (We need access control by taxonomy, not by node or by role. Thanks.)
Thank you everyone who helped me figure out the last database problem my site had but it appears I have another. I have tried the repair steps from the last time and that did not work but these errors are different. Any help is very much appreciated.
* 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 'IN ('42')) AND ((.tid NOT IN ('40','39') OR .tid IS NULL)) )' at line 1 query: SELECT count( DISTINCT(node.nid)) FROM node node LEFT JOIN content_field_odering_filed node_data_field_odering_filed ON node.vid = node_data_field_odering_filed.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'term_access'))) AND ( (.tid IN ('42')) AND ((.tid NOT IN ('40','39') OR .tid IS NULL)) ) in /home/kadimaso/public_html/denverdataman/includes/database.mysql.inc on line 174.
* 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 'IN ('42')) AND ((.tid NOT IN ('40','39') OR .tid IS NULL)) ) ORDER BY node_data' at line 1 query: SELECT DISTINCT(node.nid), node_data_field_odering_filed.field_odering_filed_value AS node_data_field_odering_filed_field_odering_filed_value FROM node node LEFT JOIN content_field_odering_filed node_data_field_odering_filed ON node.vid = node_data_field_odering_filed.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'term_access'))) AND ( (.tid IN ('42')) AND ((.tid NOT IN ('40','39') OR .tid IS NULL)) ) ORDER BY node_data_field_odering_filed_field_odering_filed_value ASC LIMIT 0, 10 in /home/kadimaso/public_html/denverdataman/includes/database.mysql.inc on line 174.
I am also getting:
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 'IN ('39')) LIMIT 0, 10' at line 1 query: SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed FROM node node WHERE (.tid IN ('39')) LIMIT 0, 10 in /home/kadimaso/public_html/denverdataman/includes/database.mysql.inc on line 174.
The site is Druapl 5.14.
Thanks, Steve
-
Jim Li -
skessler＠denverdataman.com