Ok i switched off the custom error page and got to this..seems like a DB table name that is missing or something - please can you assist


Server Error in '/' Application.


Invalid column name 'AdminAttentionReportedByUserId'.
Invalid column name 'AdminAttentionReportedOn'.
Invalid column name 'AdminAttentionApproved'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'AdminAttentionReportedByUserId'.
Invalid column name 'AdminAttentionReportedOn'.
Invalid column name 'AdminAttentionApproved'.

Source Error:





An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:





[SqlException (0x80131904): Invalid column name 'AdminAttentionReportedByUserId'.
Invalid column name 'AdminAttentionReportedOn'.
Invalid column name 'AdminAttentionApproved'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1953274
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849707
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +96
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10
SD.LLBLGen.Pro.ORMSupportClasses.RetrievalQuery.Execute(CommandBehavior behavior) +86

[ORMQueryExecutionException: An exception was caught during the execution of a retrieval query: Invalid column name 'AdminAttentionReportedByUserId'.
Invalid column name 'AdminAttentionReportedOn'.
Invalid column name 'AdminAttentionApproved'.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.]
SD.LLBLGen.Pro.ORMSupportClasses.RetrievalQuery.Execute(CommandBehavior behavior) +224
SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.ExecuteMultiRowRetrievalQuery(IRetrievalQuery queryToExecute, IEntityFactory2 entityFactory, IEntityCollection2 collectionToFill, IFieldPersistenceInfo[] fieldsPersistenceInfo, Boolean allowDuplicates, IEntityFields2 fieldsUsedForQuery) +146
SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollectionInternal(IEntityCollection2 collectionToFill, IRelationPredicateBucket& filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, ExcludeIncludeFieldsList excludedIncludedFields, Int32 pageNumber, Int32 pageSize) +714
SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields, Int32 pageNumber, Int32 pageSize) +126
SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPrefetchPath2 prefetchPath) +28
MonoSoftware.LLBLGen.Repository.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPrefetchPath2 prefetchPath) +59
MonoSoftware.MonoX.Repositories.DiscussionRepository.#aQ(List`1 boardIds) +1053
MonoSoftware.MonoX.Repositories.DiscussionRepository.GetBoards(List`1 roleIds, List`1 filterBoardIds, Nullable`1 snGroupId, String searchPhrase, Int32 pageSize, Int32 pageIndex, Int32& recordCount) +2112
MonoSoftware.MonoX.Repositories.DiscussionRepository.GetBoards(List`1 roleIds, List`1 filterBoardIds, Nullable`1 snGroupId, Int32 pageSize, Int32 pageIndex, Int32& recordCount) +61
MonoSoftware.MonoX.SiteMap.SiteMap.GetSiteUrlCollection(UrlCollection urlCollection) +5811
MonoSoftware.MonoX.SiteMap.SiteMap.ProcessRequest(HttpContext context) +53
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +181
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

Hi Peter,
You are right, it appears that you didn't run the database scripts. Could you please let us know what was the original version number so we could send you the scripts?

Hi Denis,
The original version was 3.2.1798.35
I ran all the scripts offline and if I remember correctly they all went trough. thanks again for the great support.

Peter

Hi Peter,
Did you use scripts from the folder /MonoX/Installer/Sql/UpgradeScripts/? The error message that you are getting indicates that scripts for the early upgrade (3.2.1828.35) were not run successfuly. Do you want us to check the installation through the TeamViewer remote admin session?