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) ]
[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'.
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 :)
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 :)
Hey,
I'm having the same issue with 6.1.3 to 7.0.0,
Would be awesome if this fix is planned for the near future, can't wait to get 7 deployed.
Thanks,
Kyle
Hi
I think you can get around it by following this
http://our.umbraco.org/forum/getting-started/installing-umbraco/47067-Upgrade-to-701-gives-Unable-to-cast-object-of-type-SystemInt32-to-type-SystemString
/Paul S
is working on a reply...