Sign in Register
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 128 posts 314 karma points
    Jul 06, 2016 @ 15:57
    Flavio Spezi
    0

    How to Upgrade from Merchello 1.8.3 to 2.1.0?

    Merchello

    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()
    Copy Link
  • 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.

    Copy Link
  • Flavio Spezi 128 posts 314 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".

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft