I have 2 portals on my DNN setup, the main forum on the main portal works jsut fine.  The 2nd portal with a forum module attached gets this error when trying to load the page.  It used to work.  Looks like an order by or something is messing up.  Whats happeneing?

InnerException: Incorrect syntax near the keyword 'BY'.
Message: DotNetNuke.Services.Exceptions.PageLoadException: Incorrect syntax near the keyword 'BY'. ---> System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'BY'. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Forum.SqlDataProvider.WhatsNewGetAll(Int32 ModuleID, Int32 NumberOfThread, Int32 UserID, DateTime FromDate, DateTime ToDate, String Filter) at DotNetNuke.Modules.Forum.WhatsNewController.WhatsNewGetAll(Int32 ModuleID, Int32 NumberOfThread, Int32 UserID, DateTime FromDate, DateTime ToDate, String Filter) at DotNetNuke.Modules.Forum.WhatsNewCollection.PopulateCollection() at DotNetNuke.Modules.Forum.WhatsNewCollection..ctor(Int32 ModuleID, Int32 TrackedDuration, ForumUser User) at DotNetNuke.Modules.Forum.WhatsNewCollection.GetCollection(Int32 ModuleID, Int32 TrackedDuration, ForumUser User) at DotNetNuke.Modules.Forum.Groups.RenderWhatsNew(HtmlTextWriter wr) at DotNetNuke.Modules.Forum.Groups.RenderInfoContent(HtmlTextWriter wr) at DotNetNuke.Modules.Forum.Groups.Render(HtmlTextWriter wr) at DotNetNuke.Modules.Forum.ForumBaseControl.Render(HtmlTextWriter wr) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at _ASP.Forum_Container_ascx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at DotNetNuke.Entities.Modules.PortalModuleBase.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer) at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer) at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at ASP.Default_aspx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at DotNetNuke.Framework.PageBase.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain() --- End of inner exception stack trace ---
StackTrace:

It has something to do with the What's New. I am guessing there is a module setting not present, not sure.

Nick,

I haven't tested the forums much in the multi-portal enviroment to be honest. Not certain of the error, do you happen to be accessing it with host when this happens? Does it happen to every single user?