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. (Zatvorena) (Mono Support )

39933 put(a) pogledan, 3 odgovor(a) 20.4.2014. 15:18:06Kreirao(la) Terfex
Terfex

Terfex

20.4.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.
Ovaj sadržaj još nije ocijenjen. 
71 Reputacija 7 Ukupno objava
Terfex

Terfex

21.4.2014. 6:48:26
Don't worry, fixed the issue with this post: 

Installaion Error by Dagon
Ovaj sadržaj još nije ocijenjen. 
71 Reputacija 7 Ukupno objava
khorvat

khorvat

22.4.2014. 8:21:13
Thanks for linking back, let us know if you have any further issues.
Ovaj sadržaj još nije ocijenjen. 
15993 Reputacija 2214 Ukupno objava