Skip navigation

Tag Archives: mysql

There is an issue with Drupal 6 menu router rebuild which causes Drupal to time out with 404 pages or internal 500.

The following fix worked for me:

Install Drupal Tweaks, increase php memory, and mysql recommendations etc

Download the following patches:

From command line copy patches to your root drupal directory.

cd to your root drupal directory and then apply the patches. Each time you will be asked where the file is for the patch and the actual path to the files to be patched will be provided in the command line. Just copy and paste each file path as presented into the prompt.

cp *.patch /home/drupal_directory/
cd /home/drupal_directory/
patch < no-router-blob-317775-56-D6.patch
patch < lock-251792-163-D6.patch

|--- includes/ (revision 7577)
|+++ includes/ (working copy)
File to patch: includes/

So in the above text you can see it gives you the path ‘includes/’. Just copy and paste that to where it says ‘File to patch:’. For each file it will provide you the correct path to the file assuming you are in the drupal root directory.

The final thing to do is to cp the file which is created to includes/

If you’ve created a new larger elastic block store volume from a snapshot with more disk space and size you will need to also resize the partition.

Read More »

If you’re moving or copying MySQL Binary files be sure to do the following:

Read More »

Here’s a nice post on setting up Nginx with PHP-FPM, Xcache on Debian Etch.

Read More »

Joomla 1.5 has an interesting quirk with Placehere Content Item Module.

Read More »

If you get the error:

mysqlimport: Error: Table ‘database.mydatabase’ doesn’t exist

Read More »

DELETE FROM `wp_comments` WHERE `wp_comments`.`comment_approved` = "spam";

Read More »

BigTable vs MySql – whats the difference?

Read More »

This guy has a great blog.  Some clever thoughts in a lot of areas and a pretty design.

10 Tips for Optimizing MySQL Queries (That don’t suck) | 20bits