drupal

Using MYSQLDUMP to backup a database

If you have a shell or SSH access to your database server, you can backup the database using mysqldump. By default, the output of the command will dump the contents of the database in SQL statements to your console. Here are some tips on how to get special results such as over a SSH connection,

drop-down menus in the Drupal theme CTI-flex

The suckershish menus in CTI_flex are afflicted with a common problem in many suckerfish implementations. There is a small gap between the parental branch and the leaves. If the font is set larger than expected the dropdown will disappear when the user doesn't pause above the parent and moves the mouse down which can get frustrating.

Using drupal's taxonomy for navigation

"Taxonomy" in Drupal is the native way to categorize nodes. So what do you do with the nodes created? You can use it for navigation purposes. A link will get you all nodes with a specific taxonomy set and it can use some boolean logic (and, or or).

Turning Drupal maintenance mode on or off (site offline/online) with mySQL

If you are already on the Linux command line or inside MySQL and need to take a site off-line for maintenance then you may prefer to simply enter the following than log into Drupal and manipulate the setup.
  • check if on or offline
    SELECT * FROM variable WHERE name='site_offline'

all pages on a Drupal web site won't display (page not found)

You migrate you database from a dump but all of a sudden no page is found. No matter what you do you get a 'no page is found'.

views and 5stars

In a Drupal6 installation, you want to use a user rating from 5stars in a View. This might be to sort a list by the highest rating first, limit a list to those above a certain rating, or to display the rating in a view.

This article assumes you are familiar with the inner workings of Views, 5stars, and have them both installed- including the 'Views UI' module.

There are two potential stumbling blocks here. You need to have the 5star ratings enabled for the content-type you are using, and you have to establish a 'relationship' in the views you are going to use.

IE limits

Sometimes a Drupal site will work fine when you use a browser other than Internet Explorer but be completely unformated in IE. It seems to be a problem with the way Drupal organizes Cascading Style Sheets and IE. The fix is usually simple.

It seems that Internet Explorer stops loading style sheets after about 31. I've read different numbers but they are all close to 31.

migrating or backing up your Drupal Database

There are many options when it comes to backup and migrate. I'll be going to mention all of them, but describing mysqldump and the problems that can occur in depth.

Basically; you can use Drupal modules, the CLI program mysqldump, or just copy the files that represent the database tables.

9 steps to an image of heaven - a photo gallery in Drupal6

There are dozens of articles with instructions on how to create a Drupal photo gallery. It almost seems obligatory to do so if you are going to blog about Drupal so here goes. This is how I handle photos and instructions on how to create a nice looking Drupal gallery in 9 steps. I'll explain some of the steps and why you'll take them.

This article is not a step-by-step instruction list so you'll need some level of understanding of computers and Drupal specifically. I'll be explaining what needs to be done, why it needs to be done, and how I do it.

ambiguity to a t()

The t() function is probably the most misunderstood function in the Drupal-verse. At the risk of sounding sacrilegious: Why is it there and where is should it be used? Does it really increase my sites security?
Syndicate content