Richard's blog

Quick Tip: Drupal Drush Out of Memory Error on Ubuntu

Posted Tue, 08/03/2010 - 09:49 by Richard

I recently started running into out of memory errors while running Drupal's awesome Drush module from the command line to update a sites modules.

This is odd as on my dev machine I've set up my php.ini to reserve 512MB of RAM (memory_limit=512M). That should be plenty!

I temporally upped the RAM to 2GB(!!) and was still getting out of memory errors when running Drush!

PHP function any_in_array - tests if any of $needles are in $haystack

Posted Fri, 07/30/2010 - 14:47 by Richard

Just a quick post. You might find this useful. It compares one array ($needles) against another ($haystack) and returns true if any element of $needles is present in $haystack

MySQL: Disable foreign keys while updating database

Posted Sat, 01/30/2010 - 08:51 by Richard

Originally found here: http://www.stetsenko.net/2008/10/mysql-how-to-ignore-checking-of-foreign-key-constraints-for-innodb-tables/

Making a note of it here because it always take me a while to find the above article.

You can switch off checking of foreign keys while you truncate/populate the tables in a MySQL database with:

SET FOREIGN_KEY_CHECKS = 0;

and re-enable it with:

CakePHP Quick tip: Adding CSS links to $scripts_for_layout in 1.3

Posted Thu, 11/19/2009 - 06:03 by Richard

Got caught with this one upgrading from an older version of CakePHP to 1.3

In your view, to add a css file to the $script_for_layout variable, you used to do this:

<?php $html->css("css_file", null, array(), false); ?>

In 1.3, you have to change this to:

Quick CakePHP Tip: Prefix/Admin Routing and form->create()

Posted Mon, 08/24/2009 - 14:12 by Richard

A quick tip to get your forms to play nice with admin routing:

/views/users/edit.ctp

<?php echo $form->create("User", array("url" => $html->url(array("admin" => true), true))) ?>

Why? For some reason, $form->create() ignores the usual routing prefix attribute ("admin"=>true) so you have to pass the url through $html->url() which does take prefix routing into account.

einstein_www

Posted Wed, 07/01/2009 - 15:42 by Richard

einstein_www
Originally uploaded by richardathome

Add new comment

CakePHP: Extend PaginatorHelper to indicate sort field and direction

Posted Thu, 05/28/2009 - 21:07 by Richard

Here's a quick piece of code that extends the default CakePHP PaginatorHelper
to add css classes to the sort column links to indicate which field is being sorted by,
and which direction:

/app/views/helpers/ex_paginator.php:

CakePHP: Pagination with Containable

Posted Mon, 04/20/2009 - 10:45 by Richard

Took me a little while to work this out so I'm blogging it here in the hopes it will help someone in the future:

Need to Contain your Paginated data?

in your controller:

$this->paginate = array(
	"contain"=>array(
		// usual contain array
	)
);
 
$this->set("data", $this->paginate("Model"));

For example, to bring back and paginate a User (id, first_name, last_name) and their Title (Mr, Mrs, etc.):

/app/users_controller.php

Must Have Software

Posted Fri, 04/17/2009 - 06:18 by Richard

I'm about to put together a new PC at home. Here's a mental reminder to myself about what software I can't live/work without:

CakePHP: Smarter links

Posted Wed, 04/08/2009 - 12:16 by Richard

The Problem

There's a couple of things I wish were present in CakePHP's excellent HtmlHelper.

Links should automatically add a class to themselves when they are a) pointing to a resource in the same controller and b) pointing to themselves.
Able to show/hide themselves.

Why is #1 important? Imagine a primary navigation that runs across the top of a page:

Richard@Home