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



read more


Also
    
        Login to post comments
Feed: ProofGroup.com
Original article



      
            


  
  



  Popular

  
    
  
  
      
      
    
            
  
                working copy path ‘foo’ does not exist in repository.
  

            
  
                The Mason's Apron: Clawhammer Banjo Tablature
  

            
  
                Blues Scale in D for Mandolin
  

            
  
                On the Subject of Freemasonry
  

            
  
                Cigar Box Guitar #1, Part I
  

      
    
  
  
  
  
  
  
 
  




  



  



  Recently Perused

  
    
  
  
      
      
    
            
  
                Resume Objectives
  

            
  
                It's Beginning to Look Somewhat Like Christmas
  

            
  
                An interesting Analogy for Hacking
  

            
  
                Lonesome George (1)
  

            
  
                Resizing Multiple Images from the Terminal in OS X
  

      
    
  
  
  
  
  
  
 
  



  Twitter

  
    
  
  
      
      
    
            
  
                On the ground in BOS. they don't call em red eyes for nothing
  
       —   
  
                4 years 12 weeks ago
  

            
  
                Really? Your ringtone is 'The Star Spangled Banner'?
  
       —   
  
                4 years 12 weeks ago
  

            
  
                Checked in & through security at OAK.  Looking forward to getting home after yet another good #drupalcon.
  
       —   
  
                4 years 12 weeks ago
  

            
  
                Delving into the #drupal views API.  My brain hurts.
  
       —   
  
                4 years 12 weeks ago
  

            
  
                Would welcome recommendations for example code for defining custom relationships for #drupal views
  
       —   
  
                4 years 12 weeks ago
  

      
    
  
      ‹‹
34 of 84
››
  
  
      

  
    more



  
    
      

  Recently

  
    
  
  
      
      
    
            
  
                Tempis Fugit
  

            
  
                Lucy Neal (Minstrel Banjo & Bones)
  

            
  
                Congo Prince Jig (Early/Minstrel Banjo)
  

            
  
                Walk into the Parlor Jig (Early/Minstrel Banjo)
  

            
  
                Get up in the Morning (Early/Minstrel Banjo)
  

      
    
  
  
  
  
  
  
 
  

    
    
      

  Older

  2014July (1)

2011October (1)
August (4)

2010August (2)
May (3)
March (2)
February (3)
January (6)

2009December (3)
November (1)
October (1)
September (2)
August (2)
July (2)
June (2)
April (3)
March (2)
February (10)
January (11)

2008December (4)
November (2)
October (1)
September (1)
August (3)
July (1)
January (4)

2007December (1)
October (3)
September (5)
July (1)
June (2)
May (10)
April (11)
March (2)

2006December (1)
November (6)
October (6)
September (4)
August (8)
July (5)
June (7)
May (8)
April (23)
March (16)
February (12)
January (21)

2005December (19)
November (31)
October (4)
September (2)
August (2)
May (2)
April (7)
March (5)
February (4)
January (21)

2004December (8)
November (11)
October (5)
September (3)
August (8)
July (5)
June (10)
May (22)
April (4)
March (9)
February (20)
January (41)

2003December (5)
October (8)
September (2)
August (2)
June (4)
May (2)
April (1)
March (7)

2002October (2)
September (3)
August (4)
July (2)
May (7)
April (5)
March (6)
February (26)
January (8)

2001December (35)
November (40)
October (13)
September (1)
March (3)
February (4)

2000December (2)
September (1)


  

    
    
      

  Contact

  
Andy Chase
    
(978) 297-6402
 
andychase [at] gmail.com
    
GPG/PGP Public Key


  

    
  

          
                          © 1996-2010 by Andy Chase