1. Lack of attention to title tags or leaving title tags as automatically generated on important pages or having duplicate titles. The single most important thing you can do to improve Drupal SEO is improve page titles - Page Title module
2. No quality backlinks. This will take a huge effort, back-links or inbound links from related sites, suppliers and clients will help bring traffic and build SEO. For goodness sake do not buy back-links.

I've been working on the Drupal 6.x dev version of the Andreas03 theme (http://drupal.org/project/andreas03) for which there is no left sidebar region. I was kind of stuck on the regions where on a fresh installation, enabling the theme automatically put the navigation/login in the header by default.

I've recently changed the submitted date on my blog posts and added a little CSS magic, thanks to Jonathan Snook's article on Text Rotation with CSS

Essentially it's a few lines of code, I didn't show the full CSS, there is a fair bit more to it than below. Feel free to Inspect Elements on my node teasers to see the inner workings.

Being a good citizen I've put up a nice upgrade informational pop-up for visitors still using IE6. This has been in place for over a year.

I decided to stop being polite about it and out-right ban IE6 users from my site with a big nasty message and no content. Really, enough is enough it's freaking 9 years since release. Are you people retarded? This has to be my biggest irritation when developing corporate sites but IE6 compatibility is still a requirement for these guys.

** Note for IE6 users: I absolutely refuse to allow your stinky browser from tainting my access logs. **

This is an awesome trick for hiding your e-mail address e-mail harvesting bots.

HTML

CSS

The result: moc.elpmaxe@sirhc

Performing a case-sensitive search-and-replace through a table is easy with MySQL when you know how.

UPDATE table_name SET table_field = REPLACE(table_field, 'replace_that', 'with_this');

This has proved useful for updating Drupal's files table where the paths are incorrect. I hope this helps someone

I needed to add a body class for node edit pages. Heres the code for template.php

I wanted an edit icon on my views edit node links. Using the views field template I added the following to the template file: views-view-field--edit-node.tpl.php

Now all my views have a nice edit icon for each node row. The image:

And to go one step further, display the edit icon only when hovering the row this is added to the css.

I wanted something different to replace the ajax animated gif (Drupal throbber) so here it is:

Also, see my post Change throbber.gif in Drupal for instructions on replacing throbber.gif without effecting core.

To replace core Drupal ajax animated gif (throbber.gif) add the following to your theme's CSS and put the replacement throbber.gif file in the images folder of your theme.