Drupal

Drupal 'Access Denied' errors for anonymous user

Posted July 30th, 2008 in

Drupal can be a pain. After a whole day of development, we started getting 'Access Denied' errors on all content that should be accessible by the anonymous user. The cause turned out to be something to do with a module incorrectly altering the node_access table.

Running this query fixed it:

Scaling Drupal for a heavy load site

Posted December 14th, 2007 in
We've recently been asked by a client to look into creating a Drupal installation that can cope with heavy load. Here's some useful instructions from johnandcailin.com. I'll post a follow-up in the near future explaining what we ended up doing and how successful it was.

Displaying categories in a Drupal block

Posted July 9th, 2006 in
PHP code to display up to 30 categores. 
<?php
if (user_access('access content')) 
{
	$result = db_query("SELECT d.tid, d.name, \ 
			COUNT(*) AS count FROM \
			{term_data} d INNER JOIN {term_node} \
			USING (tid) INNER JOIN {node} n USING (nid) \
			WHERE n.status = 1 GROUP BY d.tid, d.name \
			ORDER BY count DESC, d.name LIMIT 30");
	$items = array();
	while ($category = db_fetch_object($result))
	{
		$items[] = l($category->name .' ('. $category->count .')',
				'taxonomy/term/'. $category->tid);
	}
	return theme('item_list', $items);
}
?>

Web CMS platform comparison

in

Zope/Plone combination

  • Mature platform
  • Geared to more heavy-duty sites
  • Zope is an application server with a huge framework
  • Takes longer to understand