Copied to clipboard

Flag this post as spam?

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


  • surabhika 3 posts 33 karma points
    Jul 19, 2022 @ 09:57
    surabhika
    0

    Plumber v10

    I am using Umraco 10 and have installed Plumber v10. I am struggling to make this combination work. This is the error after installing Plumber via Nuget. enter image description here

    Thanks in advance!

  • Nathan Woulfe 447 posts 1664 karma points MVP 5x hq c-trib
    Jul 19, 2022 @ 10:17
    Nathan Woulfe
    0

    Looks like the app plugins folder is missing... Did you try rebuilding after installing? That should copy the backoffice assets.

  • surabhika 3 posts 33 karma points
    Jul 19, 2022 @ 10:27
    surabhika
    0

    I rebuilt and have the app plugin folder. But just seen the logs and looks like an issue with database.

    enter image description here

    I look into it and come back.

    Ohh and thanks for the quick reply!

  • Nathan Woulfe 447 posts 1664 karma points MVP 5x hq c-trib
    Jul 19, 2022 @ 10:35
    Nathan Woulfe
    0

    That looks like the installation migration didn't run. Is this a new v10 site or an upgraded V9?

    I'd try deleting the Plumber entry from the UmbracoKeyValue table and restarting the site. That should rerun the migrations.

  • surabhika 3 posts 33 karma points
    Jul 19, 2022 @ 13:51
    surabhika
    0

    Hi Nathan,

    It's a new v10. I don't seem to have Plumber entry in UmbracoKeyValue table? I feel like I am missing a step or something.. Here are some error screenshot.

    This is the error on group save This is the error on group save

    Thats the logs Thats the logs

    and this is the UmbracoKeyValue table content enter image description here

  • Nathan Woulfe 447 posts 1664 karma points MVP 5x hq c-trib
    Jul 20, 2022 @ 01:13
    Nathan Woulfe
    100

    Hey surabhika, this was due to some ugly stuff in the Plumber installer not working nicely on SqlLite. I'm not sure how I managed to install locally in my release testing, but that's beside the point.

    I believe I've fixed the issue, it's building now. I'll tag and release a v10.0.1-beta, if you could then try installing and let me know how you get on.

  • Andrew Bright 84 posts 244 karma points
    May 16, 2023 @ 12:53
    Andrew Bright
    0

    Just to add this I am on Umbraco v10.4.0 and migrating Plumber 10.0.1 to Umbraco workflow 10.0.0

    So I have followed this process https://docs.umbraco.com/umbraco-workflow/v/10.workflow.latest-lts/upgrading-workflow/upgrading/migrating-workflow as I am looking to migrate and getting SQL exception all over the place: enter image description here

    enter image description here

  • Andrew Bright 84 posts 244 karma points
    May 16, 2023 @ 19:47
    Andrew Bright
    0

    Okay so some progress I have managed to resolve the issue with WorkflowContentReviewNodes with the below INSERT scripts

    SET ANSI_NULLS ON
    GO
    
    SET QUOTED_IDENTIFIER ON
    GO
    
    CREATE TABLE [dbo].[WorkflowContentReviewNodes](
        [Id] [int] IDENTITY(1,1) NOT NULL,
        [NodeId] [int] NULL,
        [ReviewedOn] [datetime] NULL,
        [DueOn] [datetime] NULL,
        [ReviewedBy] [int] NULL,
        [Variant] [nvarchar](255) NULL,
     CONSTRAINT [PK_WorkflowContentReviewNodes] PRIMARY KEY CLUSTERED 
    (
        [Id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    GO
    

    And

    SET ANSI_NULLS ON
    GO
    
    SET QUOTED_IDENTIFIER ON
    GO
    
    CREATE TABLE [dbo].[WorkflowContentReviewConfig](
        [Id] [int] IDENTITY(1,1) NOT NULL,
        [NodeId] [int] NULL,
        [ContentTypeId] [int] NULL,
        [Period] [int] NULL,
        [GroupIds] [nvarchar](255) NULL,
        [Exclude] [bit] NULL,
        [Variant] [nvarchar](255) NULL,
     CONSTRAINT [PK_WorkflowContentReviewConfig] PRIMARY KEY CLUSTERED 
    (
        [Id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    GO
    
  • Andrew Bright 84 posts 244 karma points
    May 16, 2023 @ 21:48
    Andrew Bright
    0

    So the remaining type issue enter image description here

    appears to be with the WorkflowSettings table I had to first remove these redundant columns:

    --ALTER TABLE [dbo].[WorkflowSettings]
    --DROP COLUMN [DefaultApprover], [Email], [EditUrl], [SiteUrl], [SendNotifications], [ExcludeNodes], [LockIfActive], [AllowAttachments], [RequireUnpublish];
    

    Then rename the FlowType column

    sp_rename 'WorkflowSettings.FlowType', 'Type', 'COLUMN';
    
  • Nathan Woulfe 447 posts 1664 karma points MVP 5x hq c-trib
    May 16, 2023 @ 22:49
    Nathan Woulfe
    1

    Hey Andrew, that looks like the migration didn't run - can you check the UmbracoKeyValue table for entries related to Plumber and Workflow, and let me know what you find?

    The table updates and creation should absolutely be managed by a migration.

    EDIT: I've just done the following, with no issues:

    • created a new Umbraco 10 project
    • installed Plumber 10.1.1
    • build and run, verified everything works as expected
    • uninstalled Plumber
    • deleted /app_plugins/plumber
    • installed Umbraco Workflow 10.2.0
    • build and run, verified everything works as expected (migrations executed)
  • Andrew Bright 84 posts 244 karma points
    May 17, 2023 @ 09:24
    Andrew Bright
    0

    Hey Nathan,

    Thank you for coming back to me first off, here,s the UmbracoKeyValue table I have: enter image description here

    Probably should have mentioned that we have migrated from Umbraco 7.15.5 to Umbraco 10.4.0 and Workflow.Umbraco 1.1.15

    So I think my bad as I actually needed to go from Workflow.Umbraco 1.1.15 to Workflow.Umbraco 10.2.0

    But still would have expected the migration to work as you have expressed

  • Nathan Woulfe 447 posts 1664 karma points MVP 5x hq c-trib
    May 17, 2023 @ 09:45
    Nathan Woulfe
    0

    Was that definitely Workflow.Umbraco, not Umbraco.Workflow?

    Workflow.Umbraco is very, very old and deprecated (should only work on Umbraco 7), I'm surprised it shows in search results at all.

    That will be the cause though - it should be Umbraco.Workflow 10.2, which includes the required migrations for moving from Plumber to Umbraco Workflow.

  • Andrew Bright 84 posts 244 karma points
    May 17, 2023 @ 09:59
    Andrew Bright
    0

    Yes definitely Workflow Umbraco as it was migrated from a Umbraco 7 site so I should never have installed Plumber on the migrated Umbraco instance and then tried to go to Umbraco.Workflow it seems.

    So I migrated an Umbraco 7 site with the workflow table schema with that of Workflow.Umbraco and the migration to Umbraco.Workflow should resolve this issue.

    Not sure what to do in order of the next steps really.

  • Andrew Bright 84 posts 244 karma points
    May 19, 2023 @ 10:52
    Andrew Bright
    0

    Last thing on this and I will leave it be so I managed to get things ticking over by deleting all the workflow tables in the database and the UmbracoKeyValue table entry.

    Installed a fresh copy of workflow 10.2.0 and its mostly working just I don't seem to have access to the workflow email templates and can't seem to get email notifications to send when the content review is about to expire can you please advise?

    Now getting the below error in the logs enter image description here

Please Sign in or register to post replies

Write your reply to:

Draft