SQL general error 1005 and errno 150

SQLSTATE[HY000]: General error: 1005 Can’t create table ‘mydatabase.#sql-c7c_81e’ (errno: 150) My issue was that the Foreign Key didn’t match the type of field I was trying to use as reference. id (source) = int(10) – unsigned foreign = int(11) Foreign … Continued

Command line productivity

There is nothing more rewarding than creating shortcuts for your daily work routines, and what better than when using the command line. Problem: You have to create a directory and then cd to it after creation. Solution: Open your blash_profile … Continued

JQuery and dynamic elements

I have been working with JQuery on a couple of work and personal projects and I really like the library. One of my first challenges was to access elements dynamically and at the same time trigger custom events. This is … Continued

Covert mov files to flv with ffmpeg

The shell script below will take files from the folder you are running it from and convert all “mov” files to “flv”. The script can be updated to use the same file name as flv name. Since this is not … Continued

TextMate current block folding

Having the ability to fold blocks of code in TextMate can be a great time saver. Specially if you are working on a rather large file and you are trying to concentrate only in one area of your code. You … Continued