After upgrading to 7.4.1 I am unable to Courier Media items.
The first error was that there was no column for help text, So I added this to both environments
ALTER TABLE cmsPropertyType ADD helpText NVARCHAR(1000) NULL
and now another exception is being thrown when packaging items.
Please can anyone help
2016-02-23 12:46:34,722 [39] ERROR Umbraco.Courier.Core.TaskManager - [Thread 51] An error occurred consuming task
Umbraco.Courier.Core.Exceptions.PackageException: Unable to load item with id 'Image' from provider 'Media types' ---> Umbraco.Courier.Core.Exceptions.RetrieveException: Error retrieving item [Image] from provider [d8e6ad88-e73a-11df-9492-0800200c9a66]. ---> NHibernate.Exceptions.GenericADOException: could not execute query
[ SELECT this.id as id10, this.contenttypeNodeId as contentt210, this.sortorder as sortorder10, this.text as text10, this.parentGroupId as parentGr510_ FROM cmsPropertyTypeGroup this_ WHERE this.contenttypeNodeId = @p0 ]
Positional parameters: #0>1032
[SQL: SELECT this.id as id10, this.contenttypeNodeId as contentt210, this.sortorder as sortorder10, this.text as text10, this.parentGroupId as parentGr510 FROM cmsPropertyTypeGroup this_ WHERE this_.contenttypeNodeId = @p0] ---> System.Data.SqlClient.SqlException: Invalid column name 'parentGroupId'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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, TaskCompletionSource1 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 NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
--- End of inner exception stack trace ---
at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results)
at NHibernate.Impl.CriteriaImpl.List(IList results)
at NHibernate.Impl.CriteriaImpl.ListT
at Umbraco.Courier.Persistence.V6.NHibernate.Helpers.ContentTypeHelper.GetPropertyTypeGroups(CmsContentType ct, ISession session) in f:\TeamCity\buildAgent\work\8e4705e1ef724e65\Core\Umbraco.Courier.Persistence.V6.NHibernate\Helpers\ContentTypeHelper.cs:line 146
at Umbraco.Courier.Persistence.V6.NHibernate.Persisters.MediaTypeItem.RetrieveItem(ItemIdentifier itemId) in f:\TeamCity\buildAgent\work\8e4705e1ef724e65\Core\Umbraco.Courier.Persistence.V6.NHibernate\Persisters\MediaType.cs:line 227
at Umbraco.Courier.Core.ItemCrud1.RetrieveItem[T1](ItemIdentifier itemId)
at Umbraco.Courier.Core.ItemCrudProvider.RetrieveItem[T](ItemIdentifier itemId)
--- End of inner exception stack trace ---
at Umbraco.Courier.Core.ItemCrudProvider.RetrieveItem[T](ItemIdentifier itemId)
at Umbraco.Courier.ItemProviders.MediaTypeItemProvider.HandlePack(ItemIdentifier id)
at Umbraco.Courier.Core.ItemProvider.Package(ItemIdentifier id)
at Umbraco.Courier.RepositoryProviders.Local.Package(ItemIdentifier itemId)
at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageItem(ItemIdentifier itemId, ItemProvider provider, QueuedItemIdentifier itemInQueue)
--- End of inner exception stack trace ---
at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageItem(ItemIdentifier itemId, ItemProvider provider, QueuedItemIdentifier itemInQueue)
at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch()
at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch()
at Umbraco.Courier.Core.Packaging.RevisionPackaging.Package()
at Umbraco.Courier.Core.Tasks.PackagingTask.Run()
at Umbraco.Courier.Core.BackgroundTaskRunner1.ConsumeTaskInternal(T task)
Umbraco 7.4.1 and Courier 2
After upgrading to 7.4.1 I am unable to Courier Media items.
The first error was that there was no column for help text, So I added this to both environments
ALTER TABLE cmsPropertyType ADD helpText NVARCHAR(1000) NULL
and now another exception is being thrown when packaging items.
Please can anyone help
2016-02-23 12:46:34,722 [39] ERROR Umbraco.Courier.Core.TaskManager - [Thread 51] An error occurred consuming task Umbraco.Courier.Core.Exceptions.PackageException: Unable to load item with id 'Image' from provider 'Media types' ---> Umbraco.Courier.Core.Exceptions.RetrieveException: Error retrieving item [Image] from provider [d8e6ad88-e73a-11df-9492-0800200c9a66]. ---> NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT this.id as id10, this.contenttypeNodeId as contentt210, this.sortorder as sortorder10, this.text as text10, this.parentGroupId as parentGr510_ FROM cmsPropertyTypeGroup this_ WHERE this.contenttypeNodeId = @p0 ] Positional parameters: #0>1032 [SQL: SELECT this.id as id10, this.contenttypeNodeId as contentt210, this.sortorder as sortorder10, this.text as text10, this.parentGroupId as parentGr510 FROM cmsPropertyTypeGroup this_ WHERE this_.contenttypeNodeId = @p0] ---> System.Data.SqlClient.SqlException: Invalid column name 'parentGroupId'. 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 NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) --- End of inner exception stack trace --- at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) at NHibernate.Impl.CriteriaImpl.List(IList results) at NHibernate.Impl.CriteriaImpl.ListT at Umbraco.Courier.Persistence.V6.NHibernate.Helpers.ContentTypeHelper.GetPropertyTypeGroups(CmsContentType ct, ISession session) in f:\TeamCity\buildAgent\work\8e4705e1ef724e65\Core\Umbraco.Courier.Persistence.V6.NHibernate\Helpers\ContentTypeHelper.cs:line 146 at Umbraco.Courier.Persistence.V6.NHibernate.Persisters.MediaTypeItem.RetrieveItem(ItemIdentifier itemId) in f:\TeamCity\buildAgent\work\8e4705e1ef724e65\Core\Umbraco.Courier.Persistence.V6.NHibernate\Persisters\MediaType.cs:line 227 at Umbraco.Courier.Core.ItemCrud1.RetrieveItem[T1](ItemIdentifier itemId) at Umbraco.Courier.Core.ItemCrudProvider.RetrieveItem[T](ItemIdentifier itemId) --- End of inner exception stack trace --- at Umbraco.Courier.Core.ItemCrudProvider.RetrieveItem[T](ItemIdentifier itemId) at Umbraco.Courier.ItemProviders.MediaTypeItemProvider.HandlePack(ItemIdentifier id) at Umbraco.Courier.Core.ItemProvider.Package(ItemIdentifier id) at Umbraco.Courier.RepositoryProviders.Local.Package(ItemIdentifier itemId) at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageItem(ItemIdentifier itemId, ItemProvider provider, QueuedItemIdentifier itemInQueue) --- End of inner exception stack trace --- at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageItem(ItemIdentifier itemId, ItemProvider provider, QueuedItemIdentifier itemInQueue) at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch() at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch() at Umbraco.Courier.Core.Packaging.RevisionPackaging.Package() at Umbraco.Courier.Core.Tasks.PackagingTask.Run() at Umbraco.Courier.Core.BackgroundTaskRunner
1.ConsumeTaskInternal(T task)is working on a reply...