user warning: Duplicate entry [#376024]

Hi,

In the page /admin/build/path/pathauto, if I check "Bulk generate aliases for terms that are not aliased" in the "Taxonomy term path settings" section, I have a "Duplicate entry" error:

    * Les options de configuration ont été enregistrées.
    * Mise à jour en masse des termes terminée ; 6 alias générés.

    * user warning: Duplicate entry 'taxonomy/term/1' for key 2 query: INSERT INTO drupal_path_redirect (path, redirect, query, fragment, type) VALUES ('taxonomy/term/1', 'taxonomy/term/', '', '', '301') in /var/alternc/html/drupal/sites/all/modules/path_redirect/path_redirect.module on line 144.
    * user warning: Duplicate entry 'taxonomy/term/2' for key 2 query: INSERT INTO drupal_path_redirect (path, redirect, query, fragment, type) VALUES ('taxonomy/term/2', 'taxonomy/term/', '', '', '301') in /var/alternc/html/drupal/sites/all/modules/path_redirect/path_redirect.module on line 144.
    * user warning: Duplicate entry 'taxonomy/term/3' for key 2 query: INSERT INTO drupal_path_redirect (path, redirect, query, fragment, type) VALUES ('taxonomy/term/3', 'taxonomy/term/', '', '', '301') in /var/alternc/html/drupal/sites/all/modules/path_redirect/path_redirect.module on line 144.
    * user warning: Duplicate entry 'taxonomy/term/4' for key 2 query: INSERT INTO drupal_path_redirect (path, redirect, query, fragment, type) VALUES ('taxonomy/term/4', 'taxonomy/term/', '', '', '301') in /var/alternc/html/drupal/sites/all/modules/path_redirect/path_redirect.module on line 144.
    * user warning: Duplicate entry 'taxonomy/term/5' for key 2 query: INSERT INTO drupal_path_redirect (path, redirect, query, fragment, type) VALUES ('taxonomy/term/5', 'taxonomy/term/', '', '', '301') in /var/alternc/html/drupal/sites/all/modules/path_redirect/path_redirect.module on line 144.

Here's my config:

Drupal 6.9
Pathauto 6.x-1.1
Path Redirect 6.x-1.0-beta1

Comments

Comment #1

Dave Reid

he/him

English

Nebraska USA

CreditAttribution: Dave Reid commented 11 March 2009 at 05:03

Status:

Active

» Postponed (maintainer needs more info)

Please upgrade to the latest versions of pathauto and path_redirect and let me know if the problem continues.

Comment #2

Jean-Philippe Fleury CreditAttribution: Jean-Philippe Fleury commented 14 March 2009 at 20:05

Hi,

I've updated and I've still a message error:

Les options de configuration ont été enregistrées.
Mise à jour en masse des termes terminée ; 2 alias générés.

user warning: Duplicate entry 'taxonomy/term/16-' for key 2 query: INSERT INTO drupal_path_redirect (path, redirect, language, type, last_used) VALUES ('taxonomy/term/16', 'taxonomy/term/', '', 301, 1237060805) in /var/alternc/html/drupal/includes/common.inc on line 3422.

My new config:

Drupal 6.10
Pathauto 6.x-1.1
Path Redirect 6.x-1.0-beta3

Comment #3

Dave Reid

he/him

English

Nebraska USA

CreditAttribution: Dave Reid commented 14 March 2009 at 20:08

Project:	Path redirect	» Pathauto
Version:	6.x-1.0-beta1	» 6.x-1.1
Status:	Postponed (maintainer needs more info)	» Closed (duplicate)

Make sure you are also using the latest version of pathauto, which is the 6.x-1.x-dev version.

This is a pathauto bug, duplicate of #278368: taxonomy_term_path being passed TID instead of Term Object.

Sorry greggles, hope you don't mind I keep moving these ones over to the pathauto issue queue.

Comment #4

Jean-Philippe Fleury CreditAttribution: Jean-Philippe Fleury commented 15 March 2009 at 14:24

OK, yes I confirm that with pathauto-6.x-1.x-dev, the bug is no longer there.

Thanks.

Comment #5

MountainX CreditAttribution: MountainX commented 21 May 2009 at 17:28

I did a bulk update of taxonomy terms and I got these errors in Drupal 6.12 with Pathauto 6.x-1.1 and Global Redirect 6.x-1.2.

If I install pathauto-6.x-1.x-dev, do I need to re-run the bulk update? Has any data been lost?

* user warning: Duplicate entry 'taxonomy/term/62-' for key 2 query: UPDATE url_alias SET src = 'taxonomy/term/', dst = 'taxonomy/term/62', language = '' WHERE pid = 90 in /var/www/drupal/modules/path/path.module on line 100.
* user warning: Duplicate entry 'taxonomy/term/63-' for key 2 query: UPDATE url_alias SET src = 'taxonomy/term/', dst = 'taxonomy/term/63', language = '' WHERE pid = 90 in /var/www/drupal/modules/path/path.module on line 100.
* user warning: Duplicate entry 'taxonomy/term/70-' for key 2 query: UPDATE url_alias SET src = 'taxonomy/term/', dst = 'taxonomy/term/70', language = '' WHERE pid = 90 in /var/www/drupal/modules/path/path.module on line 100.
* user warning: Duplicate entry 'taxonomy/term/71-' for key 2 query: UPDATE url_alias SET src = 'taxonomy/term/', dst = 'taxonomy/term/71', language = '' WHERE pid = 90 in /var/www/drupal/modules/path/path.module on line 100.
* user warning: Duplicate entry 'taxonomy/term/77-' for key 2 query: UPDATE url_alias SET src = 'taxonomy/term/', dst = 'taxonomy/term/77', language = '' WHERE pid = 90 in /var/www/drupal/modules/path/path.module on line 100.
* user warning: Duplicate entry 'taxonomy/term/80-' for key 2 query: UPDATE url_alias SET src = 'taxonomy/term/', dst = 'taxonomy/term/80', language = '' WHERE pid = 90 in /var/www/drupal/modules/path/path.module on line 100.
* user warning: Duplicate entry 'taxonomy/term/82-' for key 2 query: UPDATE url_alias SET src = 'taxonomy/term/', dst = 'taxonomy/term/82', language = '' WHERE pid = 90 in /var/www/drupal/modules/path/path.module on line 100.
* user warning: Duplicate entry 'taxonomy/term/84-' for key 2 query: UPDATE url_alias SET src = 'taxonomy/term/', dst = 'taxonomy/term/84', language = '' WHERE pid = 90 in /var/www/drupal/modules/path/path.module on line 100.
* user warning: Duplicate entry 'taxonomy/term/88-' for key 2 query: UPDATE url_alias SET src = 'taxonomy/term/', dst = 'taxonomy/term/88', language = '' WHERE pid = 90 in /var/www/drupal/modules/path/path.module on line 100.
* user warning: Duplicate entry 'taxonomy/term/98-' for key 2 query: UPDATE url_alias SET src = 'taxonomy/term/', dst = 'taxonomy/term/98', language = '' WHERE pid = 90 in /var/www/drupal/modules/path/path.module on line 100.
* user warning: Duplicate entry 'taxonomy/term/99-' for key 2 query: UPDATE url_alias SET src = 'taxonomy/term/', dst = 'taxonomy/term/99', language = '' WHERE pid = 90 in /var/www/drupal/modules/path/path.module on line 100.
* user warning: Duplicate entry 'taxonomy/term/104-' for key 2 query: UPDATE url_alias SET src = 'taxonomy/term/', dst = 'taxonomy/term/104', language = '' WHERE pid = 90 in /var/www/drupal/modules/path/path.module on line 100.
and many more...

UPDATE: I installed pathauto-6.x-1.x-dev and re-ran the bulk update. It reported 0 terms aliased and it showed no errors. I'm still not 100% sure that no damage was done previously, but everything seems OK now...

Comment #6

Mr Hamster CreditAttribution: Mr Hamster commented 18 July 2009 at 23:31

Version:

6.x-1.1

» 6.x-1.x-dev

I have installed pathauto-6.x-1.x-dev but i still have errors. I have them when i drag term up or down and save configurations

drupal-6.13

Comment #7

rootwork

he/him

English

🇺🇸 US-Pacific 🌎 Chinook (Multnomah, Clackamas) & Cowlitz lands 🌹 Portland, OR

CreditAttribution: rootwork commented 27 July 2009 at 11:12

I'm seeing this too. Even with the 1.x-dev version of pathauto, I get these errors. I'm running D6.13 as well.

Comment #8

greggles

he/him

English

Denver, Colorado, USA

CreditAttribution: greggles commented 29 July 2009 at 14:09

The dragging/saving is an interesting variation, but I haven't tested/confirmed it. Could you provide a simpletest that demonstrates the problem? That would help in debugging it.

Comment #9

HnLn CreditAttribution: HnLn commented 3 August 2009 at 17:47

I get this on saving a node after editing it (Duplicate entry 'taxonomy/term/x ... path/path.module on line 100). Although the error is thrown by path.module, disabling pathauto makes it go away.

In my particular case I have a hook_nodeapi that creates and saves a term with taxonomy_save_term when a node is inserted or updated (on insert it creates a term, on update it overwrites the existing one to ensure the term name corresponds with the node title). Commenting out taxonomy_save_term also makes it go away.

I coded around the problem by checking if the term name is different when saving after edit and only call taxonomy_save_term when it is. I would prefer this check to be done by pathauto or path though :-). Not sure who is responsible.

HnLn

Comment #10

pcorbett CreditAttribution: pcorbett commented 8 August 2009 at 18:13

I can confirm this as well. It seems to only happen with a specific parent/child pair of taxonomy terms I edit - not sure yet what is so special about them. I have not tried 1.x-dev yet. Disabling pathauto fixes the issue. The error looks like this:

    * user warning: Duplicate entry 'taxonomy/term/36-' for key 2 query: INSERT INTO url_alias (src, dst, language) VALUES ('taxonomy/term/', 'taxonomy/term/36', '') in /var/www/example.com/modules/path/path.module on line 112.
    * user warning: Duplicate entry 'articles/qsr-media-' for key 2 query: INSERT INTO url_alias (src, dst, language) VALUES ('taxonomy/term/36', 'articles/qsr-media', '') in /var/www/example.com/modules/path/path.module on line 112.
    * user warning: Duplicate entry 'taxonomy/term/38-' for key 2 query: INSERT INTO url_alias (src, dst, language) VALUES ('taxonomy/term/', 'taxonomy/term/38', '') in /var/www/example.com/modules/path/path.module on line 112.
    * user warning: Duplicate entry 'articles/qsr-media/newswire-' for key 2 query: INSERT INTO url_alias (src, dst, language) VALUES ('taxonomy/term/38', 'articles/qsr-media/newswire', '') in /var/www/example.com/modules/path/path.module on line 112.

Greggles, ping me if you want me to show you exactly what's happening. Sorry I don't have time to dive in and figure out exactly what's going on...

Comment #11

Bartezz CreditAttribution: Bartezz commented 13 August 2009 at 11:55

subscribing

Comment #12

Drupal webdesigner CreditAttribution: Drupal webdesigner commented 19 August 2009 at 10:45

Version:	6.x-1.x-dev	» 7.x-1.x-dev
Assigned:	Unassigned	» Drupal webdesigner
Priority:	Normal	» Critical

Sinds i update tha path auto, when i update my path's it doesn't change. The error it gave is gone when i updated to dev 2.x but i still doesn't work.
Anyone?