Hi Sebastian,
I think I found the problem in the code. I'm surprised it wasn't giving me an error. When I get home from work I will fix and recompile mojoPortal.Data.dll and post a link for you.
I think the probnlem is in the method:
public static DataSet PageSettings_GetPageTree(int SiteID)
{
...
sqlCommand.Append("INSERT INTO PageTree(PageID,PageName,ParentID,PageOrder,NestLevel,TreeOrder) ");
sqlCommand.Append("SELECT PageID,PageName,ParentID,PageOrder,0,1000000 + PageOrder ");
sqlCommand.Append("FROM mp_Pages ");
sqlCommand.Append("WHERE ParentID IS NULL OR ParentID = -1AND SiteID = @SiteID ");
sqlCommand.Append("ORDER BY PageOrder; ");
}
It should be like this:
sqlCommand.Append("WHERE (ParentID IS NULL OR ParentID = -1) AND SiteID = @SiteID ");
sqlCommand.Append("ORDER BY PageOrder; ");
It needs a space between the -1 and the "AND"
Best Regards,
Joe