Forums / General / Issue 12785 - potential workaround?

Issue 12785 - potential workaround?

Next topic

Author	Message
Russell Michell	Tuesday 12 August 2008 6:55:33 pm Apologies if this isn't the correct place to submit this info: I just experienced a near corruption of my ezurlalias_ml table after I modded my override/site.ini.append.php. I put this: [URLTranslator] Translation=enabled and ran updateniceurls.php which resulted in my being unable to navigate through my ez 4.0 site and receiving multiple redirect errors from Firefox. This was in my logs: Query error: Duplicate entry '471-0c1f3c77af50ba4221fb229fccbf4f62' for key 1. Query: UPDATE ezurlalias_ml SET parent = 471 WHERE parent = 287 So I altered site.ini it to: [URLTranslator] Translation=disabled Cleared the cache and re-ran updateniceurls.php which fixed t emultiple redirect error but the error message still shows up in the logs. According to Issue 12785, this has been fixed in 4.0.1, but I'm not sure what do do next to incorporate this fix in my install. Do I need to try and upgrade? Which upgrade path to I follow - there obviously isn't one for 4.0 to 4.0.1?? Thanks a lot, Russ Russell Michell, Wellington, New Zealand. We're building! http://www.theruss.com/blog/ I'm on Twitter: http://twitter.com/therussdotcom Believe nothing, consider everything.
Russell Michell	Tuesday 12 August 2008 8:56:47 pm I managed to fix my issue almost completely by removing all references to PathPrefix and PathPrefixExclude in my settings files and clearing the cache. However in my admin section, the string 'Root' is now appended to the URL for all subdirectories ('Root' = the ez default 'Home', I just changed the label), but not directories below these. ("Level 3" directories if you like) Before experiencing this issue, this didn't happen. However for the now, everything worked as it did prior to the problem best described as that at: http://issues.ez.no/IssueView.php?Id=12785. If anyone has any further info as to how to <b>totally</b> resolve this, I'd be very much obliged. Cheers, Russ Russell Michell, Wellington, New Zealand. We're building! http://www.theruss.com/blog/ I'm on Twitter: http://twitter.com/therussdotcom Believe nothing, consider everything.
Russell Michell	Tuesday 12 August 2008 9:31:30 pm OK, I have finally got my database and system back to a semblance of what it was. After removing any reference to PathPrefix from all config files, I ran #> php bin/php/updateniceurls.php --update-nodes --interactive -s <siteaccess> ..for <b>both</b> my "front-end" website siteaccess <b>and</b> the admin siteaccess. It is now back to what it was. The moral of the story is, don't make critical config changes to your system right after lunch... Hope this helps someone out sometime. Russ Russell Michell, Wellington, New Zealand. We're building! http://www.theruss.com/blog/ I'm on Twitter: http://twitter.com/therussdotcom Believe nothing, consider everything.
Łukasz Serwatka	Wednesday 13 August 2008 12:11:14 am Hi, You should give a try with 4.0.1rc2 which has a lot of fixes reg to ml url aliases. http://ez.no/developer/news/ez_publish_4_0_1rc2_3_10_1rc2_released Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Russell Michell	Thursday 14 August 2008 3:28:38 pm Thank you Łukasz. I upgraded but still experienced a corrupted ezurlalias_ml table. Each time I ran the updateniceurls.php script I ended up with a duplicate entry for one of my three "Level 2" nodes 'Site" (as below) -+ 'Root' ---- Site ---- Install ---- Site 2 I fixed this by updating the text_md5 column of the corrupted entry with the value of text_md5 of the newer entry (The original entry with an id=2, the newer one had an id=285 or something) and then deleted the original entry. Running updateniceurls.php again, didn't add a duplicate this time around. Thanks for the tip, I needed to learn the proper upgrade procedure anyway :-) Cheers, Russ Russell Michell, Wellington, New Zealand. We're building! http://www.theruss.com/blog/ I'm on Twitter: http://twitter.com/therussdotcom Believe nothing, consider everything.