Forums (Obsolete)

Member

JeremyThake - 1/9/2006 4:32:03 AM

Error: expects parameter '@UrlPath'

I've got an error with my Kentico instance after upgrading from 1.7b to 1.8. The error is below...it's when I try and save the page with a CMSEditableRegion in it.

Thanks
Jeremy

Server Error in '/BibTrackKenticoCMS' Application.
--------------------------------------------------------------------------------

Kentico.CMS.DataProviderSQL.ExecuteQuery: Query: Proc_CMS_Tree_Update: caused exception: Procedure 'Proc_CMS_Tree_Update' expects parameter '@UrlPath', which was not supplied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: Kentico.CMS.DataProviderSQL.ExecuteQuery: Query: Proc_CMS_Tree_Update: caused exception: Procedure 'Proc_CMS_Tree_Update' expects parameter '@UrlPath', which was not supplied.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[Exception: Kentico.CMS.DataProviderSQL.ExecuteQuery: Query: Proc_CMS_Tree_Update: caused exception: Procedure 'Proc_CMS_Tree_Update' expects parameter '@UrlPath', which was not supplied.]
Kentico.CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, Object[,] queryParams, MetadataQueryTypeEnum queryType)
Kentico.CMS.DataEngine.GeneralConnection.RunQueryObject(MetadataQuery query, Object[,] params)

[Exception: Kentico.CMS.DataEngine.GeneralConnection.RunQueryObject: Query: Proc_CMS_Tree_Update caused exception: Kentico.CMS.DataProviderSQL.ExecuteQuery: Query: Proc_CMS_Tree_Update: caused exception: Procedure 'Proc_CMS_Tree_Update' expects parameter '@UrlPath', which was not supplied.]
Kentico.CMS.TreeEngine.TreeNode.Update()
Kentico.CMS.CMSControls.CMSPageManager.SaveEditableRegionsToXML()
Kentico.CMS.CMSControls.CMSPageManager.SaveEditableRegionsForCurrentPage()
Kentico.CMS.CMSControls.CMSPageManager.mSaveLinkButton_Click(Object sender, EventArgs e)
System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) +108
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +138
System.Web.UI.Page.ProcessRequestMain() +1277

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573


Guest	admin - 1/9/2006 2:41:11 PM Re: Error: expects parameter '@UrlPath' Hi Jeremy, could you please check: 1) If your database contains field CMS_Tree.UrlPath 2) If your metadata\cms\tree\schema.config file contains a definition of the UrlPath field? If not, please make sure you have updated your metadata folder correctly. Thank you. Best Regards,

Member

JeremyThake - 1/10/2006 2:21:22 AM

Re: Error: expects parameter '@UrlPath'

Okay, I installed a new instance of Kentico 1.8 for 1.1 C# and then used BeyondCompare to do a file comparison on both folders for the cmsdesk.

The only concern I have is that obviously we are adding new cms objects to this list so it's not just a straight forward copy. It would make life a lot easier if there was clearer seperation of the actual Kentico code and the code we develop to customise it.

It also means when adding new files in upgrades that in Visual Studio we have to go and find them and include them also. Overwriting project files leads to dangers because of files that we've added.

Has this been brought up before?


Guest	admin - 1/12/2006 7:09:25 PM Re: Error: expects parameter '@UrlPath' Hi Jeremy, Thank you for your answer. Were you able to solve the original error? Regarding the metadata files - yes, we plan to improve the management of all settings in Kentico CMS 2.0, which should help you avoid overwriting the modified settings. Best Regards,


Member	JeremyThake - 1/13/2006 3:04:51 AM Re: Error: expects parameter '@UrlPath' Yep, that solved it, thanks.