Blog posts

Firefox images getting extra space when in table cell

Disclaimer: OK - so I know I shouldn't be using tables, but sometimes, I just have to. Was trying to figure out this extra space around an image that was sitting in a table cell. Came across this article which explains why. It's to do with using a strict doctype, and the fact that the images are by default inline which display on top of the baseline. Quick fix for me was to apply the following style to the offending images: .header-image {display:block}

Drupal CCK email field errors: "doesn't have a default value query"

Ran into this error a couple of times before when adding content to a CCK email field in MySQL 5.0.27: user warning: Field 'field_email_email' doesn't have a default value query: It seems the email field is initially set up to not allow null values. To fix this check out this patch or just update the field in phpMyAdmin: ALTER TABLE `table_name` CHANGE `field_email_email` `field_email_email` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL

How Drupal's CCK already provides a safely formatted cck field for display

Came across an interesting post when investigating some "n/a" text appearing in a CCK node field when not logged in. I was using the code echo content_format('field_description', $field_description[0]); to safely format and output the description field. Not sure exactly why it happens but it turns out that there's no need to actually do it that way as CCK already provides a safe string of that field for outputting to the browser that is already formatted accordingly.

Drupal path not available to anonymous users in view block

I created a view in drupal with some argument handling code. This code loaded the node so as to get the value of the path alias. I then used this path alias as a taxonomy argument for the view: if ($type == 'block' && arg(0)=='node') { $node = node_load(arg(1)); $path = $node->path; $args = array(); $args[0] = ''; if (!empty($path)) { $args[0] = $path; } return $args; }

phpMyAdmin "Save as file" file name template

When using phpMyadmin to backup a MySQL database, there is an option near the bottom to save as a file. When you use this option, you can make your life easier by using a file name template that automatically names the backup file for you. By default it is the database name, but I find it useful to put a timestamp on it as well. To do that, use the following in the file name template field: %Y%m%d%H%M%S-__DB__ This will save your files in the following format: 20070815152612-databasename.sql