delete from url_alias_extra as well as creating the entries
markfoodyburton - January 4, 2008 - 22:43
| Project: | Pathauto |
| Version: | 5.x-2.x-dev |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | postponed |
Jump to:
Description
delete from url_alias_extra using url_alias_extra left join node on node.nid=url_alias_extra.entity_id where node.nid is NULL;
it clears out the url_alias_extra table, for nodes that have been deleted.
Might be a good idea to fix the cause though :-)

#1
mmm - that's not a patch.
and yes, this needs to be fixed in the "normal" places (the delete operations for the different types of objects).
#2
see http://drupal.org/node/180440#comment-728092