Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Flavio Spezi 129 posts 315 karma points
    Jul 06, 2016 @ 15:57
    Flavio Spezi
    0

    How to Upgrade from Merchello 1.8.3 to 2.1.0?

    How can I upgrade Merchello from 1.8.3 to 2.1.0?

    I try to do it with this step:

    • upgrade Umbraco from 7.2 to last Umbraco 7.4.3
    • re-install Merchello 2.1.0

    After some issue I have Umbraco that run, but Merchello Backoffice returns exception:

       ERROR Umbraco.Core.Persistence.UmbracoDatabase - Database exception occurred
    System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'merchEntityCollection'.
       at System.Data.SqlClient.SqlConnection.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, Boolean describeParameterEncryptionRequest)
       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 StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass4.<ExecuteReaderWithRetry>b__3()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       at Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext()
    
  • Rusty Swayne 1655 posts 4993 karma points c-trib
    Jul 06, 2016 @ 16:56
    Rusty Swayne
    0

    Hey Flavio,

    You should not re-install Merchello. Just overwrite the dlls and the App_Plugins folder. Be careful with the Merchello.config file if you've made any custom configurations.

  • Flavio Spezi 129 posts 315 karma points
    Jul 07, 2016 @ 08:23
    Flavio Spezi
    0

    Thanks!

    I do not know where to get bin + App_Plugins/Merchello* folders of 2.1.0 version. Then I do this:

    • backup current broken website (Umbraco 7.4.3 + Merchello 2.10).
    • rollback to Umbraco 7.2 + Merchello 1.8.3.
    • upgrade Umbraco to 7.4.3: website works.
    • update bin and App_Plugins/Merchello* folders of website with backed files.
    • refresh Umbraco Backoffice.

    Now I look inside web.config that merchelloConfigurationStatus is changed to 2.1.0.

    Unfortunatelly I receive the same issue. I think that DB is not updated because there are not a table with the name "merchEntityCollection".

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies