Invalid default value for \'end\'
If i'm try to start shinobi, i've got this problem.
{ Error: ER_INVALID_DEFAULT: Invalid default value for 'end'
at Query.Sequence._packetToError (/opt/Shinobi/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
at Query.ErrorPacket (/opt/Shinobi/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)
at Protocol._parsePacket (/opt/Shinobi/node_modules/mysql/lib/protocol/Protocol.js:291:23)
at Parser._parsePacket (/opt/Shinobi/node_modules/mysql/lib/protocol/Parser.js:433:10)
at Parser.write (/opt/Shinobi/node_modules/mysql/lib/protocol/Parser.js:43:10)
at Protocol.write (/opt/Shinobi/node_modules/mysql/lib/protocol/Protocol.js:38:16)
at Socket.<anonymous> (/opt/Shinobi/node_modules/mysql/lib/Connection.js:91:28)
at Socket.<anonymous> (/opt/Shinobi/node_modules/mysql/lib/Connection.js:525:10)
at emitOne (events.js:115:13)
at Socket.emit (events.js:210:7)
at addChunk (_stream_readable.js:250:12)
at readableAddChunk (_stream_readable.js:237:11)
at Socket.Readable.push (_stream_readable.js:195:10)
at TCP.onread (net.js:586:20)
--------------------
at Protocol._enqueue (/opt/Shinobi/node_modules/mysql/lib/protocol/Protocol.js:144:48)
at Connection.query (/opt/Shinobi/node_modules/mysql/lib/Connection.js:201:25)
at /opt/Shinobi/node_modules/knex/lib/dialects/mysql/index.js:144:18
at Promise._execute (/opt/Shinobi/node_modules/knex/node_modules/bluebird/js/release/debuggability.js:313:9)
at Promise._resolveFromExecutor (/opt/Shinobi/node_modules/knex/node_modules/bluebird/js/release/promise.js:488:18)
at new Promise (/opt/Shinobi/node_modules/knex/node_modules/bluebird/js/release/promise.js:79:10)
at Client_MySQL._query (/opt/Shinobi/node_modules/knex/lib/dialects/mysql/index.js:135:12)
at Client_MySQL.query (/opt/Shinobi/node_modules/knex/lib/client.js:192:17)
at Runner.<anonymous> (/opt/Shinobi/node_modules/knex/lib/runner.js:138:36)
at Runner.tryCatcher (/opt/Shinobi/node_modules/knex/node_modules/bluebird/js/release/util.js:16:23)
at Runner.query (/opt/Shinobi/node_modules/knex/node_modules/bluebird/js/release/method.js:15:34)
at /opt/Shinobi/node_modules/knex/lib/runner.js:47:21
at tryCatcher (/opt/Shinobi/node_modules/knex/node_modules/bluebird/js/release/util.js:16:23)
at /opt/Shinobi/node_modules/knex/node_modules/bluebird/js/release/using.js:185:26
at tryCatcher (/opt/Shinobi/node_modules/knex/node_modules/bluebird/js/release/util.js:16:23)
at Promise._settlePromiseFromHandler (/opt/Shinobi/node_modules/knex/node_modules/bluebird/js/release/promise.js:517:31)
code: 'ER_INVALID_DEFAULT',
errno: 1067,
sqlMessage: 'Invalid default value for \'end\'',
sqlState: '42000',
index: 0,
sql: 'CREATE TABLE IF NOT EXISTS `Timelapses` (`ke` varchar(50) NOT NULL,`mid` varchar(50) NOT NULL,`details` longtext,`date` date NOT NULL,`time` timestamp NOT NULL,`end` timestamp NOT NULL,`size` int(11)NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;' }
Edited by yuen-tuen lee