Drupal: Finding Uncategorized Nodes
30 Jan, 2009
If you’re working with a site with a lot of nodes, especially nodes that have been migrated out of another CMS or blogging tool, you’ll probably find yourself wondering which nodes are floating around without any taxonomy terms, so that you can go back and make sure they’re duly categorized.
Getting a raw list of node ID’s and titles is simple with the following SQL query, which you can execute from the MySQL command line client, or PHPMyAdmin (which your web host’s admin panel probably provides):
Also
- Login to post comments
- Feed: ProofGroup.com
- Original article
Popular
Recently Perused
- It's about time http://flic.kr/p/8GcTE9 — 3 years 44 weeks ago
- Don't use twitter much any more, ayuh. — 3 years 45 weeks ago
- Lazyweb: Does there exist a #drupal module for selectively disabling CCK fields without deleting them? Perhaps field permissions... — 3 years 45 weeks ago
- New post: Old Joe (Minstrel Banjo) http://tinyurl.com/3yyg8g9 — 3 years 49 weeks ago
- New post: Emacs Org-mode: Custom agenda that filters by date AND tag http://tinyurl.com/2vnrcl2 — 3 years 49 weeks ago