Hi:
After a Kentico site upgrade to version 9 i was trying to open the board page in "Message Board", but the page throw the following error:
[UniGrid] : Error during reloading data.
On Event log page displays the following information related to the error:
Message: [SqlHelper.ReplaceOrderBy]: Missing ##ORDERBY## macro in the query text 'SELECT TOP 150 [BoardID], [BoardDisplayName], [BoardEnabled], [BoardModerated], [BoardMessages], [BoardLastMessageTime], [BoardDocumentID], [BoardOpened], [NodeID], [NodeSiteID], [DocumentNamePath], [DocumentCulture], [ClassName] FROM Board_Board
JOIN View_CMS_Tree_Joined ON (BoardDocumentID = DocumentID) AND (NodeLinkedNodeID IS NULL) AND ((BoardSiteID = 1)) AND ((BoardGroupID IS NULL OR BoardGroupID = 0))', cannot apply the specified order by 'BoardDisplayName ASC'.
Do you know any way to solve this error ?