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.

  • 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