Create a bootable OS X El Capitan installer

This is how to create a OS X El Capitan installer on a flash disk or external disk.

Download OS X El Capitan from the App Store. When it finishes downloading, quit the installer. The “Install OS X El Capitan” application should be in your /Applications folder. On a side note even if you do not create a bootable installer, it’s a good idea to get a backup of this installer before running it. After upgrading your system, the installer will remove itself.

Format a flash stick Mac OS Extended (Journaled) with GUID Partition Table

Name the disk “Untitled”. Simply because the command below references the disk by the “Untitled” name.

In Terminal, run:

sudo /Applications/Install\ OS\ X\ El\ –volume /Volumes/Untitled –applicationpath /Applications/Install\ OS\ X\ El\ –nointeraction

Changing Calendar Colors on a Jailbroken iPhone running iOS 5

iOS 5 changed the database that deals with Calendar colors. The value is now a hex value just like CSS uses (something like #fe6548)

– Install sqlite3 via Cydia (you must have Cydia in “Developer” mode so it lists the command-line utilities)

– ssh to your iPhone (as user mobile)

– Run sqlite3 and open the calendar database

iPhone:~ mobile$ sqlite3 /var/mobile/Library/Calendar/Calendar.sqlitedb

– Issue the SQL commands to change the calendar colors:

sqlite> UPDATE Calendar SET color='#9FC6E7' WHERE title = 'Chris Carey';
sqlite> UPDATE Calendar SET color='#FF7537' WHERE title = 'Work';
sqlite> UPDATE Calendar SET color='#D06B64' WHERE title = 'Important';
sqlite> UPDATE Calendar SET color='#B3DC6C' WHERE title = 'School';
sqlite> UPDATE Calendar SET color='#4986E7' WHERE title = 'Chris & Nasique';
sqlite> UPDATE Calendar SET color='#AC725E' WHERE title = 'Health';

-Quit sqlite3


-Quit ssh


If needed, kill the calendar app or reboot the phone to get it to reload the new colors

Twitter API, PHP precision and scientific notation

If you use PHP and the Twitter API, be on the lookout for this issue.

Twitter IDs are up to 141 quadrillion (141 million billion). These Twitter IDs exceed PHP’s default precision of 14. So your Twitter IDs could be converted to scientific notation by PHP.

A Twitter ID of 141675395434037249 will be stored as 1.41675395434037249E+17 once PHP gets it’s hands on it.

This could cause code that has been working great for a while to stop working.

Edit your php.ini and set precision to 20, or use
ini_set(‘precision’, 20);

Debian squeeze

Here is what you need if you have some binary on Debian squeeze which wants

sudo dpkg -i libmysqlclient15off_5.0.51a-24+lenny5_i386.deb