All items tagged with "MySQL"All items tagged with "MySQL"

Drupal: Finding Uncategorized Nodes

by andy January 30, 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):

Tags:

Searching the Drupal Database by Regular Expression

by andy December 18, 2008

I found myself wanting to use regular expressions to find some imported Drupal nodes containing broken old image paths. Naturally, I went looking for a module that might accommodate me and I did find the Scanner module. Unfortunately the site I was working with is in Drupal 6, and I didn't have the time to work on a Drupal 6 port of what looks like a pretty sophisticated module just to find a few nodes.

Tags:

Connecting to MySQL via ESS in a shared or virtual hosting environment

by andy April 10, 2008

A fairly common question when preparing to integrate your web application’s MySQL database into a FileMaker solution using ESS (External SQL Sources) is, “What information do I need from my hosting provider to connect to MySQL?”

The list is pretty straightforward, and you’ll probably have an easier time asking your hosting company for these MySQL specifics than trying to explain FileMaker ESS:

Tags: