Copied to clipboard

Flag this post as spam?

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


  • Justin Yoo 16 posts 39 karma points
    May 16, 2012 @ 04:49
    Justin Yoo
    0

    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?

  • Casey Neehouse 1339 posts 483 karma points MVP 2x admin
    May 17, 2012 @ 20:19
    Casey Neehouse
    0

    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

  • Justin Yoo 16 posts 39 karma points
    May 21, 2012 @ 01:36
    Justin Yoo
    0

    Hi, Casey.

    Thanks for your response. I'll give it a try and get back to you soon.

     

    Cheers,

  • Justin Yoo 16 posts 39 karma points
    May 22, 2012 @ 03:20
    Justin Yoo
    0

    Thanks, Casey. My company has sorted out this issue by upgrading the version to 2.6.17.

Please Sign in or register to post replies

Write your reply to:

Draft