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 40209 time(s), 3 post(s) 20.04.2014 15:18:06by Terfex
Terfex

Terfex

20.04.2014 15:18:06
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.
Dieser Inhalt wurde noch nicht bewertet. 
71 Reputation 7 Total posts
Terfex

Terfex

21.04.2014 06:48:26
Don't worry, fixed the issue with this post: 

Installaion Error by Dagon
Dieser Inhalt wurde noch nicht bewertet. 
71 Reputation 7 Total posts
khorvat

khorvat

22.04.2014 08:21:13
Thanks for linking back, let us know if you have any further issues.
Dieser Inhalt wurde noch nicht bewertet. 
15993 Reputation 2214 Total posts