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

  
    
  
  
      
      
    
            
  
                The Mason's Apron: Clawhammer Banjo Tablature
  

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

            
  
                Blues Scale in D for Mandolin
  

            
  
                On the Subject of Freemasonry
  

            
  
                Cigar Box Guitar #1, Part I
  

      
    
  
  
  
  
  
  
 
  




  



  



  Recently Perused

  
    
  
  
      
      
    
            
  
                An in-depth write-up of another Ebay Special
  

            
  
                Bones Module: Development Release for Drupal 6
  

            
  
                Another Cheap Ebay Fiddle Tale
  

            
  
                The $25 eBay Fiddle
  

            
  
                Searching the Drupal Database by Regular Expression
  

      
    
  
  
  
  
  
  
 
  



  Twitter

  
    
  
  
      
      
    
            
  
                I just ousted Sean W. as the mayor of Athol Masonic Temple on @foursquare! http://t.co/tPzQAraJ
  
       —   
  
                4 weeks 18 hours ago
  

            
  
                Score! http://t.co/KVDyULXM
  
       —   
  
                11 weeks 2 days ago
  

            
  
                @ComcastBill Thanks.
  
       —   
  
                11 weeks 6 days ago
  

            
  
                @wstites Thanks.  @comcast is making it awfully hard for me to give them more money.
  
       —   
  
                11 weeks 6 days ago
  

            
  
                @comcastbill(have called 4 or 5 numbers so far. Am told I don't qualify as existing customer, no way to track who it was who called me.)
  
       —   
  
                11 weeks 6 days ago
  

      
    
  
       
1 of 81
››
  
  
      

  
    more



  
    
      

  Recently

  
    
  
  
      
      
    
            
  
                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)
  

            
  
                Ethiopian Cracovienne (Early/Minstrel Banjo)
  

      
    
  
  
  
  
  
  
 
  

    
    
      

  Older

  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