Copied to clipboard

Flag this post as spam?

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


  • Robert Ghafoor 33 posts 95 karma points
    Sep 30, 2015 @ 12:53
    Robert Ghafoor
    0

    Upgrade to 1.12 from 1.11 db error

    Hey

    Im trying to upgrade merchello but im getting this error:

    Violation of PRIMARY KEY constraint 'PK_merchStoreSetting'. Cannot insert duplicate key in object 'dbo.merchStoreSetting'. The duplicate key value is (292e477b-e39a-4b8b-9865-334eee850fd7). The statement has been terminated.

    Beskrivning: Ett undantag som inte kunde hanteras uppstod när den aktuella webbegäran kördes. Mer information om felet och var i koden det uppstod finns i stackspårningen.

    Undantagsinformation: System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_merchStoreSetting'. Cannot insert duplicate key in object 'dbo.merchStoreSetting'. The duplicate key value is (292e477b-e39a-4b8b-9865-334eee850fd7). The statement has been terminated.

    Källfel:

    Ett undantag som inte hanteras genererades vid körningen av den aktuella webbegäran. Information om undantagets ursprung och plats kan identifieras med undantagsstackspårningen nedan.

    Stackspårning:

    [SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PKmerchStoreSetting'. Cannot insert duplicate key in object 'dbo.merchStoreSetting'. The duplicate key value is (292e477b-e39a-4b8b-9865-334eee850fd7). The statement has been terminated.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) +388 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +717 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4515 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61 System.Data.SqlClient.SqlDataReader.get_MetaData() +134 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6557689 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +6560327 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +586 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +104 System.Data.SqlClient.SqlCommand.ExecuteScalar() +270 StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteScalar() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:299 Umbraco.Core.Persistence.<>cDisplayClassa.9() +159 Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction(Func1 func) +545 Umbraco.Core.Persistence.Database.Insert(String tableName, String primaryKeyName, Boolean autoIncrement, Object poco) +2877 Umbraco.Core.Persistence.Database.Insert(String tableName, String primaryKeyName, Object poco) +17 Merchello.Core.Persistence.Migrations.Upgrades.TargetVersionOneTwelveZero.InsertNewMerchelloSettingDefaultExtendedContentCulture.Up() +470 Umbraco.Core.Persistence.Migrations.MigrationRunner.InitializeMigrations(List1 migrations, Database database, DatabaseProviders databaseProvider, Boolean isUpgrade) +327 Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade) +337 Merchello.Core.Persistence.Migrations.CoreMigrationManager.UpgradeMerchello(Database database) +1114 Merchello.Core.Persistence.Migrations.CoreMigrationManager.EnsureMerchelloVersion() +159 Umbraco.Core.CoreBootManager._11(IApplicationEventHandler x) +160 Umbraco.Core.EnumerableExtensions.ForEach(IEnumerable1 items, Action1 action) +148 Umbraco.Core.CoreBootManager.Complete(Action1 afterComplete) +349 Umbraco.Web.WebBootManager.Complete(Action1 afterComplete) +95 Umbraco.Core.UmbracoApplicationBase.StartApplication(Object sender, EventArgs e) +370

    [HttpException (0x80004005): Violation of PRIMARY KEY constraint 'PK_merchStoreSetting'. Cannot insert duplicate key in object 'dbo.merchStoreSetting'. The duplicate key value is (292e477b-e39a-4b8b-9865-334eee850fd7). The statement has been terminated.] System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +12601645 System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +175 System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +304 System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +404 System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +475

    [HttpException (0x80004005): Violation of PRIMARY KEY constraint 'PK_merchStoreSetting'. Cannot insert duplicate key in object 'dbo.merchStoreSetting'. The duplicate key value is (292e477b-e39a-4b8b-9865-334eee850fd7). The statement has been terminated.] System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +12618692 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +159 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +12458309

    Downloaded the Merchello.1.12.0_upgrade.zip and followed the instruktions.

  • Rusty Swayne 1655 posts 4993 karma points c-trib
    Sep 30, 2015 @ 15:03
    Rusty Swayne
    0

    @robert -

    Verify that you have two new tables:

    merchDetachedContentType and merchProductVariantDetachedContent.

    If you do, set the app setting

    merchelloConfigurationStatus to "1.12.0"

    If you don't, delete the record from the merchStoreSetting table with pk = ' 292e477b-e39a-4b8b-9865-334eee850fd7' leaving the merchelloConfigurationStatus = 1.11.0 and refresh the browser.

  • David Peck 687 posts 1863 karma points c-trib
    Dec 21, 2015 @ 12:56
    David Peck
    0

    I know you never got a response from Robert, but I have what looks to be the same issue.

    I upgraded from 1.6 and ran the manual SQL script for 1.7 to 1.8 when I initially got an issue. Now the config status keeps moving to 1.13.2 but I get a YSOD: "Invalid object name 'merchProductVariantDetachedContent'."

  • David Peck 687 posts 1863 karma points c-trib
    Dec 21, 2015 @ 13:27
    David Peck
    0

    Actually I've managed to sort this but setting the configStatus to 1.10.

Please Sign in or register to post replies

Write your reply to:

Draft