SQL error when creating redirect

Thu, 04/15/2010 - 10:09 - augustin
Project:Web site
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:active
Description

user warning: Duplicate entry '' for key 2 query: INSERT INTO linux_path_redirect (path, redirect, type, last_used) VALUES ('', 'node/29', 301, 1271325843) in includes/common.inc on line 3477.
Created new alias wiki/system/filesystem for node/29, replacing wiki/filesystem. wiki/filesystem now redirects to wiki/system/filesystem
Wiki page filesystem has been updated.

I often (always?) have this error when pathauto is trying to create a redirect from an old path alias to the newest one.
The result is that the front page redirect to some random page and the intended redirect is not created.
To fix the problem manually, I need to go to admin/build/path-redirect and delete the redirect where the 'from' is empty.

Comments

#1

augustin - 04/15/2010 - 10:17

see that!
http://drupal.org/project/issues/pathauto?order=last_comment_timestamp&s...

#2

augustin - 05/07/2010 - 13:46

bump.