U4-2607 - Creating nodes with special characters causes YSOD

Created by Jan Brinker 08 Aug 2013, 20:44:34 Updated by Sebastiaan Janssen 04 Sep 2013, 16:39:23

Relates to: U4-2791

I was just trying to create a node in Umbraco 6.1.3 with a name starting with "@", which lead to being presented with a YSOD.

Would be at least good to catch this error before causing the yellow screen of death and giving him a user-friendly error-message. As this happens with 6.1.3, I guess this bug applies to all versions, but I marked it as a 6.1.3 issue for now, as I don't have a proof something caused the error at some version upwards.

I guess the node names just need to be encoded before feeding them to the DB to solve this.

Here is what error I currently get: Parameter '@LIGHTGIANTS' specified but none of the passed arguments have a property with this name (in 'WHERE ([umbracoNode].[nodeObjectType] = 'c66ba18e-eaf3-4cff-8a22-41b16d66a972' AND [umbracoNode].[parentID] = 1112 AND upper([umbracoNode].[text]) like '@LIGHTGIANTS%')')

1 Attachments


Sebastiaan Janssen 13 Aug 2013, 10:44:22

Seems to come from the EnsureUniqueNodeName methods, user params need to be escaped (@@ instead of @).

Sebastiaan Janssen 13 Aug 2013, 10:48:11

But might need connection string changes too: http://stackoverflow.com/questions/10236258/prevent-petapoco-from-recognizing-variables-as-input-parameters

Priority: Normal

Type: Bug

State: Fixed

Assignee: Morten Christensen

Difficulty: Normal

Category: UI

Backwards Compatible: True

Fix Submitted:

Affected versions: 6.1.3

Due in version: 6.1.4


Story Points: