after i add a forum or user to a watch list i get this error when i try to select "my watch lists" link.
We encountered a problem. The reason reported was
Script: E:\www\markdriver\forums\scripts\tab_forums.inc.php
Line#: 113
SQL Error: 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 '' at line 8
SQL Error #: 1064
Query: select t.TOPIC_ID,t.POST_ID,t.USER_ID,t.TOPIC_SUBJECT,t.TOPIC_ICON,t.TOPIC_CREATED_TIME,u.USER_DISPLAY_NAME,t.TOPIC_LAST_REPLY_TIME,t.FORUM_ID from ubbt_TOPICS as t, ubbt_USERS as u where TOPIC_IS_APPROVED = '1' and t.USER_ID = u.USER_ID and t.FORUM_ID IN ( '1' ) order by t.TOPIC_LAST_REPLY_TIME desc limit
Last edited by Sirdude; 11/09/2007 2:02 AM.
