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.

Problems with profile page  (Mono Support )

Viewed 23059 time(s), 4 post(s) 6/4/2012 7:38:47 AMby Schueychi
Schueychi

Schueychi

6/4/2012 7:38:47 AM
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

imarusic

6/4/2012 7:57:45 AM
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. 
3016 Reputation 428 Total posts
Schueychi

Schueychi

6/4/2012 8:18:36 AM
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

khorvat

6/4/2012 9:20:04 PM
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. 
15993 Reputation 2214 Total posts