First, I really appreciate how nicely this user interface works! And I do know that not everyone runs Taxonomy Access Control :) I thought you might find this useful feedback for just that reason.

Unless I provide anonymous users access to create flashnodes, the following errors are reliably reproducible on the flashnodes AND the homepage.
user warning: Unknown column 'grant_create' in 'where clause' query: SELECT COUNT(*) FROM node_access WHERE (nid = 0 OR nid = 0) AND ((gid = 0 AND realm = 'all') OR (gid = 1 AND realm = 'term_access')) AND grant_create >= 1 in /www/drupal/includes/database.mysql.inc on line 172.

Once I allow permission to create flashnodes, then the error disappears. It's safe to say that this client wouldn't be running TAC (with workflow) if they wanted anonymous users to submit flash content ;)

Comments

Stuart Greenfield’s picture

Stuart Greenfield commented
Status: Active » Postponed (maintainer needs more info)

I installed taxonomy access and it isn't causing me a problem (although neither is TAC itself working properly - I can't create pemissions for anyone other than anonymous users!). But I don't get any errors with flash node.

I will check further, but on the face of it this might not be flash node. Flash node doesn't do anything about permissions - it relies on other modules to do that.

Thinking out loud, the table node_access, which controls access permissions, doesn't include a column grant_create (at least, not a clean installation) so that is probably why the SQL is failing. But that begs the question what is generating the SQL in the first place! It isn't coming from flash node (but it's curious that letting anonymous users create flash nodes makes the error go away!)

Which version of TAC and Drupal core are you using as at the moment I can't create this error, and am very puzzled! Are you using any other access control modules?

eliza411’s picture

eliza411 commented

Again, I apologize for not including the version information. I was using flashnode to upload screencasts just prior to a big rollout. I'm using the recommended 5.x-2.x-dev with drupal 5.7. It's a few more days until I can return to troubleshooting this, but when I do we can probably give you access to a development copy so you can see it in action. I wouldn't expect *anyone* to configure TAC just to troubleshoot!