Hi,

I've installed Courier 2.6 and contour.

Then I installed the Courier Contrib for deploying the contour forms. But it failed with this error.

error:Umbraco.Courier.Core.Exceptions.PackageException: Unable to load item with id '50cf1f28-d830-47bd-b355-52dacfab90ea' from provider 'Forms' ---> Umbraco.Courier.Core.Exceptions.RetrieveException: Error retrieving item [50cf1f28-d830-47bd-b355-52dacfab90ea] from provider [99456c6d-c943-4741-8b9a-052fdb5f7845]. ---> NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT this_.[Id] as column1_5_0_, this_.[Archived] as column2_5_0_, this_.[Created] as column3_5_0_, this_.[DisableDefaultStylesheet] as column4_5_0_, this_.[Entries] as column5_5_0_, this_.[FieldIndicationType] as column6_5_0_, this_.[GotoPageOnSubmit] as column7_5_0_, this_.[HideFieldValidation] as column8_5_0_, this_.[Indicator] as column9_5_0_, this_.[InvalidErrorMessage] as column10_5_0_, this_.[ManualApproval] as column11_5_0_, this_.[MessageOnSubmit] as column12_5_0_, this_.[Name] as column13_5_0_, this_.[RequiredErrorMessage] as column14_5_0_, this_.[ShowValidationSummary] as column15_5_0_, this_.[StoreRecordsLocally] as column16_5_0_, this_.[Views] as column17_5_0_, this_.[DataSource] as column18_5_0_ FROM [dbo].[UFForms] this_ WHERE this_.[Id] = ?p0 ] Positional parameters: #0>50cf1f28-d830-47bd-b355-52dacfab90ea [SQL: SELECT this_.[Id] as column1_5_0_, this_.[Archived] as column2_5_0_, this_.[Created] as column3_5_0_, this_.[DisableDefaultStylesheet] as column4_5_0_, this_.[Entries] as column5_5_0_, this_.[FieldIndicationType] as column6_5_0_, this_.[GotoPageOnSubmit] as column7_5_0_, this_.[HideFieldValidation] as column8_5_0_, this_.[Indicator] as column9_5_0_, this_.[InvalidErrorMessage] as column10_5_0_, this_.[ManualApproval] as column11_5_0_, this_.[MessageOnSubmit] as column12_5_0_, this_.[Name] as column13_5_0_, this_.[RequiredErrorMessage] as column14_5_0_, this_.[ShowValidationSummary] as column15_5_0_, this_.[StoreRecordsLocally] as column16_5_0_, this_.[Views] as column17_5_0_, this_.[DataSource] as column18_5_0_ FROM [dbo].[UFForms] this_ WHERE this_.[Id] = ?p0] ---> MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[Id] as column1_5_0_, this_.[Archived] as column2_5_0_, this_.[Created] as colum' at line 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() 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.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) at NHibernate.Impl.CriteriaImpl.List(IList results) at NHibernate.Impl.CriteriaImpl.List[T]() at Contour.Addons.CourierSupport.Helpers.FormHelper.Get(Guid guid) at Contour.Addons.CourierSupport.Helpers.FormHelper.Get(String guid) at Contour.Addons.CourierSupport.Persisters.FormItem.RetrieveItem[T](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 Contour.Addons.CourierSupport.ItemProviders.FormItemProvider.HandlePack(ItemIdentifier id) at Umbraco.Courier.Core.ItemProvider.Package(ItemIdentifier id) at Umbraco.Courier.RepositoryProviders.Local.Package(ItemIdentifier itemId) in c:\Program Files (x86)\teamcity\buildAgent\work\2d3247b08adc3338\Umbraco.Courier.RepositoryProviders\Local\Local.cs:line 228 at Umbraco.Courier.Core.Packaging.RevisionPackaging.‡(ItemIdentifier itemId, ItemProvider provider, QueuedItemIdentifier itemInQueue) --- End of inner exception stack trace --- at Umbraco.Courier.Core.Packaging.RevisionPackaging.‡(ItemIdentifier itemId, ItemProvider provider, QueuedItemIdentifier itemInQueue) at Umbraco.Courier.Core.Packaging.RevisionPackaging.†() at Umbraco.Courier.Core.Packaging.RevisionPackaging.Package() at Umbraco.Courier.Core.Tasks.PackagingTask.Run() at Umbraco.Courier.Core.TaskManager.(IRevisionTask value) 02/05/2012 12:11:07

Version:

Umbraco: 4.7.1

Courier: 2.6.14

Contour: 1.1.12

Any idea why this is happening.

Appreciate your kind help.

Thanks,

Kishore