forum index page lists db warnings
| Project: | Advanced Forum |
| Version: | 6.x-1.0-alpha2 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | duplicate |
Jump to:
Hello
I running postgres 8.1
i followed the instruction and it seems to be working so far other than this hideous output on the page that lists the forums:
* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "topic_author_id" at character 186 in /home/drupal-6.3/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 = 15 AND n.status = 1 ORDER BY n.created DESC LIMIT 1 OFFSET 0 in /home/drupal-6.3/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/drupal-6.3/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 = 14 AND n.status = 1 ORDER BY n.created DESC LIMIT 1 OFFSET 0 in /home/drupal-6.3/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/drupal-6.3/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 = 16 AND n.status = 1 ORDER BY n.created DESC LIMIT 1 OFFSET 0 in /home/drupal-6.3/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/drupal-6.3/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/drupal-6.3/modules/advanced_forum/advanced_forum.module on line 734.
I dont know what it all means :(

#1
and it doesn't look like its giving me "last post" info - just shows "n/a"
see it live at http://flywitness.com/forum
#2
http://drupal.org/node/271994