Copied to clipboard

Flag this post as spam?

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


  • Tony Gledhill 3 posts 72 karma points
    Feb 23, 2016 @ 12:55
    Tony Gledhill
    0

    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, 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)

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies