eZ Community » Forums » Developer » How to fix url_alias troubles?
expandshrink

How to fix url_alias troubles?

How to fix url_alias troubles?

Tuesday 25 October 2011 12:04:22 pm - 4 replies

Hi,

at one site, I can't publish content because of a transaction error. The SQL message is:

Query error (1062): Duplicate entry '12-fd7dcb12c7a7f3e84b91498a4b510954' for key 1. Query: UPDATE ezurlalias_ml SET parent = 12 WHERE parent = 9700 AND (cast(lang_mask & 2 AS SIGNED )  > 0)

I've run already

php bin/php/updateniceurls.php -snews_admin

But this didn't help.

I don't want to truncate the ezurlalias_ml table to fix it.

Is there any other way to solve this? Any useful parameter for the updateniceurls script?

Installed ezpublish version: 2011.6

Tuesday 25 October 2011 1:21:25 pm

Hi,

a quick "workaround" to solve this specific issue:

 SELECT * FROM ezurlalias_ml WHERE md5_text LIKE 'fd7dcb12c7a7f3e84b91498a4b510954';

I got 3 results. I've deleted 2 results, afterwards the publishing works again.

Tuesday 25 October 2011 8:21:55 pm

If all the url aliases you have got are the system-cretated-ones, you can just delete all of the data in that table as well, and just let the php script rebuild all of the aliases for existing nodes

Wednesday 29 August 2012 12:54:50 pm

Big thanks to Gaetano Giunta! happy.gif Emoticon
Your hint helped us to eliminate a problem we had. 

Monday 09 October 2017 5:46:56 am

Hello All,

I recently ran into this problem and found that Gaetano's solution worked well for me.

First, I simply truncate the table:

TRUNCATE TABLE ezurlalias_ml;

Second, I run the the update nice urls script:

./bin/php/updateniceurls.php -s siteadmin -v;

This solved the problem for me and a customer!

Cheers,
Heath

expandshrink

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu

Proudly Developed with from