Drupal

Drupal Book node hierarchy went missing, necessitating database patching and a couple scripts to help

Twice now I've had the Book hierarchy on a Drupal 6 site go bonkers. The first time was on this very site, back in 2009, while this site was being converted from Drupal 5 to Drupal 6 (it's now on Drupal 7). The /book page simply became empty, and I managed to fix the book hierarchy with some database twiddling. That was over six years ago and I'd since converted this site to Drupal 7. I have another site still running Drupal 6, and the same problem (empty /book page) just happened on that site.

Drupal & Blogger user tries Wordpress after years of sneering, and likes it

wordpress-logo-stacked-rgb.pngThe other night talking with my girlfriend about developing a website for her, we decided that she needed a Wordpress blog. She's done quite a lot with Blogger blogs and is very familiar with them, but the goals she had were impossible given Blogger's limitations. While Drupal is a very powerful system and could have done what she wanted, it's not exactly user friendly.

Migrate module can be alternate Drupal upgrade process, not just for importing foreign content

The originating purpose of the Drupal Migrate module is to import content from elsewhere. Where? Wordpress .. etc. Any place outside of Drupalsphere. The good thing is that the module is fairly open about what it will import, and therefore it's possible to import into a Drupal site from a Drupal site. And that by doing so, one can upgrade a Drupal site without going through the official Upgrade process.

Why might you want to do this?

Generating clean URL's for paginated content on Drupal sites

One of my clients wants his paginated content to have clean URL's. That is, Drupal sites frequently generate sequences of pages with "?page=##" query parameters to select each page. But he doesn't want this as a query parameter, but instead in the URL. The idea we're working on is to decrease the chance of duplicate content on the site as recorded by Google in the Webmaster Tools.

Unfortunately there really isn't a way to do this. Except for the Clean Pagination module https://drupal.org/project/cleanpager

Add a Google CSE to a Drupal 7 site without using google_cse module

The https://drupal.org/project/google_cse module appears to be a dead project - the Drupal 7 port hasn't had any activity in over 2 years. If you want to use a Google Custom Search Engine (CSE) on a Drupal 7 site, what do you do? Turns out it's relatively straight-forward to just generate the CSE over on Google's website, take the code and paste it into a Block, and that's it.

Successfully hosting Drupal on nginx on Dreamhost - a Dreamhost Drupal Hosting Adventure

Among the standard performance recommendations for Drupal is to switch to the nginx web server.  Because of nginx's design it's much more performant than Apache, supposedly.  I don't know enough myself about nginx to say why it's better, other than having an understanding that nginx has an event-oriented architecture that's cleaner than Apache's.

Potential and fix for Drupal xmlsitemap module to not index nodes

I want to share the solution for a problem I (and it seems others) have had with the Drupal xmlsitemap module. The problem results in zero nodes being indexed in the sitemap which, of course, is an undesired result because the purpose of xmlsitemap is to reliably inform search engines of the nodes on your site so they can more easily index your site. Telling the search engine "I have no nodes" is a kiss of death in terms of getting traffic, that is until the search engine spiders your site and finds everything that way. But they don't spider sites every day.

Pages