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)

Please Sign in or register to post replies

Write your reply to:

Draft