Invalid column name 'nodeObjecType' - There is a typo in 2.5.4. Has this been fixed in 2.6.17?
Hi, there.
I found that the error message below tells me there is a typo.
Umbraco.Courier.Core.Exceptions.PackageException: Unable to load item with id '62e84db3-c2d4-4fe1-a99c-1c4aff31046e' from provider 'PropertyData' ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT uniqueId from umbracoNode WHERE id = @p0 AND nodeObjecType = @p1 ] Name:id - Value:27594 Name:type - Value:c66ba18e-eaf3-4cff-8a22-41b16d66a972 [SQL: SELECT uniqueId from umbracoNode WHERE id = @p0 AND nodeObjecType = @p1] ---> System.Data.SqlClient.SqlException: Invalid column name 'nodeObjecType'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() 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) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) 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 System.Data.SqlClient.SqlCommand.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.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at NHibernate.Impl.AbstractQueryImpl.UniqueResult[T]() at Umbraco.Courier.Persistence.V4.NHibernate.NHibernateProvider.GetUniqueId(Int32 nodeId, Guid nodeObjectType) in c:\Program Files (x86)\teamcity\buildAgent\work\d94035a1177dda67\Umbraco.Courier.Persistence.NHibernate\NHibernate.cs:line 362 at Umbraco.Courier.DataResolvers.ContentPicker.Packaging(Item item) in c:\Program Files (x86)\teamcity\buildAgent\work\d94035a1177dda67\Umbraco.Courier.DataResolvers\DataResolvers\ContentPicker.cs:line 99 --- End of inner exception stack trace --- at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Umbraco.Courier.Core.ResolutionManager.(Item item, ItemEvent e, ItemProvider provider) at Umbraco.Courier.Core.ResolutionManager.PackagingItem(Item item, ItemProvider provider) at Umbraco.Courier.Core.ItemProvider.Package(ItemIdentifier id) at Umbraco.Courier.RepositoryProviders.Local.Package(ItemIdentifier itemId) in c:\Program Files (x86)\teamcity\buildAgent\work\d94035a1177dda67\Umbraco.Courier.RepositoryProviders\Local\Local.cs:line 225 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) 16/05/2012 9:42:56 AM
I'm currently using Umbraco Courier 2.5.4. Has the error been fixed on 2.6.17?
And what's the difference between 2.6.17 and 2.6.17 hotfix?
Looking through the latest source code, it does not appear to have this typo anymore. 2.6.17 also fixes several other small issues, and would be a worthwhile upgrade to give a shot.
Invalid column name 'nodeObjecType' - There is a typo in 2.5.4. Has this been fixed in 2.6.17?
Hi, there.
I found that the error message below tells me there is a typo.
I'm currently using Umbraco Courier 2.5.4. Has the error been fixed on 2.6.17?
And what's the difference between 2.6.17 and 2.6.17 hotfix?
Looking through the latest source code, it does not appear to have this typo anymore. 2.6.17 also fixes several other small issues, and would be a worthwhile upgrade to give a shot.
Casey
Hi, Casey.
Thanks for your response. I'll give it a try and get back to you soon.
Cheers,
Thanks, Casey. My company has sorted out this issue by upgrading the version to 2.6.17.
is working on a reply...