Hi,

Fris of all thanks for this mangific work!! its a really really nice module :)

I'm using it in drupal 6.3 with datebase postgresql 8.1.11 and after adding some containers and forums when i go to ?q=forum to visualize it appears the following error:



    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "topic_author_id" at character 186 in /home/torrevis/public_html/torrevista/includes/database.pgsql.inc on line 138.
    * user warning: query: SELECT n.nid AS topic_id, n.title AS topic_title, n.created AS topic_timestamp, n.type AS topic_type, n.uid topic_author_id, u.name AS topic_author_name FROM node n INNER JOIN term_node tn on n.nid = tn.nid INNER JOIN users u on n.uid = u.uid WHERE tn.tid = 1 AND n.status = 1 ORDER BY n.created DESC LIMIT 1 OFFSET 0 in /home/torrevis/public_html/torrevista/modules/advanced_forum/advanced_forum.module on line 734.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "topic_author_id" at character 186 in /home/torrevis/public_html/torrevista/includes/database.pgsql.inc on line 138.
    * user warning: query: SELECT n.nid AS topic_id, n.title AS topic_title, n.created AS topic_timestamp, n.type AS topic_type, n.uid topic_author_id, u.name AS topic_author_name FROM node n INNER JOIN term_node tn on n.nid = tn.nid INNER JOIN users u on n.uid = u.uid WHERE tn.tid = 2 AND n.status = 1 ORDER BY n.created DESC LIMIT 1 OFFSET 0 in /home/torrevis/public_html/torrevista/modules/advanced_forum/advanced_forum.module on line 734.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "topic_author_id" at character 186 in /home/torrevis/public_html/torrevista/includes/database.pgsql.inc on line 138.
    * user warning: query: SELECT n.nid AS topic_id, n.title AS topic_title, n.created AS topic_timestamp, n.type AS topic_type, n.uid topic_author_id, u.name AS topic_author_name FROM node n INNER JOIN term_node tn on n.nid = tn.nid INNER JOIN users u on n.uid = u.uid WHERE tn.tid = 3 AND n.status = 1 ORDER BY n.created DESC LIMIT 1 OFFSET 0 in /home/torrevis/public_html/torrevista/modules/advanced_forum/advanced_forum.module on line 734.

if I enter to the container it appears only twice, and entreing in a forum doesn't appear any error message.

If there are some information that I don't posted and you need ask me!

thanks for all!

Comments

michelle’s picture

Status: Active » Fixed

That code doesn't exist anymore.

Michelle

quiron’s picture

Ok, thanks a lot Michelle!

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.