How to replace HTML tags and text in a Drupal database using phpMyAdmin and SQL

Drupal cms logo Did you validate your drupal website and realize you need to replace some unclosed HTML4 tags with XHTML strict self-closing tags? Or maybe you're adding in some ARIA roles to make your text a bit more accessible.

Lo and behold: you will suddenly need to use your web host's phpmyadmin interface and SQL to find and replace strings of text in drupal's database.

Don't panic! Here's how you do it.

Catalyzing Drupal collaboration & coding at your institution

Rock Eagle logoEnjoy the slides, resources, and install profile code from my "Catalyzing Drupal Collaboration & Coding at Your Institution" presentation, given at Rock Eagle on October 25, 2012.

ReMIX South 2012 - Twitter highlights

conference logo Unable to attend ReMix South in Atlanta (October 19-20, 2012), but find twitter streams a bit overwhelming, lacking in context, or chronologically confusing?

Your solution: a re-organized, select set of tweets for each of the sessions. Please post comments if I've missed (or completely mis-categorized) any particularly good tweets!

How to Recover after updating to webform_civiCRM 6.x-2.4 when your Drupal 6 site uses civiCRM 3.x

Drupal & CiviCRM logos combined Are you using Drupal 6's webform module with CiviCRM version 3.x? Did you install the webform_civiCRM-6.x-2.4 module, and your site stopped creating civiCRM contact links for your webform reports?

First: re-set your site to use webform_civiCRM-6.x-2.3 and re-create the auto-assignment of civiCRM groups for each webform.

Next, if any webform submissions were created before you realized the problem and re-set your site as described above, follow the below steps to re-create links for those submissions.

How to send email notifications for comments in Drupal 7 with actions & triggers (or the Rules module)

Rules module logo Do you have a Drupal 7 web site? Do you want to get an email when someone comments, so you don't have to check your site all the time? Don't panic! Here's how you do it.

You don't need to install any new modules to do this in Drupal 7. All that's needed is a little configuring and to copy and paste in a short bit of code.

Update: Both the easiest & most powerful way to get these notification emails (in Drupal 6 or 7) is to install and configure the Rules Module. NodeOne has a great set of video tutorials on their site explaining how to use the Rules module. I've also put example code for a Rules-based email notification in the comments to this post for both Drupal 6 and Drupal 7

Essential links for making informed decisions in the DeKalb, Georgia Presidential Primary Election (March 6, 2012)

Georgia state seal

Just in case you’ve forgotten: the Georgia Presidential Primary is on Tuesday, March 6, 2012 and you must Register to Vote by February 6 in order to vote in this election!

Here are some links that might help you figure out which candidates you prefer: