Viewing events attached to elements via JavaScript
If like myself, you often attach functions to elements using jQuery, for example: $(‘.btnName’).live(‘click’, function() { //do something }); There is a nice little browser extension that will show all the elements on the page with a little bubble outlining the attached events/functions. It is written by Allan Jardine, and you can get it from [...]
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 server version for the right syntax to use near ‘USING BTREE, KEY `index` (`fields`)’ at line 1 It worked fine before, so why won’t ant [...]
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 NULL, part_number VARCHAR(50) NOT NULL, PRIMARY KEY (inventory_id), KEY category_part_number (category, part_number), KEY discriminator_column (discriminator_column) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE inventory_room( inventory_id INT 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 Zend with a simple text file. To access the externals file, navigate to the root of your site: > cd /var/www/mysite And add the external [...]
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 line.