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.

Option1:

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

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

Option2:

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

http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_large_prefix

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.

https://www.youtube.com/watch?v=nuj2Q06miP0#t=246

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

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.

Solution:

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

Image

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