Copied to clipboard

Flag this post as spam?

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


  • Sören Deger 733 posts 2844 karma points c-trib
    Jul 19, 2012 @ 10:59
    Sören Deger
    0

    Can't change node name of any nodes after TeaCommerce starter kit integration

    Hello,

    I have integrated Tea Commerce Starter Kit 2.0 in an existing website. It works very good, but after the integration I have this problem:

    After I change the name in properties tab of a node in content section I see in the right area of the backend the frontend! But this error does not occur at all nodes, only any different nodes. In my opinion the document type is irrelevant, because i.e. in one folder it works and in another folder I see this error by the same document type.
    The error occur in different document types.

    In the umbraco log i can find this error:

    ...
    System.Data.SqlClient.SqlException (0x80131904): Ungültiger Objektname 
    'dbo.Tea301_UrlHistory'.
       bei System.Data.SqlClient.SqlConnection.OnError(SqlException 
    exception, Boolean breakConnection)
       bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException 
    exception, Boolean breakConnection)
       bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
       bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, 
    SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
     bulkCopyHandler, TdsParserStateObject stateObj)
       bei System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       bei System.Data.SqlClient.SqlDataReader.get_MetaData()
       bei 
    System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, 
    RunBehavior runBehavior, String resetOptionsString)
       bei 
    System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior 
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean 
    async)
       bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
     cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String 
    method, DbAsyncResult result)
       bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
     cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String 
    method)
       bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior 
    behavior, String method)
       bei 
    System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior 
    behavior)
       bei System.Data.Common.DbCommand.ExecuteReader()
       bei System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, 
    QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, 
    Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
       bei System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression 
    query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] 
    userArguments, ICompiledSubQuery[] subQueries)
       bei 
    System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression
     query)
       bei 
    System.Data.Linq.DataQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
    
       bei System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
       bei System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
       bei Tea.UmbracoRedirect.NodeChangeTracker.SaveCurrentUrl(Node node, 
    UrlHistoryDataContext db, Action`2 action)
       bei Tea.UmbracoRedirect.NodeChangeTracker.BeforePublish(Document 
    document, PublishEventArgs e)
       bei 
    umbraco.cms.businesslogic.web.Document.PublishEventHandler.Invoke(Document
     sender, PublishEventArgs e)
       bei 
    umbraco.cms.businesslogic.web.Document.FireBeforePublish(PublishEventArgs
     e)
       bei umbraco.cms.businesslogic.web.Document.PublishWithResult(User u)
       bei umbraco.cms.presentation.editContent.Publish(Object sender, 
    EventArgs e)
       bei System.EventHandler.Invoke(Object sender, EventArgs e)
       bei umbraco.controls.ContentControl.savePublish(Object Sender, 
    ImageClickEventArgs e)
       bei System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs
     e)
       bei System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String 
    eventArgument)
       bei 
    System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
     eventArgument)
       bei System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler 
    sourceControl, String eventArgument)
       bei System.Web.UI.Page.RaisePostBackEvent(NameValueCollection 
    postData)
       bei System.Web.UI.Page.ProcessRequestMain(Boolean 
    includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    But I don't know the dbo.Tea301_UrlHistory and can not find this table in my database.

    This are my settings:

    Server: Windows Server 2008 R2, ASP.NET 4.0

    Umbraco-Version: 4.7.1.1 (Assembly version: 1.0.4393.24044)

    Installed packages:

    - Best Case Technologies presents Doc2Form v 3.0
    - Config Tree v 2.0
    - Digibiz Advanced Media Picker v 2.0
    - Delete All Children Context Menu Item v 0.9.0
    - Google Maps for Umbraco 2.0.3
    - MySnippets for TinyMCE v 1.0.2
    - Structure Extensions 1.0
    - tswe.log4umbraco 4.5.0
    - uComponents v 3.0.3
    - uGoLive v 1.1
    - uHidesy v 1.13
    - Waffel Multiple Image Uploader (WMIU) v 0.5
    - XSLTsearch v 3.0.4
    - Document Type Fieldsets v 0.5.1
    - Language Selector v 0.9
    - uBlogsy v 2.1.0.0
    - Import Media v 1.4
    - Bilis XML Sitemap v 2.0
    - Robots.txt Editor v 3.0
    - Tea Commerce v 1.4.2.4
    - XSLTouch v 1.1
    - Media Icons v 1.0
    - XSLT Macro Engine v 1.0.1
    - jesperEasyNames v 0.000003
    - ImageGen v 2.5.7

    It's a big multilingual Website with a blog and TeaCommerce-Shop. On the next day, the website must be ready to passed to the customer.

    Have anyone an idea, how i can solve this error?

     

    Best regards

    Sören



     



  • Rune Grønkjær 1372 posts 3103 karma points
    Jul 19, 2012 @ 11:04
    Rune Grønkjær
    1

    Hi Sören,

    Try removing the Tea.UmbracoRedirect.dll from the bin folder. It's dependent on a custom table in the database, and might be the one making problems.

    /Rune

  • Sören Deger 733 posts 2844 karma points c-trib
    Jul 19, 2012 @ 11:20
    Sören Deger
    1

    Hi Rune,

    thank you for the very fast and helpful answer! Now, it works! You have save my life ;-)

     

    Sören

Please Sign in or register to post replies

Write your reply to:

Draft