File: //var/www/javago-api-updates/output.log
nohup: ignoring input
(node:29559) ExperimentalWarning: Importing JSON modules is an experimental feature and might change at any time
(Use `node --trace-warnings ...` to show where the warning was created)
Connection has been established successfully.
listening on port 6000
[0mPOST /auth/guest [32m200[0m 119.001 ms - 385[0m
[0mPUT /auth/fcm-update [32m202[0m 52.263 ms - 51[0m
[0mGET /auth/notification/count [32m200[0m 51.481 ms - 56[0m
[0mGET /cafe/go-to-orders [32m200[0m 74.983 ms - 47[0m
[0mGET /cafe/filter?page=1 [32m200[0m 14.212 ms - 1449[0m
[0mPOST /cafe/list [32m200[0m 60.710 ms - 4308[0m
[0mGET /cafe/go-to-orders [32m200[0m 32.585 ms - 1935[0m
[0mGET /cafe/filter?page=1 [32m200[0m 43.620 ms - 1449[0m
[0mGET /auth/notification/count [32m200[0m 28.918 ms - 56[0m
[0mPOST /cafe/list [32m200[0m 39.026 ms - 4492[0m
[0mPUT /auth/fcm-update [32m202[0m 6.430 ms - 51[0m
[0mPOST /auth/guest [32m200[0m 100.648 ms - 385[0m
[0mGET /auth/notification/count [32m200[0m 6.368 ms - 56[0m
[0mPUT /auth/fcm-update [32m202[0m 18.721 ms - 51[0m
[0mGET /cafe/go-to-orders [32m200[0m 18.351 ms - 47[0m
[0mGET /cafe/filter?page=1 [32m200[0m 8.337 ms - 1449[0m
[0mPOST /cafe/list [32m200[0m 34.044 ms - 4308[0m
[0mPOST /cafe/detail [32m200[0m 14.339 ms - 1577[0m
[0mGET /cafe/item-category?cafe_id=82&page=1 [32m200[0m 74.160 ms - 468[0m
[0mGET /cafe/item?menu_id=1455&page=1&filter=1,2,3 [32m200[0m 20.902 ms - 3512[0m
[0mPOST /cafe/item-detail [32m200[0m 16.137 ms - 1161[0m
[0mPOST /cafe/create-go-to-order [32m200[0m 14.337 ms - 587[0m
[0mGET /cafe/go-to-orders [32m200[0m 6.647 ms - 800[0m
[0mGET /in-house/get-order [32m200[0m 10.437 ms - 58[0m
Error
at Query.run (/var/www/api.javaapp.co.uk/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)
at /var/www/api.javaapp.co.uk/node_modules/sequelize/lib/sequelize.js:315:28
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async Module.getGroupList (file:///var/www/api.javaapp.co.uk/src/services/group/group.services.js:377:22)
at async getGroupList (file:///var/www/api.javaapp.co.uk/src/controllers/group/group.controller.js:178:18) {
name: 'SequelizeDatabaseError',
parent: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
original: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: {}
}
[0mGET /group/get-group-list?page=1 [31m500[0m 11.017 ms - 61[0m
[0mGET /cafe/filter?page=1 [32m200[0m 21.410 ms - 1449[0m
[0mGET /cafe/go-to-orders [32m200[0m 15.528 ms - 800[0m
[0mGET /cafe/go-to-orders [32m200[0m 9.481 ms - 800[0m
[0mGET /in-house/get-order [32m200[0m 5.713 ms - 58[0m
Error
at Query.run (/var/www/api.javaapp.co.uk/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)
at /var/www/api.javaapp.co.uk/node_modules/sequelize/lib/sequelize.js:315:28
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async Module.getGroupList (file:///var/www/api.javaapp.co.uk/src/services/group/group.services.js:377:22)
at async getGroupList (file:///var/www/api.javaapp.co.uk/src/controllers/group/group.controller.js:178:18) {
name: 'SequelizeDatabaseError',
parent: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
original: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: {}
}
[0mGET /group/get-group-list?page=1 [31m500[0m 8.479 ms - 61[0m
[0mGET /cafe/go-to-orders [32m200[0m 9.309 ms - 800[0m
[0mGET /in-house/get-order [32m200[0m 5.409 ms - 58[0m
[0mGET /auth/notification/count [32m200[0m 13.802 ms - 56[0m
[0mGET /cafe/go-to-orders [32m200[0m 11.469 ms - 800[0m
[0mGET /cafe/filter?page=1 [32m200[0m 8.090 ms - 1449[0m
[0mPUT /auth/fcm-update [32m202[0m 7.225 ms - 51[0m
[0mPOST /cafe/list [32m200[0m 46.427 ms - 4308[0m
Error
at Query.run (/var/www/api.javaapp.co.uk/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)
at /var/www/api.javaapp.co.uk/node_modules/sequelize/lib/sequelize.js:315:28
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async Module.getGroupList (file:///var/www/api.javaapp.co.uk/src/services/group/group.services.js:377:22)
at async getGroupList (file:///var/www/api.javaapp.co.uk/src/controllers/group/group.controller.js:178:18) {
name: 'SequelizeDatabaseError',
parent: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
original: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: {}
}
[0mGET /group/get-group-list?page=1 [31m500[0m 6.001 ms - 61[0m
[0mGET /cafe/go-to-orders [32m200[0m 9.273 ms - 800[0m
[0mGET /cafe/filter?page=1 [32m200[0m 9.703 ms - 1449[0m
[0mPOST /cafe/list [32m200[0m 35.158 ms - 4308[0m
[0mPOST /auth/sign-up [32m201[0m 3104.455 ms - 44[0m
[0mPOST /auth/verify-otp [32m200[0m 17.519 ms - 500[0m
[0mGET /auth/app-version?os_type=2 [32m200[0m 11.878 ms - 328[0m
[0mGET /cafe/go-to-orders [32m200[0m 47.915 ms - 800[0m
[0mGET /auth/notification/count [32m200[0m 45.401 ms - 56[0m
[0mPUT /auth/fcm-update [32m202[0m 43.385 ms - 51[0m
[0mGET /cafe/filter?page=1 [32m200[0m 39.357 ms - 1449[0m
[0mPOST /cafe/list [32m200[0m 33.874 ms - 4308[0m
Error
at Query.run (/var/www/api.javaapp.co.uk/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)
at /var/www/api.javaapp.co.uk/node_modules/sequelize/lib/sequelize.js:315:28
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async Module.getGroupList (file:///var/www/api.javaapp.co.uk/src/services/group/group.services.js:377:22)
at async getGroupList (file:///var/www/api.javaapp.co.uk/src/controllers/group/group.controller.js:178:18) {
name: 'SequelizeDatabaseError',
parent: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
original: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: {}
}
[0mGET /group/get-group-list?page=1 [31m500[0m 13.062 ms - 61[0m
[0mGET /cafe/go-to-orders [32m200[0m 69.750 ms - 1935[0m
[0mGET /auth/notification/count [32m200[0m 66.851 ms - 56[0m
[0mGET /cafe/filter?page=1 [32m200[0m 89.896 ms - 1449[0m
[0mPOST /cafe/list [32m200[0m 32.933 ms - 4492[0m
[0mPUT /auth/fcm-update [32m202[0m 6.176 ms - 51[0m
Error
at Query.run (/var/www/api.javaapp.co.uk/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)
at /var/www/api.javaapp.co.uk/node_modules/sequelize/lib/sequelize.js:315:28
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async Module.getGroupList (file:///var/www/api.javaapp.co.uk/src/services/group/group.services.js:377:22)
at async getGroupList (file:///var/www/api.javaapp.co.uk/src/controllers/group/group.controller.js:178:18) {
name: 'SequelizeDatabaseError',
parent: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 300 OR `group_members`.`user_id` = 300) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
original: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 300 OR `group_members`.`user_id` = 300) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 300 OR `group_members`.`user_id` = 300) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: {}
}
[0mGET /group/get-group-list?page=1 [31m500[0m 9.257 ms - 61[0m
[0mGET /cafe/go-to-orders [32m200[0m 11.642 ms - 1935[0m
[0mGET /cafe/filter?page=1 [32m200[0m 9.682 ms - 1449[0m
[0mPOST /cafe/list [32m200[0m 30.457 ms - 4492[0m
Error
at Query.run (/var/www/api.javaapp.co.uk/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)
at /var/www/api.javaapp.co.uk/node_modules/sequelize/lib/sequelize.js:315:28
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async Module.getGroupList (file:///var/www/api.javaapp.co.uk/src/services/group/group.services.js:377:22)
at async getGroupList (file:///var/www/api.javaapp.co.uk/src/controllers/group/group.controller.js:178:18) {
name: 'SequelizeDatabaseError',
parent: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 300 OR `group_members`.`user_id` = 300) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
original: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 300 OR `group_members`.`user_id` = 300) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 300 OR `group_members`.`user_id` = 300) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: {}
}
[0mGET /group/get-group-list?page=1 [31m500[0m 5.962 ms - 61[0m
[0mGET /cafe/go-to-orders [32m200[0m 15.352 ms - 1935[0m
[0mGET /cafe/filter?page=1 [32m200[0m 15.923 ms - 1449[0m
[0mPOST /cafe/list [32m200[0m 47.863 ms - 4492[0m
[0mPOST /cafe/detail [32m200[0m 9.600 ms - 3268[0m
[0mGET /cafe/item-category?cafe_id=82&page=1 [32m200[0m 46.480 ms - 468[0m
[0mGET /cafe/item?menu_id=1455&page=1&filter=1,2,3 [32m200[0m 13.572 ms - 3512[0m
[0mPOST /cafe/item-detail [32m200[0m 10.512 ms - 1161[0m
[0mPOST /cafe/update-go-to-order [32m200[0m 15.453 ms - 48[0m
[0mGET /cafe/go-to-orders [32m200[0m 7.746 ms - 2480[0m
[0mGET /in-house/get-order [32m200[0m 11.404 ms - 58[0m
[0mGET /auth/notification/count [32m200[0m 8.903 ms - 56[0m
[0mGET /cafe/go-to-orders [32m200[0m 25.736 ms - 760[0m
[0mPUT /auth/fcm-update [32m202[0m 23.251 ms - 51[0m
[0mGET /cafe/filter?page=1 [32m200[0m 36.178 ms - 1449[0m
[0mPOST /cafe/list [32m200[0m 28.044 ms - 4308[0m
Error
at Query.run (/var/www/api.javaapp.co.uk/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)
at /var/www/api.javaapp.co.uk/node_modules/sequelize/lib/sequelize.js:315:28
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async Module.getGroupList (file:///var/www/api.javaapp.co.uk/src/services/group/group.services.js:377:22)
at async getGroupList (file:///var/www/api.javaapp.co.uk/src/controllers/group/group.controller.js:178:18) {
name: 'SequelizeDatabaseError',
parent: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 358 OR `group_members`.`user_id` = 358) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
original: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 358 OR `group_members`.`user_id` = 358) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 358 OR `group_members`.`user_id` = 358) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: {}
}
[0mGET /group/get-group-list?page=1 [31m500[0m 8.151 ms - 61[0m
[0mGET /cafe/go-to-orders [32m200[0m 21.199 ms - 760[0m
[0mGET /cafe/filter?page=1 [32m200[0m 21.491 ms - 1449[0m
[0mPOST /cafe/list [32m200[0m 37.861 ms - 4308[0m
[0mPOST /auth/sign-in [32m200[0m 99.758 ms - 495[0m
[0mGET /auth/app-version?os_type=2 [32m200[0m 6.662 ms - 328[0m
[0mGET /cafe/go-to-orders [32m200[0m 9.312 ms - 800[0m
[0mPUT /auth/fcm-update [32m202[0m 13.211 ms - 51[0m
[0mGET /cafe/filter?page=1 [32m200[0m 5.463 ms - 1449[0m
[0mPOST /cafe/list [32m200[0m 37.185 ms - 4308[0m
Error
at Query.run (/var/www/api.javaapp.co.uk/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)
at /var/www/api.javaapp.co.uk/node_modules/sequelize/lib/sequelize.js:315:28
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async Module.getGroupList (file:///var/www/api.javaapp.co.uk/src/services/group/group.services.js:377:22)
at async getGroupList (file:///var/www/api.javaapp.co.uk/src/controllers/group/group.controller.js:178:18) {
name: 'SequelizeDatabaseError',
parent: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
original: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: {}
}
[0mGET /group/get-group-list?page=1 [31m500[0m 23.944 ms - 61[0m
Error
at Query.run (/var/www/api.javaapp.co.uk/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)
at /var/www/api.javaapp.co.uk/node_modules/sequelize/lib/sequelize.js:315:28
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async Module.getGroupList (file:///var/www/api.javaapp.co.uk/src/services/group/group.services.js:377:22)
at async getGroupList (file:///var/www/api.javaapp.co.uk/src/controllers/group/group.controller.js:178:18) {
name: 'SequelizeDatabaseError',
parent: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
original: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: {}
}
[0mGET /group/get-group-list?page=1 [31m500[0m 30.967 ms - 61[0m
[0mGET /auth/notification/count [32m200[0m 8.739 ms - 56[0m
[0mGET /cafe/filter?page=1 [32m200[0m 6.057 ms - 1449[0m
[0mGET /cafe/go-to-orders [32m200[0m 6.895 ms - 47[0m
[0mPOST /cafe/list [32m200[0m 27.717 ms - 4308[0m
[0mPUT /auth/fcm-update [32m202[0m 6.077 ms - 51[0m
[0mGET /cafe/filter?page=1 [32m200[0m 6.643 ms - 1449[0m
[0mPUT /auth/fcm-update [32m202[0m 12.894 ms - 51[0m
[0mGET /cafe/go-to-orders [32m200[0m 17.399 ms - 800[0m
[0mGET /auth/notification/count [32m200[0m 9.710 ms - 56[0m
[0mPOST /cafe/list [32m200[0m 25.948 ms - 4308[0m
Error
at Query.run (/var/www/api.javaapp.co.uk/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)
at /var/www/api.javaapp.co.uk/node_modules/sequelize/lib/sequelize.js:315:28
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async Module.getGroupList (file:///var/www/api.javaapp.co.uk/src/services/group/group.services.js:377:22)
at async getGroupList (file:///var/www/api.javaapp.co.uk/src/controllers/group/group.controller.js:178:18) {
name: 'SequelizeDatabaseError',
parent: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
original: Error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at Packet.asError (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packets/packet.js:728:17)
at Query.execute (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/www/api.javaapp.co.uk/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_WRONG_FIELD_WITH_GROUP',
errno: 1055,
sqlState: '42000',
sqlMessage: "Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.group_members.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: undefined
},
sql: 'SELECT `groups`.`id`, `groups`.`created_by`, `groups`.`group_name`, `groups`.`group_profile`,`groups`.`group_code`,`groups`.`created_at`, `group_members`.`user_id` FROM `groups` INNER JOIN `group_members` ON `groups`.`id` = `group_members`.`group_id` WHERE (`groups`.`created_by` = 393 OR `group_members`.`user_id` = 393) AND `groups`.`is_active` = 1 GROUP BY `id` ORDER BY `id` DESC LIMIT 0, 10;',
parameters: {}
}
[0mGET /group/get-group-list?page=1 [31m500[0m 5.715 ms - 61[0m
[0mGET /auth/notification/count [32m200[0m 5.737 ms - 56[0m
[0mGET /cafe/go-to-orders [32m200[0m 13.159 ms - 800[0m
[0mPUT /auth/fcm-update [32m202[0m 12.636 ms - 51[0m
[0mGET /cafe/filter?page=1 [32m200[0m 6.143 ms - 1449[0m
[0mPOST /cafe/list [32m200[0m 28.979 ms - 4308[0m