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.

Potential SQL issues. (Closed) (Mono Support )

Viewed 36869 time(s), 3 post(s) 4/20/2014 3:18:06 PMby Terfex
Terfex

Terfex

4/20/2014 3:18:06 PM
Hi,

I've recently moved my Monox Installation from an old Godaddy Server to one of their new Windows Plesk Servers. However I can't seem to get the site to run on the new server. The old server had SQL 2008 and IIS 7.0. The new server has IIS 8.0 and SQL 2012. I have managed to get the site to run on my development PC with IIS 8.0 and SQL 2012. GoDaddy support have looked extensively and conclude it's an SQL issue. I have been using SQL Management Studio to upload my working local database to their server which looks ok until I try to load the site. I have noticed the collations of my local Database and GoDaddy's is different however.

This is the error I get:
This event has been logged and will be addressed by the maintenance department. We appreciate your patience.

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at System.Web.Util.SecUtility.CheckSchemaVersion(ProviderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) at System.Web.UI.WebControls.WebParts.SqlPersonalizationProvider.CheckSchemaVersion(SqlConnection connection) at System.Web.UI.WebControls.WebParts.SqlPersonalizationProvider.LoadPersonalizationBlobs(WebPartManager webPartManager, String path, String userName, Byte[]& sharedDataBlob, Byte[]& userDataBlob) at MonoSoftware.MonoX.VersionedPersonalizationProvider.LoadPersonalizationBlobs(WebPartManager wpm, String path, String userName, Byte[]& sharedDataBlob, Byte[]& userDataBlob) at System.Web.UI.WebControls.WebParts.PersonalizationProvider.LoadPersonalizationState(WebPartManager webPartManager, Boolean ignoreCurrentUser) at System.Web.UI.WebControls.WebParts.WebPartPersonalization.Load() at System.Web.UI.WebControls.WebParts.WebPartPersonalization.LoadInternal() at System.Web.UI.WebControls.WebParts.WebPartManager.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Please let me know if I need to provide more info.
This content has not been rated yet. 
71 Reputation 7 Total posts
Terfex

Terfex

4/21/2014 6:48:26 AM
Don't worry, fixed the issue with this post: 

Installaion Error by Dagon
This content has not been rated yet. 
71 Reputation 7 Total posts
khorvat

khorvat

4/22/2014 8:21:13 AM
Thanks for linking back, let us know if you have any further issues.
This content has not been rated yet. 
15993 Reputation 2214 Total posts