I'm hoping a SQL maven might be able to at least tell me what the error is here. I get this message when a user *other than* the admin (user 1) attempts to view the Group Forums of a group to which he is subscribed...
* 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 'SELECT x.tid FROM (SELECT ogt.tid FROM og_term ogt INNER JOIN o query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE (t.tid NOT IN (SELECT x.tid FROM (SELECT ogt.tid FROM og_term ogt INNER JOIN og_uid ogu ON ogt.nid = ogu.nid AND ogu.uid != 4) x WHERE x.tid NOT IN (SELECT ogt.tid FROM og_term ogt INNER JOIN og_uid ogu ON ogt.nid = ogu.nid AND ogu.uid = 4)) AND t.tid NOT IN (SELECT ogt.tid FROM og_term ogt INNER JOIN og_uid ogu ON ogt.nid = ogu.nid AND ogu.uid = 4 WHERE ogu.is_active = 0)) AND ( r.nid = 9 ) ORDER BY v.weight, t.weight, t.name in /hsphere/local/home/perideos/proto2.perideo.net/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 'SELECT x.tid FROM (SELECT ogt.tid FROM og_term ogt INNER JOIN o query: SELECT DISTINCT(t.tid), t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE (t.tid NOT IN (SELECT x.tid FROM (SELECT ogt.tid FROM og_term ogt INNER JOIN og_uid ogu ON ogt.nid = ogu.nid AND ogu.uid != 4) x WHERE x.tid NOT IN (SELECT ogt.tid FROM og_term ogt INNER JOIN og_uid ogu ON ogt.nid = ogu.nid AND ogu.uid = 4)) AND t.tid NOT IN (SELECT ogt.tid FROM og_term ogt INNER JOIN og_uid ogu ON ogt.nid = ogu.nid AND ogu.uid = 4 WHERE ogu.is_active = 0)) AND ( t.vid = 1 ) ORDER BY weight, name in /hsphere/local/home/perideos/proto2.perideo.net/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 'SELECT x.tid FROM (SELECT ogt.tid FROM og_term ogt INNER JOIN o query: SELECT DISTINCT(t.tid), t.* FROM term_data t INNER JOIN term_hierarchy h ON h.parent = t.tid WHERE (t.tid NOT IN (SELECT x.tid FROM (SELECT ogt.tid FROM og_term ogt INNER JOIN og_uid ogu ON ogt.nid = ogu.nid AND ogu.uid != 4) x WHERE x.tid NOT IN (SELECT ogt.tid FROM og_term ogt INNER JOIN og_uid ogu ON ogt.nid = ogu.nid AND ogu.uid = 4)) AND t.tid NOT IN (SELECT ogt.tid FROM og_term ogt INNER JOIN og_uid ogu ON ogt.nid = ogu.nid AND ogu.uid = 4 WHERE ogu.is_active = 0)) AND ( h.tid = 8 ) ORDER BY weight, name in /hsphere/local/home/perideos/proto2.perideo.net/includes/database.mysql.inc on line 172.
Any ideas?
Comments
Okay, I think I found the
Okay, I think I found the prob: I just noticed the note on the OG Forums module page that this module requires MySQL 5.x. My host is ver. 4.x.
I think I know what to do now - unless someone wants to rewrite those queries for me for 4.x...
-Eric
Hi Eric, Upgraded to mySQL
Hi Eric,
Upgraded to mySQL 5.x., does that work without problems?
Or do I run into other difficulties if I do so?
martin