I am using Drupal 6.6 with og 6.x-1.0-rc6 and og_forum 6.x-1.0-beta1. When I click on the "Categories" tab page and "list terms", the following error display on screen:

user warning: Unknown column 'n.nid' in 'on clause' query: SELECT count(*) FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 12 AND na.realm = 'og_admin') OR (na.gid = 33 AND na.realm = 'og_admin') OR (na.gid = 15 AND na.realm = 'og_subscriber'))) AND ( t.vid = 100) in \modules\taxonomy\taxonomy.admin.inc on line 282.

I login with admin account and click on "list terms" under ../admin/content/taxonomy , there is no such error display. There is an unknown table column nid. Any idea?

Comments

amitaibu’s picture

amitaibu
Primary language Hebrew
Location Israel
CreditAttribution: amitaibu commented
Status: Active » Postponed (maintainer needs more info)

Please try with the latest DEV version - does it still happen?

nelsonlee’s picture

nelsonlee CreditAttribution: nelsonlee commented

After using the new dev version (Dec 26, 2008), another error occurs:

warning: Missing argument 3 for og_vocab_determine_access() in C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\sites\all\modules\og_vocab\og_vocab.module on line 451.

amitaibu’s picture

amitaibu
Primary language Hebrew
Location Israel
CreditAttribution: amitaibu commented

Let's try to catch the bug:
1) Try to rebuild_menu() (i.e. rebuild menu - use the devel module to do it).
2) Try to reproduce on a clean install.

jleonard’s picture

jleonard CreditAttribution: jleonard commented

Just in case:

Did you run update after installing the module?

Cheers!
Bill

nelsonlee’s picture

nelsonlee CreditAttribution: nelsonlee commented

After re-enable the og-vocab and run update, I enabled all the 4 permissions for authenticated users, and also enabled the "administer taxonomy" permission under taxonomy module.

With IE, Firefox and Chome, I used user1 and 2 different accounts to test it:

1. Only user1 is able to see the link "add vocabulary", which is under the sentience "Add or edit vocabularies that pertain only to this group. Each vocabulary will be shown on the post authoring form. Use categories to organize content within your group."

** I swaped the browsers, and make sure that this is not a browser cache problem.

2. When I clicked on "list terms", only non-user1 account display the original error message "user warning: Unknown column 'n.nid' in......"

3. Above #2 case error message "warning: Missing argument 3 for og_vocab_determine_access()......" is not seen.

Strange problem. Thanks for the quick reply.

amitaibu’s picture

amitaibu
Primary language Hebrew
Location Israel
CreditAttribution: amitaibu commented

1) is related to #352223: typo in og_vocab.admin.inc
3) When you create a new vocab, does it happen? Try changing the vocab for example from Multiple to Tags?

jleonard’s picture

jleonard CreditAttribution: jleonard commented

Seems to be fixed in the latest and greatest...