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 :-)

Comments

greggles’s picture

Title: Pathauto needs a dose of this from time to time » delete from url_alias_extra as well as creating the entries
Status: Needs work » Active

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).

greggles’s picture

Status: Active » Postponed
dave reid’s picture

Status: Postponed » Closed (won't fix)

I think 5.x versions are closed to feature requests and this doesn't apply to the 6.x versions.