MonoX support board

Start the conversation, ask questions and share tips and solutions with fellow developers.

Non-registered users can only browse through our support boards. Please register now if you want to post your questions. It takes a second and it is completely free. Alternatively, you can log in without registration using your credentials at major sites such as Google, Microsoft Live, OpenId, Facebook, LinkedIn or Yahoo.

Sitemap not working  (Mono Support )

Viewed 23194 time(s), 6 post(s) 2/28/2011 8:14:33 AMby peterg
peterg

peterg

2/28/2011 8:14:33 AM
Hi,
Im still going trough a lot of the things after the upgrade and an syced the web.config files from my old version to the new one, however i see the sitemap.ashx page is no longer working and i cant see anything in the log files.

is there anything ele i can have a look at.

Peter
This content has not been rated yet. 
246 Reputation 35 Total posts
peterg

peterg

2/28/2011 8:18:42 AM
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
This content has not been rated yet. 
246 Reputation 35 Total posts
denis

denis

2/28/2011 9:08:19 AM
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?
This content has not been rated yet. 
7207 Reputation 956 Total posts
peterg

peterg

2/28/2011 9:11:48 AM
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
This content has not been rated yet. 
246 Reputation 35 Total posts
denis

denis

2/28/2011 9:26:43 AM
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?
This content has not been rated yet. 
7207 Reputation 956 Total posts
peterg

peterg

2/28/2011 10:01:30 AM
Thanks Denis..you were right it seems the problem was between the keyboard and the chair..all it sorted for now.

Peter
This content has not been rated yet. 
246 Reputation 35 Total posts