I am currently an Architect at Babson College, heading up providing Drupal services at the college. We're currently working on LMS type features, and we're creating portals for the different departments, and other forms and tools for the college. Barnettech still takes on some side consulting work. Be in touch regarding any of our modules posted on drupal.org, or to speak about consulting, Drupal, or Education.

Battery problems partial fix for OSX LION Macbook Pro Users

Wiki Terms: 

This restored my Mac Book to a usable state while using the battery -- battery lasted 3 hours instead of 45 minutes

1. Turn off the computer.
2. Hold down Ctrl+Option+shift
3. While holding down these button, press and hold the power button as well.
4. Hold all buttons for at least ten seconds.
5. power back on the computer.

Finding duplicates in a MYSQL table

Wiki Terms: 

Finding duplicates in a MYSQL table

select name, count(name) as cnt
from term_data
group by name
having cnt > 1
order by cnt;

Drupal 7 xmlsitemap problems solved

Wiki Terms: 

Did you get a nasty error from your Drupal 7 sitemap module that looked like this:

If your mac terminal application takes a long time to open

If your mac terminal application takes a long time to open you need to trim some log files:

cd /private/var/log/asl/

sudo rm *.asl

Managing multiple ssh keys

Wiki Terms: 

linkback: http://www.karan.org/blog/index.php/2009/08/25/multiple-ssh-private-keys

ssh-keygen -t rsa -f ~/.ssh/id_rsa.acquia -C "Key for my Acquia accounts"
touch ~/.ssh/config
chmod 600 ~/.ssh/config

~/.ssh/config looks like this :

Host *acquia*
  IdentityFile ~/.ssh/id_dsa.home
  User jbarnett

Host *babson*
  IdentityFile ~/.ssh/id_rsa.work
  User jbarnett
  Port 44787

Run a drush command on all of your sites in a multisite

To run a drush command on all of your sites in a multisite

go to your drupal root directory ie: /var/www/html/babsondev/docroot

and then run

drush @sites user-create testuser
drush @sites user-password someuser --password="gr3@tP@$s"

this will create a user on all of your sites. To get a site list you can do

drush sa | grep -v @

I will be releasing the DROOGLE MODULE SHORTLY

Wiki Terms: 

I will be releasing the DROOGLE module shortly which integrates Drupal with GOOGLE DOCS and it also provides it so you can easily manage your Google account's users, permissions, etc.

New site I've created http://www.dancetunes.org

Working with Dancetunes.org their new site designed and developed by Barnettech is up and running. If you love the dance scene, are looking for great dancing, and want to know the best tunes to liven up your routines, or just love the music check out the new site: http://www.dancetunes.org

Setup Ubuntu with SSL (for Drupal)

Wiki Terms: 

I have this working, SSL is setup for Drupal 7

1.) At the bottom of apache2.conf file in /etc/apache2

#setup name based virtual hosting instead of IP based (JLB)
NameVirtualHost *:443
NameVirtualHost *:80

2.) In /etc/apache2/sites-available/default-ssl

db_query in Drupal 7

Wiki Terms: 

Here's a linkback for a nice guy who's made a db_query cheat sheet for Drupal 7.

http://www.drupaler.co.uk/blog/drupal-7-cheat-sheet-database/493

Also here is a simple drupal 7 query:

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer