Blogs

Settings up Drush on a Windows PC

The problem with Drush on Windows

Windows just isn't geared up to work with Drush out the box for things like site alises, sql-sync, rsync etc.

The Solution

Site aliases

Site alias commands involving SSH will fail because drush will use single quotes rather than double quotes. To solve this, you just need to add a os setting to the drush alias file like this: -

site:
  os: Windows

That's it. Now when the command is concatenated, it will know you are using Windows and use the double-quotes.

Drupal and GDPR (General Data Protection Regulation)

Disclaimer

If probably goes without saying, but we are Drupal experts and not GDPR lawyers. We have tried our best to outline our understanding of the new requirements and how this impacts Drupal sites - this page does not in any way constitute legal advice.

Using Batch API in Drupal 7 - Batch API Tutorial

Drupal's batch API processing is awesome and offers two great benefits: -

You can break long tasks into smaller batches, preventing max_execution_time errors
You can give the visitor (or more likely administration or developer) some feedback

Building a batch routine in a custom module requires a minimum of 4 function including the batch function call: -

Aptana Studio "Not Responding" at startup

So this is strictly Drupal, but it's a useful post which will hopefully help others who may have this problem.

I use PHPStore or Aptana Studio 3 for developing in Drupal. Aptana is a great IDE in my opinion. Occasionally it gets into a mess and hangs every time I launch it and Windows reports and Aptana Studio 3 is not responding - very annoying.

The simple fix is to remove the .markers file from the project which could be causing the issue. This file (as far as I know) contains break points, so you'd need to re-add them to your project.

PHPMYADMIN import from local file

Again, this is really a note to myself, but here is a query to import CSV data on the server: -

LOAD DATA LOCAL 
INFILE '<path_to_file>' 
INTO TABLE `<table_name>` FIELDS 
TERMINATED BY ',' LINES TERMINATED BY '\n'
IGNORE 1 LINES

N.B. You have to make sure the structure is already in place.

Overriding PHP.ini settings in Drupal's settings.php file

Here are a couple of useful tips for making development and debugging easier. I've written this primarily as a note for myself but maybe it's prove useful to others as well.

To force PHP to display any errors in Drupal on screen instead of just 500 server error pages add these lines: -

ini_set('error_reporting', E_ALL);
	ini_set('display_errors', 'stdout');
	

To up the memory limit add this line: -

	ini_set('memory_limit', '64M');

Thanks to Mollom's own api this is simple. Here's a snippet that we recently used to protect a custom password recovery form: -

Drupology

the full service Drupal digital marketing agency