mysql utf8mb4: Specified key was too long; max key length is 767 bytes

Specified key was too long; max key length is 767 bytes

That error means you are trying to add unique index on a varchar(255) utf8mb4 column. In utf8mb4 column, each character needs 4 bytes. So 255 characters means 1020 bytes. The max key length is 767 bytes.


Do you really need 255 characters?..if not reduce it.

change_column :attachments, :message_uuid, :string, :limit => 38


If you really need all 255 characters, consider using this innodb setting.

So its Charlie Sheen who invented the Kickstarter rewards scheme in 1993

So its Charlie Sheen who invented the Kickstarter rewards scheme in 1993

Watch from 4:06 minutes onwards if the video does not start at that time.


Reward1: For $15 you get a hot shots T-Shirt

Reward2: For $25, a hat and T-Shirt

Reward n: For $20,000, you get billing above the title.

He also holds the fundraising record as well, raised 4.5 Million in 2.5 hours.

Git : Stage Hunk and Discard Hunk (SourceTree)

Hunk means a piece of change in the Git world. Stage hunk means it is being added to the staging area.

Discard Hunk means remove the change without trace.

Replace the word ‘hunk’ with ‘change’ and it becomes pleasurable to follow Git.

Screen Shot 2014-08-01 at 12.25.32 PM

If you don’t want to commit your change , you will have to discard your changes (hunks). God knows why the Git geeks chose “hunk” but it is what it is. Learn to love it and other idiosyncrasies(stash,rebase, to survive in Gitland.

Skitch issues

Skitch on Mac is a  better alternative to the in-built Preview tool.. for adding annotations on pictures.

The only idiotic design flaw is the need to configure Evernote to save  pictures. I simply want to take a screenshot and add some annotation and save it.

Screen Shot 2013-11-17 at 6.34.21 PM

Why Evernote crap in the middle?. It beats the whole purpose of being a super simple annotation tool.

SharePoint 2013: Client Object Model errors when migrated from SharePoint 2010

There are multiple ways to phrase this problem

1. processQuery gives 403 forbidden in sharepoint 2013

2. sp.runtime.js Client OM x-requestdigest

The problem is due to the old sp.runtime.js and sp.core.js files.


By including  the new versions of the Client Object Model javascript files.. as shown below, the error goes away.


The old files are in the  /_layouts/ directory where as the new files in the /_layouts/15/ directory.