MySQL Error in create table syntax ‘USING BTREE’
We had an odd thing today, whilst performing a apply-db-changes we received the error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL…
Setting up Class Table Inheritance with Doctrine 2.0
Have had some serious problems getting this working, but after a 4 hour head bashing session, we’ve cracked it. CREATE TABLE inventory( inventory_id INT AUTO_INCREMENT, discriminator_column VARCHAR(20), category VARCHAR(50) NOT…
SVN Externals – how to add them
When creating a Zend Framework site, its always best to keep the Zend library as an external source. This way you can keep the branch up-to-date with the release of…
Add all new files to SVN
How to recursively add all new files to SVN > svn add --force * Saves a whole bunch of time when committing a load of new pages via the command…
Keeping 2 drives sync’ed with rsync on Linux
I have an external USB HDD and I like to keep it synchronised with my desktop for backup reasons. I find the easiest way to do this, is to use…
Get rid of Apple Test Advertisment from iPhone SpringBoard
I get constantly annoyed by the test apple advert on my phone’s springboard after I’ve quit an app. But I think I worked out how to stop it: Install iFile…
HOWTO: Rotate a video in Linux
I videoed something at the weekend on my iphone, but must’ve had the phone upside-down so the video came out that way. Fortunately there is a little program that will…
Stopping Ubuntu opening F-Spot when I plug in my iPhone
When I installed Ubuntu, every time I plugged in my iPhone it popped up a prompt asking me what to do about the digital music/photos. After clicking “do nothing” for…
Automatic Windows Process Dump Script
I have a laborious task at the moment, of exporting our server process list to see how much memory certain programs are using. I was getting a little bored of…