Hello,

I have a small web site where i want to use custom url, hence using the umbracoUrlAlias property. The structure is as follow

/www

    /en

        /home

        /products

/content

    /product

        /productname

            /_en

            /_fr

Inside the "/_en" node, i want to put this value in the umbracoUrlAlias property: "/en/product/productname"

When i do so, i get a 404 error on the url "/en/product/productname"

If i set the property to "/test/product/productname", it works like a charm. WHY!

I did some umbDebug=true and found this that the SQL for serving /en/product/productname is :

DECLARE @0 nvarchar(40) = N'6fbde604-4178-42ce-a10b-8a2600a2f07d',
        @1 nvarchar(4000) = N'productname';
SELECT *
FROM [cmsTemplate]
INNER JOIN [umbracoNode]
ON [cmsTemplate].[nodeId] = [umbracoNode].[id]
WHERE ([umbracoNode].[nodeObjectType] = @0)
AND ([cmsTemplate].[alias] = @1)  

which cannot work, the template under that document type is "locProduct"

While the SQL for serving /test/product/productname is:

DECLARE @0 nvarchar(40) = N'6fbde604-4178-42ce-a10b-8a2600a2f07d',
        @1 int = 1,
        @2 datetime = N'Dec 12 2014  2:12PM',
        @3 int = 1;

SELECT *

FROM [cmsDocument]

INNER JOIN [cmsContentVersion]

ON [cmsDocument].[versionId] = [cmsContentVersion].[VersionId]

INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]

INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]

WHERE ([umbracoNode].[nodeObjectType] = @0)

AND ([cmsDocument].[published] = @1 AND [cmsDocument].[expireDate] <= @2)

AND ([cmsDocument].[newest] = @3)

ORDER BY [cmsContentVersion].[VersionDate] DESC
, ([umbracoNode].[sortOrder])

Anyone has an idea why this is happening?