I have forum 5.2 and og_forum 5.x-2.1.

When I try to create new topic I have the following error :

    * user warning: Unknown column 't.tid' in 'IN/ALL/ANY subquery' query: SELECT COUNT(*) FROM term_data td WHERE (t.tid NOT IN (SELECT DISTINCT ogt.tid FROM og_term ogt)) in /home.10.22/website/www/includes/database.mysql.inc on line 172.
    * user warning: Unknown column 't.tid' in 'IN/ALL/ANY subquery' query: SELECT COUNT(*) FROM term_data td WHERE (t.tid NOT IN (SELECT DISTINCT ogt.tid FROM og_term ogt)) in /home.10.22/website/www/includes/database.mysql.inc on line 172.

The topic is created and when I add an answer to this new topic it works without any warning or error.
The issue only appears when creating a new topic.

I hope you could help me to solve this.

Regards,

Nicolas

Comments

Anonymous’s picture

Anonymous (not verified) commented

Hi Nicolas,

Are you still having problems with the latest 2.2 release ?

Paul

Anonymous’s picture

Anonymous (not verified) commented
Title: SQL Error with OG Forum » (More info) SQL Error with OG Forum
Anonymous’s picture

Anonymous (not verified) commented
Title: (More info) SQL Error with OG Forum » [More info] SQL Error with OG Forum
Anonymous’s picture

Anonymous (not verified) commented
Status: Active » Closed (fixed)
yktdan’s picture

yktdan commented
Title: [More info] SQL Error with OG Forum » SQL Error with OG Forum
Version: 5.x-2.1 » 5.x-2.2
Assigned: Nicolas_85 » Unassigned
Category: support » bug
Status: Closed (fixed) » Active

Unknown column 't.tid' in 'IN/ALL/ANY subquery' query: SELECT DISTINCT(td.tid), td.name, td.description, COUNT(tn.nid) as nodes FROM term_data td LEFT JOIN term_node tn USING(tid) WHERE (t.tid NOT IN (SELECT x.tid FROM (SELECT DISTINCT(ogt.tid) FROM og_term ogt INNER JOIN og_uid ogu ON ogt.nid = ogu.nid AND ogu.uid != 7 AND ogt.public < 2) x WHERE x.tid NOT IN (SELECT DISTINCT(ogt.tid) FROM og_term ogt INNER JOIN og_uid ogu ON ogt.nid = ogu.nid AND (ogt.public > 1 OR ogu.uid = 7))) AND t.tid NOT IN (SELECT DISTINCT(ogt.tid) FROM og_term ogt INNER JOIN og_uid ogu ON ogt.nid = ogu.nid AND ogu.uid = 7 WHERE ogu.is_active = 0)) AND ( td.vid=43 ) GROUP BY td.tid, td.name, td.description ORDER BY LENGTH(td.name) DESC in /home/nynjtcn/public_html/new.nynjtc.net/includes/database.mysql.inc on line 174.

There are three group forums and one public forum. One of the group forums has no entires yet.

This only happens for people with only authorized user permissions. Doesn't happen for uid=1, doesn't happen for people with various other roles that have more permissions than auth. user. Doesn't happen for someone not in any of the groups but does have more editing permissions than auth.user.

Anonymous’s picture

Anonymous (not verified) commented
Assigned: Unassigned »

Hello,

Just letting you know that i am no longer supporting Drupal 5 support requests but if you would migrate your installation to Drupal 6 . Ill be happy to provide some assistance.

Thanks Paul

Anonymous’s picture

Anonymous (not verified) commented
Status: Active » Closed (fixed)

Please reopen if this still a problem on the drupal 6 branch

Best, Paul