The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
Controller: Topic
Action: Active
Exception: Incorrect syntax near the keyword 'WHERE'.
Action: Active
Exception: Incorrect syntax near the keyword 'WHERE'.
Posted
odd, not erring now, strange
Posted
ran some tracing as I just got the error again, will dig out the code and find out why it has gone weird
looks like petapoco has done something odd with the count query for paging
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
Posted
note for self, It Appears to be related to groups
Posted
fixed here