Copied to clipboard

Flag this post as spam?

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


  • Niels Sparenberg 11 posts 72 karma points
    Nov 29, 2013 @ 14:11
    Niels Sparenberg
    0

    Courier Umbraco 7

    I've been trying out courier in umbraco 7 and run into following error:

    --------------------------------------------------------------------------------------

    29-11-2013 13:28:51; NHibernate.Exceptions.GenericADOException: could not execute query

    [ SELECT this_.id as id34_1_, this_.createDate as createDate34_1_, this_.level as level34_1_, this_.nodeObjectType as nodeObje4_34_1_, this_.path as path34_1_, this_.sortOrder as sortOrder34_1_, this_.text as text34_1_, this_.trashed as trashed34_1_, this_.uniqueID as uniqueID34_1_, this_.nodeUser as nodeUser34_1_, this_.parentID as parentID34_1_, umbracouse2_.id as id40_0_, umbracouse2_.defaultToLiveEditing as defaultT2_40_0_, umbracouse2_.startMediaID as startMed3_40_0_, umbracouse2_.startStructureID as startStr4_40_0_, umbracouse2_.userDefaultPermissions as userDefa5_40_0_, umbracouse2_.userDisabled as userDisa6_40_0_, umbracouse2_.userEmail as userEmail40_0_, umbracouse2_.userLanguage as userLang8_40_0_, umbracouse2_.userLogin as userLogin40_0_, umbracouse2_.userName as userName40_0_, umbracouse2_.userNoConsole as userNoC11_40_0_, umbracouse2_.userPassword as userPas12_40_0_ FROM umbracoNode this_ left outer join umbracoUser umbracouse2_ on this_.nodeUser=umbracouse2_.id WHERE (this_.parentID = @p0 and this_.nodeObjectType = @p1) ]

    Positional parameters:  #0>-1 #1>30a2a501-1978-4ddb-a57b-f7efed43ba3c

    [SQL: SELECT this_.id as id34_1_, this_.createDate as createDate34_1_, this_.level as level34_1_, this_.nodeObjectType as nodeObje4_34_1_, this_.path as path34_1_, this_.sortOrder as sortOrder34_1_, this_.text as text34_1_, this_.trashed as trashed34_1_, this_.uniqueID as uniqueID34_1_, this_.nodeUser as nodeUser34_1_, this_.parentID as parentID34_1_, umbracouse2_.id as id40_0_, umbracouse2_.defaultToLiveEditing as defaultT2_40_0_, umbracouse2_.startMediaID as startMed3_40_0_, umbracouse2_.startStructureID as startStr4_40_0_, umbracouse2_.userDefaultPermissions as userDefa5_40_0_, umbracouse2_.userDisabled as userDisa6_40_0_, umbracouse2_.userEmail as userEmail40_0_, umbracouse2_.userLanguage as userLang8_40_0_, umbracouse2_.userLogin as userLogin40_0_, umbracouse2_.userName as userName40_0_, umbracouse2_.userNoConsole as userNoC11_40_0_, umbracouse2_.userPassword as userPas12_40_0_ FROM umbracoNode this_ left outer join umbracoUser umbracouse2_ on this_.nodeUser=umbracouse2_.id WHERE (this_.parentID = @p0 and this_.nodeObjectType = @p1)] ---> System.Data.SqlClient.SqlException: Invalid column name 'defaultToLiveEditing'.

    Invalid column name 'userDefaultPermissions'.

    --------------------------------------------------------------------------------------

    Looks like the dbo.umbracoUser table has been changed to not contain some columns courier uses anymore.

    So what i want to know is really are there any plans for upgrading courier soon?
    Any timeline would be nice because if its allready planned we don't have to roll back :)

     

     

  • Kyle 24 posts 63 karma points
    Dec 05, 2013 @ 12:45
    Kyle
    0

    Hey,

    I'm having the same issue with 6.1.3 to 7.0.0,

    System.Data.SqlClient.SqlException: Invalid column name 'defaultToLiveEditing'. Invalid column name 'userDefaultPermissions'.
    

    Would be awesome if this fix is planned for the near future, can't wait to get 7 deployed.

    Thanks,

    Kyle

  • Paul Sørensen 304 posts 650 karma points
    Dec 29, 2013 @ 17:44
Please Sign in or register to post replies

Write your reply to:

Draft