· 9 years ago · Oct 14, 2016, 06:24 AM
1Successfully initialized database
2
3Running migrations...
4
5Sequelize [Node: 6.6.0, CLI: 2.4.0, ORM: 3.24.3, mysql: ^2.11.1]
6
7Loaded configuration file "config/config.json".
8Using environment "development".
9== 20161012113003-create-user: migrating =======
10== 20161012113003-create-user: migrated (0.032s)
11== 20161012113434-create-event: migrating =======
12{ SequelizeDatabaseError: ER_INVALID_DEFAULT: Invalid default value for 'endTime'
13 at Query.formatError (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/sequelize/lib/dialects/mysql/query.js:175:14)
14 at Query._callback (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/sequelize/lib/dialects/mysql/query.js:49:21)
15 at Query.Sequence.end (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/protocol/sequences/Sequence.js:85:24)
16 at Query.ErrorPacket (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/protocol/sequences/Query.js:94:8)
17 at Protocol._parsePacket (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/protocol/Protocol.js:280:23)
18 at Parser.write (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/protocol/Parser.js:74:12)
19 at Protocol.write (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/protocol/Protocol.js:39:16)
20 at Socket.<anonymous> (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/Connection.js:109:28)
21 at emitOne (events.js:96:13)
22 at Socket.emit (events.js:188:7)
23 at readableAddChunk (_stream_readable.js:176:18)
24 at Socket.Readable.push (_stream_readable.js:134:10)
25 at TCP.onread (net.js:543:20)
26 name: 'SequelizeDatabaseError',
27 message: 'ER_INVALID_DEFAULT: Invalid default value for \'endTime\'',
28 parent:
29 { Error: ER_INVALID_DEFAULT: Invalid default value for 'endTime'
30 at Query.Sequence._packetToError (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/protocol/sequences/Sequence.js:51:14)
31 at Query.ErrorPacket (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/protocol/sequences/Query.js:83:18)
32 at Protocol._parsePacket (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/protocol/Protocol.js:280:23)
33 at Parser.write (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/protocol/Parser.js:74:12)
34 at Protocol.write (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/protocol/Protocol.js:39:16)
35 at Socket.<anonymous> (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/Connection.js:109:28)
36 at emitOne (events.js:96:13)
37 at Socket.emit (events.js:188:7)
38 at readableAddChunk (_stream_readable.js:176:18)
39 at Socket.Readable.push (_stream_readable.js:134:10)
40 at TCP.onread (net.js:543:20)
41 --------------------
42 at Protocol._enqueue (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/protocol/Protocol.js:141:48)
43 at Connection.query (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/Connection.js:214:25)
44 at /Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/sequelize/lib/dialects/mysql/query.js:40:21
45 at Promise._execute (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/bluebird/js/release/debuggability.js:299:9)
46 at Promise._resolveFromExecutor (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/bluebird/js/release/promise.js:481:18)
47 at new Promise (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/bluebird/js/release/promise.js:77:14)
48 at Query.run (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/sequelize/lib/dialects/mysql/query.js:39:17)
49 at /Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/sequelize/lib/sequelize.js:849:20
50 at /Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/retry-as-promised/index.js:38:21
51 at Promise._execute (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/bluebird/js/release/debuggability.js:299:9)
52 at Promise._resolveFromExecutor (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/bluebird/js/release/promise.js:481:18)
53 at new Promise (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/bluebird/js/release/promise.js:77:14)
54 at retryAsPromised (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/retry-as-promised/index.js:27:10)
55 at /Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/sequelize/lib/sequelize.js:848:12
56 at tryCatcher (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/bluebird/js/release/util.js:16:23)
57 at Promise._settlePromiseFromHandler (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/bluebird/js/release/promise.js:510:31)
58 code: 'ER_INVALID_DEFAULT',
59 errno: 1067,
60 sqlState: '42000',
61 index: 0,
62 sql: 'CREATE TABLE IF NOT EXISTS `Events` (`id` INTEGER NOT NULL auto_increment , `ownerId` INTEGER NOT NULL, `picture` VARCHAR(255) NOT NULL, `title` VARCHAR(255) NOT NULL, `description` TEXT NOT NULL, `startTime` TIMESTAMP NOT NULL, `endTime` TIMESTAMP NOT NULL, `accessPolicy` INTEGER NOT NULL, `location` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, PRIMARY KEY (`id`), FOREIGN KEY (`ownerId`) REFERENCES `Users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB;' },
63 original:
64 { Error: ER_INVALID_DEFAULT: Invalid default value for 'endTime'
65 at Query.Sequence._packetToError (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/protocol/sequences/Sequence.js:51:14)
66 at Query.ErrorPacket (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/protocol/sequences/Query.js:83:18)
67 at Protocol._parsePacket (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/protocol/Protocol.js:280:23)
68 at Parser.write (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/protocol/Parser.js:74:12)
69 at Protocol.write (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/protocol/Protocol.js:39:16)
70 at Socket.<anonymous> (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/Connection.js:109:28)
71 at emitOne (events.js:96:13)
72 at Socket.emit (events.js:188:7)
73 at readableAddChunk (_stream_readable.js:176:18)
74 at Socket.Readable.push (_stream_readable.js:134:10)
75 at TCP.onread (net.js:543:20)
76 --------------------
77 at Protocol._enqueue (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/protocol/Protocol.js:141:48)
78 at Connection.query (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/mysql/lib/Connection.js:214:25)
79 at /Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/sequelize/lib/dialects/mysql/query.js:40:21
80 at Promise._execute (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/bluebird/js/release/debuggability.js:299:9)
81 at Promise._resolveFromExecutor (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/bluebird/js/release/promise.js:481:18)
82 at new Promise (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/bluebird/js/release/promise.js:77:14)
83 at Query.run (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/sequelize/lib/dialects/mysql/query.js:39:17)
84 at /Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/sequelize/lib/sequelize.js:849:20
85 at /Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/retry-as-promised/index.js:38:21
86 at Promise._execute (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/bluebird/js/release/debuggability.js:299:9)
87 at Promise._resolveFromExecutor (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/bluebird/js/release/promise.js:481:18)
88 at new Promise (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/bluebird/js/release/promise.js:77:14)
89 at retryAsPromised (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/retry-as-promised/index.js:27:10)
90 at /Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/sequelize/lib/sequelize.js:848:12
91 at tryCatcher (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/bluebird/js/release/util.js:16:23)
92 at Promise._settlePromiseFromHandler (/Users/scottlee/Desktop/Tech/miscreant-warthog/node_modules/bluebird/js/release/promise.js:510:31)
93 cMigrations failed!