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.

Some pages give an error even after applying SQL 2012 scripts.  (Mono Support )

27108 put(a) pogledan, 2 odgovor(a) 27.4.2014. 8:09:54Kreirao(la) Terfex

Povezane teme

Terfex

Terfex

27.4.2014. 8:09:54
I after applying the SQL scripts for SQL 2012, after getting these errors in this post, I'm still seeing some errors which appear to be SQL related as well.
Here's a few instances when the errors occur:

 - Accessing the Social Dashboard: /MonoX/Pages/SocialNetworking/Dashboard.aspx
Security error.
at MonoSoftware.MonoX.BasePage.OnInit(EventArgs e) at MonoSoftware.MonoX.Pages.SocialNetworking.Dashboard.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 - Accessing the site wall on the mobile site: /MonoX/Mobile/Wall.aspx
Object reference not set to an instance of an object.
at MonoSoftware.MonoX.ModuleGallery.SocialNetworking.Comments.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at MonoSoftware.MonoX.Utilities.MonoXUtility.RenderMonoXTemplate(Control templateContainer, StringBuilder sb, Hashtable tagObjectMappingCollection, VelocityContext velocityContext, VelocityEngine velocityEngine) at MonoSoftware.MonoX.BasePart.RenderTemplatedPart(Control templateContainer, String templateName, StringBuilder sb, Hashtable tagObjectMappingCollection, VelocityContext velocityContext, VelocityEngine velocityEngine) at MonoSoftware.MonoX.BasePart.RenderTemplatedPart(Control templateContainer, String templateName, String template, Hashtable tagObjectMappingCollection, VelocityContext velocityContext, VelocityEngine velocityEngine) at MonoSoftware.MonoX.BasePart.RenderTemplatedPart(Control templateContainer, String templateName, String template, Hashtable tagObjectMappingCollection, VelocityContext velocityContext) at MonoSoftware.MonoX.ModuleGallery.SocialNetworking.WallNotes.lvItems_OnItemDataBound(Object sender, ListViewItemEventArgs e) at System.Web.UI.WebControls.ListView.OnItemDataBound(ListViewItemEventArgs e) at System.Web.UI.WebControls.ListView.CreateItemsWithoutGroups(ListViewPagedDataSource dataSource, Boolean dataBinding, InsertItemPosition insertPosition, ArrayList keyArray) at System.Web.UI.WebControls.ListView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) at System.Web.UI.WebControls.ListView.PerformDataBinding(IEnumerable data) at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) at System.Web.UI.WebControls.DataBoundControl.PerformSelect() at System.Web.UI.WebControls.ListView.PerformSelect() at System.Web.UI.WebControls.BaseDataBoundControl.DataBind() at MonoSoftware.MonoX.Utilities.PagerUtility.BindPager(Pager pager, PagerAction bindDelegate, Control pagedControl, Object dataSource, Int32 pagerVirtualCount, Control warningControl) at MonoSoftware.MonoX.Utilities.PagerUtility.BindPager(Pager pager, PagerAction bindDelegate, Control pagedControl, Object dataSource, Int32 pagerVirtualCount) at MonoSoftware.MonoX.ModuleGallery.SocialNetworking.WallNotes.BindData() at MonoSoftware.MonoX.ModuleGallery.SocialNetworking.WallNotes.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 - Accessing Messages: /MonoX/Pages/SocialNetworking/InMail.aspx
Security error.
at MonoSoftware.MonoX.BasePage.OnInit(EventArgs e) at MonoSoftware.MonoX.Pages.SocialNetworking.InMail.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 - Viewing your friends list: profile-friends/(user's name)/
An exception was caught during the execution of a retrieval query: Could not find stored procedure 'dbo.FriendSuggestion'.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.
at SD.LLBLGen.Pro.ORMSupportClasses.RetrievalQuery.Execute(CommandBehavior behavior) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchDataReader(IRetrievalQuery queryToExecute, CommandBehavior readerBehavior) at MonoSoftware.MonoX.Repositories.UserRepository.GetUserConnectionTypedViewEntries(Guid userId, String searchTerm, Boolean isRandom, Int32 numberOfLevels, Int32 pageNumber, Int32 pageSize, Int32& recordCount) at MonoSoftware.MonoX.ModuleGallery.SocialNetworking.FriendSuggestionsList.BindData() at MonoSoftware.MonoX.Pages.Profile.MyFriends.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Could not find stored procedure 'dbo.FriendSuggestion'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at SD.LLBLGen.Pro.ORMSupportClasses.RetrievalQuery.Execute(CommandBehavior behavior)
 - Submitting a wall post both on my own and another user's
This event has been logged and will be addressed by the maintenance department. We appreciate your patience.To continue working with the application please click here
 - Submitting a comment.
This event has been logged and will be addressed by the maintenance department. We appreciate your patience.To continue working with the application please click here
 - Sending a message from the contact form results in no message sent.

It seems some script needs to be run for the social networking side but I can't seem to find where the script is.
Ovaj sadržaj još nije ocijenjen. 
71 Reputacija 7 Ukupno objava
khorvat

khorvat

28.4.2014. 8:43:32
Hi,

  can you please let us know if you have upgraded only runtime assemblies (bin folder) or did you upgrade your markup too ?

- All security errors aren't related to upgrade or SQL scripts but to currently authenticated user so please check if you have permissions in MonoX administration -> Page Management.
- "It seems some script needs to be run for the social networking side but I can't seem to find where the script is." MonoX comes with the upgrade scripts that can be used to upgrade your database to the latest version. You can find the scripts in the /MonoX/Installer/Sql/UpgradeScripts (exceptions like this one "Could not find stored procedure 'dbo.FriendSuggestion'." will be resolved by upgrading)
- for the rest of the issues can you please provide us with the MonoX log files "/MonoX/ApplicationData/Logs"

Regards
Ovaj sadržaj još nije ocijenjen. 
15993 Reputacija 2214 Ukupno objava