sails-mysql is not working with sails -0.12.3.

[Farooq Hameed]

sails-mysql is not working with sails -0.12.3. I created a new app for test as shown below and it throws exceptions on lift also shown the stack trace at the end. 

Create a new SailsJS applicaiton. 

sails new STest 

npm install --save sails-mysql

sails generate api User

User.js

module.exports = {

  autoPK: false,

  tableName: 'user',

  attributes: {

    _id: {

      type: 'string',

      primaryKey: true,

      unique: true

    },

    name: {

      type: 'json',

      required: true

    }

  }

};

macmini2012:STest User1Sys$ sails lift

info: Starting app...

I

error: A hook (`orm`) failed to load!

error: Error (E_UNKNOWN) :: Encountered an unexpected error

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

    at Query.Sequence._packetToError (/Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/node_modules/mysql/lib/protocol/sequences/Sequence.js:48:14)

    at Query.ErrorPacket (/Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/node_modules/mysql/lib/protocol/sequences/Query.js:83:18)

    at Protocol._parsePacket (/Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/node_modules/mysql/lib/protocol/Protocol.js:280:23)

    at Parser.write (/Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/node_modules/mysql/lib/protocol/Parser.js:73:12)

    at Protocol.write (/Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/node_modules/mysql/lib/protocol/Protocol.js:39:16)

    at Socket.<anonymous> (/Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/node_modules/mysql/lib/Connection.js:96:28)

    at emitOne (events.js:77:13)

    at Socket.emit (events.js:169:7)

    at readableAddChunk (_stream_readable.js:146:16)

    at Socket.Readable.push (_stream_readable.js:110:10)

    at TCP.onread (net.js:523:20)

    --------------------

    at Protocol._enqueue (/Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/node_modules/mysql/lib/protocol/Protocol.js:141:48)

    at PoolConnection.query (/Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/node_modules/mysql/lib/Connection.js:201:25)

    at __DEFINE__ (/Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/lib/adapter.js:239:20)

    at afterwards (/Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/lib/connections/spawn.js:84:5)

    at /Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/lib/connections/spawn.js:40:7

    at Ping.onOperationComplete [as _callback] (/Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/node_modules/mysql/lib/Pool.js:99:5)

    at Ping.Sequence.end (/Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/node_modules/mysql/lib/protocol/sequences/Sequence.js:96:24)

    at Ping.Sequence.OkPacket (/Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/node_modules/mysql/lib/protocol/sequences/Sequence.js:105:8)

    at Protocol._parsePacket (/Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/node_modules/mysql/lib/protocol/Protocol.js:280:23)

    at Parser.write (/Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/node_modules/mysql/lib/protocol/Parser.js:73:12)

    at Protocol.write (/Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/node_modules/mysql/lib/protocol/Protocol.js:39:16)

    at Socket.<anonymous> (/Users/User1Sys/workspace/rnd/STest/node_modules/sails-mysql/node_modules/mysql/lib/Connection.js:96:28)

    at emitOne (events.js:77:13)

    at Socket.emit (events.js:169:7)

    at readableAddChunk (_stream_readable.js:146:16)

    at Socket.Readable.push (_stream_readable.js:110:10)

macmini2012:STest User1Sys$ 

[Farooq Hameed]

Further investigation should that the following causes this exception. 

```

    _id: {

      type: 'string',

      primaryKey: true,

      unique: true

    },

```

So any ideas to fix?