Problems with the tree, URL aliases, paths...

Tuesday 19 February 2008 6:04:59 am

I've got a very strange case. One node started to behave odd: when clicked in the tree, the user got "redirected" to its parent node. After some analysis it turned out, that it was not a redirection - the url alias simply did not contain the node's part. Not only that, in the subitems list, the node is not a link, like all other nodes, it is just a text. It still has proper name and it is still possible to view this node with system URL.

My guess was that something got messed up with tree and/or URLs. I started digging through the database and the only inconsistency I found was that in the ezcontentobject_tree table there is no path_identification_string specified for the node (while there are for objects of the same depth and class). I attempted to put it there via SQL query, but it didn't help much and disappeared again after re-editing the object.

BTW. It's Exponential 4.0.0 with 3 langauges.

Anyone has any suggestion what to do with that?
Any help much appreciated!
Thanks!

--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu

Saturday 23 February 2008 5:28:14 am

I reported this as a bug here:
http://issues.ez.no/IssueView.php?Id=12577&activeItem=1

--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu

Monday 25 February 2008 7:57:31 am

Hello Yannick,

Not 100% sure, but it seems to me that in one case no translations were made prior to the problem occurrence, and the other case looks like this:

# ROOT (pol-PL, eng-GB, nor-NO), valid
## Polish (pol-PL) <b>this one is broken</b>
### more valid nodes
## English (eng-GB)
### more valid nodes
## Norwegian (nor-NO)
### more valid nodes

It seems that in our case it has something to do with PathPrefix and lack of proper method of regenerating all URL aliases after the PathPrefix is changed. I've just edited all the nodes, but by their depth (root -> deepest), it fixed the problem... still, this seemed the easier case from the start... the other one remains a problem.

--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu

Monday 03 March 2008 10:42:00 am

Finaly, I don't think we have the same problem Piotrek.
Indeed, all my sites access use the same root node (the default root node 2) and I don't use the PathPrefix parameter.
I look forward in database to find a explanation and I found this:
Nodes are not accessible with path uri because they have a false parent ID in ezurlalias_ml. This explain why I can access to the content with a content/view/full or un content/edit but not with the URL. The updateniceurls.php (with --update-nodes params) doesn't solve the problem, but if I edit and change the name of my content and publish it, the problem disappear.
In my error.log, I have:

eZMySQLDB:
Query error: Duplicate entry '342-5fb2eb281a089ddeb57c3cd32fd5f5da' for key 1. Query: UPDATE ezurlalias_ml SET parent = 342
WHERE parent = 367

Anybody have a idea how the ezurlalias_ml table could have duplicate entries with id/md5_text???

PS: The problem arrived randomly on a node and not to all published language version of a node.

Personal website : http://bit.ly/Yannick-Dupuis
Company : Openbridge - http://www.openbridge.fr

Tuesday 18 March 2008 4:07:43 am

Hi Rune,

Without solution, I use the classic update process from the documentation to regenerate all nices urls (even if I have a native eZ 4 setup):

UPDATE ezurlalias SET is_imported=0;
TRUNCATE ezurlalias_ml;

and after

php bin/php/updateniceurls.php --import  -s siteAccess
-> where siteAccess is a admin site access with all languages support in site.ini:
[RegionalSettings]
Locale=eng-GB
ContentObjectLocale=eng-GB
ShowUntranslatedObjects=enabled
SiteLanguageList[]=eng-GB
SiteLanguageList[]=fre-FR
SiteLanguageList[]=ger-DE
SiteLanguageList[]=esl-ES
SiteLanguageList[]=ita-IT
TextTranslation=disabled 

After the end of updateniceurls process, I have some errors in error.ini like :

Tried to store path 'Rose4' but the path already exists (ID: 12634) but with action 'eznode:10728', the new action was 'eznode:10824'

and

Query error: Duplicate entry '8-e59d6834e86cee752ed841f9cd8d5baf' for key 1. Query: UPDATE ezurlalias_ml SET parent = 8
WHERE parent = 12400

With the query:

SELECT * from ezurlalias_ml where parent = 12400;

I have the result:

| eznode:54 | eznode      | 12401 |        0 |           0 |         1 |   12 |  12400 | common_ini_settings | e59d6834e86cee752ed841f9cd8d5baf |

If I go to some content, I always have url alias errors (buggy contents can be seeing with content/view/full but not with nice url in back or front office).
The error.ini log some errors like that when I go on a buggy content in front office:

The parent ID 16944 of element with ID 33 does not point to the last entry which had ID 21, incorrect path would be calculated, aborting

eZContentObjectTreeNode::pathWithNames() failed to fetch path of node 12851, falling back to generated url entries. Run updateniceurls.php to fix the problem.

I tried to change the transform group "urlalias" to the old system "urlalias_compact" but I have the same problem.
Now, if someone have another solution to regenerate all my nice url, don't hesitate...

Personal website : http://bit.ly/Yannick-Dupuis
Company : Openbridge - http://www.openbridge.fr

Tuesday 08 April 2008 5:31:52 am

We have the same url alias errors as described above. At first it seemed to occur randomly but now we have found out how to reproduce the issue. It seems that if the attribute which is used to generate the name of the node is changed any later translation of the node will produce invalid entries in the ezurlalias_ml table. The whole subtree starting at the translated node will not be accessible by the url alias anymore. You have to use "content/view/full/*". It's possible to repair the node by fixing the column values of “id” and “link” of the table ezurlalias_ml. This way the subtree can be accessed by the url alias again. But this does not fix the actual problem. We have created an issue for the problem: http://issues.ez.no/IssueView.php?Id=12829. Probably other issues like http://issues.ez.no/IssueView.php?Id=12577 or http://issues.ez.no/12720 are related to the same or similar problem.