Issue 12785 - potential workaround?

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.

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.

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.