Hello,
I've just installed MojoPortal ver. 2.3.1.9 FirebirdSql on Microsoft Windows Server 2003 SP2 and I have configured it to host multiple sites based on Folder names. First site is OK. On the second site I have a problems when I try to add function (ie HTML Content) to the site. This is the error in system log:
2009-09-29 16:58:10,675 ERROR mojoPortal.Web.Global - 94.36.221.135-it-IT - /Admin/SiteSettings.aspx?SiteID=2
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 150
LIMIT ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 150
LIMIT
--- Fine dell'analisi dello stack dell'eccezione interna ---
in FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
in mojoPortal.Data.FBSqlHelper.ExecuteNonQuery(FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters)
in mojoPortal.Data.FBSqlHelper.ExecuteNonQuery(String connectionString, String commandText, FbParameter[] commandParameters)
in mojoPortal.Data.DBSiteSettings.AddFeature(Guid siteGuid, Guid featureGuid)
in mojoPortal.Business.SiteSettings.AddFeature(Guid siteGuid, Guid featureGuid)
in mojoPortal.Web.AdminUI.SiteSettingsPage.btnAddFeature_Click(Object sender, EventArgs e)
in System.Web.UI.WebControls.Button.OnClick(EventArgs e)
in System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
in System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
in System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
in System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
in System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Seems to be an error in Firebird command...
Could you help me to solve the problem?
Thank you very much
Davide Morelli