forum index page lists db warnings

flywitness - July 26, 2008 - 17:35
Project:Advanced Forum
Version:6.x-1.0-alpha2
Component:Code
Category:support request
Priority:normal
Assigned:Unassigned
Status:duplicate
Description

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

flywitness - July 26, 2008 - 17:46

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

Michelle - July 31, 2008 - 21:33
Status:active» duplicate

http://drupal.org/node/271994

 
 

Drupal is a registered trademark of Dries Buytaert.