Update url-aliase for nodes of a specific content type

Question

I'm using drupal 7 in combination with path auto. I imported nodes of a specific content type using the feed importer, but the url alias is not set correctly.

My problem is, that i can not use the bulk update for content paths, because there is other content, that was migrated manually and that uses non generic url-aliases.

Is there a way to trigger the bulk alias update for a specific content type?

Answer 1

• To update URL for Existing Contents You could go to admin/content
• In Update Options, You can choose Update URL alias after filtering a specific content type

Answer 2

In the settings you can chose what updating needs to do if there already is an alias. Under 'Update action' select 'Do nothing. Leave the old alias intact'. Then do a bulck update.

Answer 3

If you're comfortable using SQL, you can do the bulk operation against the database without involving Drupal.

I'd recommend testing the query against a slave, staging or non-production instance of the database to verify the results first, just to be safe:

SELECT alias FROM node
JOIN url_alias
ON CONCAT('node/', node.nid) = url_alias.source
WHERE node.type= 'machine_name';

After you've carefully reviewed the query to verify the results, perform the actual delete:

DELETE url_alias FROM node
JOIN url_alias
ON CONCAT('node/', node.nid) = url_alias.source
WHERE node.type = 'machine_name';

If you don't have access to MySQL database or Drush, you can perform the operation by using a custom Views Bulk Operation or by using Drush:

$ drush sql-query "DELETE url_alias FROM node [...]"

Answer 4

If anyone is looking for Drupal 8 version of this SQL it's a bit messy. We had a content type called web_site which had /content/.... as the URL alias. We needed this to be /website/.... The machine name of the content type in question is 'web_site'. See query below:-

update path_alias pa
set alias = concat('/website/',substring_index(substring_index(pa.alias,'/',-1),'/',1))
where pa.path like '/node/%' 
and substring_index(substring_index(pa.path,'/',-1),'/',1) 
in (select nid from node where type = 'web_site');

NOte: checking the existing path contains /node/% ensures we don't update aliases for users, files, etc...