Mono 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.

Mono Support Problems with profile page 

Viewed 7999 time(s), 4 post(s). 12 month(s) agoby Schueychi
Schueychi
1

Schueychi 12 month(s) ago

Hi,

I'm new at this world of MonoX so any help will be very useful. I installed MonoX on my computer and translated some resources to my own language (Spanish) and everything goes fine in my local machine. We have contracted a hosting so we can have this version online. The thing is that in this online version, when you try to navigate to any user profile page it launches an error ("An error has occurred"). The hosting company installed MonoX on the server and then we uploaded the version as I said before, so we don't understand why the local version works fine and the other gives us problems.

Can it be a problem of setting security permissions during the instalation?

Thank you very much for your attention.

This content has not been rated yet. 
20 Reputation 2 Total posts
imarusic
2

imarusic 12 month(s) ago

Hi,

did you fulfill all the requirements before the installation?(worker process should have read/write permissions for web.config, Upload, ApplicationData...).

Did you check your MonoX logs to get more info regarding the error? Logs can be found in "/Portal/MonoX/ApplicationData/Logs/[yyyy-mm-dd]_MonoX.log" folder.

Regards.

This content has not been rated yet. 
2094 Reputation 272 Total posts
Schueychi
3

Schueychi 12 month(s) ago

Hi imarusic,

I think that all the requirements were fulfilled correctly. I've found this looking in the logs section:

2012-05-25 12:03:36,781 [11] ERROR MonoX [admin] - Error
SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException: An exception was caught during the execution of a retrieval query: El nombre de columna 'IsStickyPost' no es válido.
El nombre de columna 'StickyPostMadeOn' no es válido.
El nombre de columna 'StickyPostMadeByUserId' no es válido.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception. ---> System.Data.SqlClient.SqlException: El nombre de columna 'IsStickyPost' no es válido.
El nombre de columna 'StickyPostMadeOn' no es válido.
El nombre de columna 'StickyPostMadeByUserId' no es válido.
en System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
en System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
en System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
en System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
en System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
en System.Data.SqlClient.SqlDataReader.get_MetaData()
en System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
en System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
en System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
en System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
en System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
en System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
en System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
en SD.LLBLGen.Pro.ORMSupportClasses.RetrievalQuery.Execute(CommandBehavior behavior)
--- Fin del seguimiento de la pila de la excepción interna ---
en SD.LLBLGen.Pro.ORMSupportClasses.RetrievalQuery.Execute(CommandBehavior behavior)
en SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.ExecuteMultiRowRetrievalQuery(IRetrievalQuery queryToExecute, IEntityFactory2 entityFactory, IEntityCollection2 collectionToFill, IFieldPersistenceInfo[] fieldsPersistenceInfo, Boolean allowDuplicates, IEntityFields2 fieldsUsedForQuery)
en SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollectionInternal(IEntityCollection2 collectionToFill, IRelationPredicateBucket& filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, ExcludeIncludeFieldsList excludedIncludedFields, Int32 pageNumber, Int32 pageSize)
en SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields, Int32 pageNumber, Int32 pageSize)
en SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPrefetchPath2 prefetchPath, Int32 pageNumber, Int32 pageSize)
en MonoSoftware.LLBLGen.Repository.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPrefetchPath2 prefetchPath, Int32 pageNumber, Int32 pageSize)
en MonoSoftware.MonoX.Repositories.DiscussionRepository.GetMessages(Nullable`1 topicId, Nullable`1 userId, String searchPhrase, Int32 pageSize, Int32 pageIndex, Int32& recordCount)
en MonoSoftware.MonoX.Repositories.DiscussionRepository.GetMessages(Nullable`1 topicId, Nullable`1 userId, Int32 pageSize, Int32 pageIndex, Int32& recordCount)
en MonoSoftware.MonoX.ModuleGallery.SocialNetworking.DiscussionMessages.BindData()
en MonoSoftware.MonoX.Pages.SocialNetworking.UserProfile.Page_Init(Object sender, EventArgs e)
en System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
en System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
en System.EventHandler.Invoke(Object sender, EventArgs e)
en System.Web.UI.Control.OnInit(EventArgs e)
en System.Web.UI.Page.OnInit(EventArgs e)
en MonoSoftware.MonoX.BasePage.OnInit(EventArgs e)
en System.Web.UI.Control.InitRecursive(Control namingContainer)
en System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2012-05-25 12:03:36,796 [11] ERROR MonoX [admin] - Error
System.Threading.ThreadAbortException: Subproceso anulado.
en System.Threading.Thread.AbortInternal()
en System.Threading.Thread.Abort(Object stateInfo)
en System.Web.HttpResponse.End()
en MonoSoftware.MonoX.BasePage.OnError(EventArgs e)

This error about the "IsStickyPost" column not being valid seems to appear everytime I tried to visit the Profile page which is giving us problems. Is it possible??

Thanks!
This content has not been rated yet. 
20 Reputation 2 Total posts
khorvat
4

khorvat 12 month(s) ago

To be sure you will need to take a look at the database created on production server, so please take a look at the DiscussionMessages table and see if there is a IsStickyPost field exists.

Please check that and get back to us.

Regards
This content has not been rated yet. 
11571 Reputation 1648 Total posts