Posted By

tgbdad on 01/29/09

Tagged

mysql
drupal

Versions (?)

Last Edited at 01/29/09 05:10pm

Statistics

Viewed 1221 times

Favorited by 0 user(s)

Related snippets

Fix screwy URL aliases for project_issue nodes

/ Published in: MySQL

I currently have project_issue nodes set for replacement pattern issues/issue[nid] in Drupal 5.x PathAuto. This query fixes all of the URL aliases for entries created before this was set correctly.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

UPDATE url_alias SET dst = REPLACE(src,'node/','issues/issue') WHERE src IN (SELECT CONCAT('node/', CAST(nid as CHAR)) FROM node WHERE type = 'project_issue') AND dst NOT LIKE 'issues/issue%';