http://www.silverstripe.com/extending-hacking-silverstripe-forum/ http://www.silverstripe.com/extending-hacking-silverstripe-forum/show/74034?showPost=74559 Hi kiwifellows ;-) <br /> <br />might be this.. <br /> <br />http://www.silverstripe.com/bugs/flat/46658 <br /> <br /> <br />g <br /> Helmut<br><br>Posted to: Forum installed with db/build but then errored in administration Sat, 17 May 2008 22:30:05 +1200 Helmut Zörrer http://www.silverstripe.com/extending-hacking-silverstripe-forum/show/74034?showPost=74559 http://www.silverstripe.com/extending-hacking-silverstripe-forum/show/74034 I downloaded Forum (v0.1.2) and then installed OK and ran db/build. <br /> <br />Forum showed up in menu and was able to see it etc. <br /> <br />BUT. when I went to login to admin straight after adding the forum module I got the following error: <br />FATAL ERROR: DATABASE ERROR: Couldn't run query: SELECT `Post`.*, `Post`.ID, if(`Post`.ClassName,`Post`.ClassName,'Post') AS RecordClassName FROM `Post` INNER JOIN `Post` AS PostList ON PostList.TopicID = `Post`.TopicID WHERE (`Post`.ForumID = 41 and `Post`.ParentID = 0 and `Post`.Status = 'Moderated') GROUP BY `Post`.ID ORDER BY max(PostList.Created) DESC LIMIT 30 | Invalid use of group function <br />At line 397 in /var/www/sites/tools/silverstripe/sapphire/core/model/Database.php<br><br>Posted to: Forum installed with db/build but then errored in administration Fri, 16 May 2008 16:11:38 +1200 Ben Fellows http://www.silverstripe.com/extending-hacking-silverstripe-forum/show/74034