Hi Gemini Support Team,

I have just upgraded Gemini from 4.2 to 5.1 and when i try to check the system log, nothing is displayed, however, when i check the Gemini database in the server, there are entries in the systemlog table. I looked around for any possible solution and found this question has a similar problem:

http://community.geminiplatform.com/questions/4703/error-when-access-to-system-log-tab/

Similarly, in my systemlog table, there is an entry that writes:

could not execute query [ SELECT this.srn as srn240, this.messagetype as messaget2240, this.messagesource as messages3240, this.logmessage as logmessage240, this.username as username240, this.created as created240 FROM geminisystemlog this ORDER BY this.srn desc ] [SQL: SELECT this.srn as srn240, this.messagetype as messaget2240, this.messagesource as messages3240, this.logmessage as logmessage240, this.username as username240, this.created as created240_ FROM geminisystemlog this ORDER BY this_.srn desc] NHibernate at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Criteria.CriteriaLoader.List(ISessionImplementor session) at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) at NHibernate.Impl.CriteriaImpl.List(IList results) at NHibernate.Impl.CriteriaImpl.ListT at Countersoft.Foundation.Data.Repository2.FindAll(Order order) at Countersoft.Gemini.Data.System.SystemMessageRepository.GetAll() at Countersoft.Gemini.Models.Admin.SystemSystemLogModelBuilder.GetModel() at Countersoft.Gemini.Controllers.Ajax.AjaxAdminController.GetPage(String tab, String subTab) at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass37.<>cDisplayClass39.b33() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass4f.b49() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass4f.b49() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass37.b36(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass25.<>cDisplayClass2a.b20() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass25.b22(IAsyncResult asyncResult) at System.Web.Mvc.Controller.<>cDisplayClass1d.b18(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.<>cDisplayClass4.b3(IAsyncResult ar) at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.<>cDisplayClass4.b3(IAsyncResult ar) at System.Web.Mvc.MvcHandler.<>cDisplayClass8.b3(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.<>cDisplayClass4.b3(IAsyncResult ar) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Can you help me solve the problem? Thank you in advance.