I'm receiving reoccurring duplicate entry errors in my Drupal log which say the following:
Duplicate entry 'blog/2009/03/16/blog-title' for key 'dst_language' query: UPDATE url_alias SET src = 'node/45', dst = 'blog/2009/03/16/blog-title', language = '' WHERE pid = 557 in /drupal/modules/path/path.module on line 100.
I've looked at the code around the line the error is referring and it appears the path.module should be deleting the existing path if there is one and creating a new one. However the error is correct in saying that there is a duplicate entry. For nodes that I receive this error on there are more than one entry for the same node with same "src" and "dst" values but different "pid" values. I'm not sure what could be causing this, nodes still save fine and can be viewed at the specified path fine but I'm sure there shouldn't be duplicate entries in this table. Any help?