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! Butthis errordoes not occuratall 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.
- 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.
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:
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
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
Hi Rune,
thank you for the very fast and helpful answer! Now, it works! You have save my life ;-)
Sören
is working on a reply...