Active Topic error?

Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/71248?pagenum=1
05 November 2025, 00:07

Topic


HuwR
Active Topic error?
20 November 2017, 13:17


Controller: Topic
Action: Active
Exception: Incorrect syntax near the keyword 'WHERE'.

 

Replies ...


HuwR
20 November 2017, 21:46


odd, not erring now, strange
HuwR
22 November 2017, 09:25


ran some tracing as I just got the error again, will dig out the code and find out why it has gone weird

Code:

exec sp_executesql N'SELECT  COUNT(*) FROM FORUM_TOPICS t LEFT JOIN FORUM_FORUM Forum ON t.FORUM_ID = Forum.FORUM_ID LEFT JOIN FORUM_MEMBERS a ON a.MEMBER_ID = t.T_AUTHOR LEFT JOIN FORUM_MEMBERS lpa ON lpa.MEMBER_ID = t.T_LAST_POST_AUTHOR WHERE (T_STATUS < 99 OR T_AUTHOR=@0 OR T_UREPLIES>0)AND ( t.T_LAST_POST>''20171122091836'')ORDER BY T_LAST_POST DESCWHERE (t.CAT_ID IN(2,6,5,4,10,1,14,17,7,9))',N'@0 int',@0=1311
go
looks like petapoco has done something odd with the count query for paging
HuwR
22 November 2017, 09:27


note for self, It Appears to be related to groups
HuwR
22 November 2017, 18:54


fixed here
© 2000-2021 Snitz™ Communications