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
POST /auth/guest 200 119.001 ms - 385
PUT /auth/fcm-update 202 52.263 ms - 51
GET /auth/notification/count 200 51.481 ms - 56
GET /cafe/go-to-orders 200 74.983 ms - 47
GET /cafe/filter?page=1 200 14.212 ms - 1449
POST /cafe/list 200 60.710 ms - 4308
GET /cafe/go-to-orders 200 32.585 ms - 1935
GET /cafe/filter?page=1 200 43.620 ms - 1449
GET /auth/notification/count 200 28.918 ms - 56
POST /cafe/list 200 39.026 ms - 4492
PUT /auth/fcm-update 202 6.430 ms - 51
POST /auth/guest 200 100.648 ms - 385
GET /auth/notification/count 200 6.368 ms - 56
PUT /auth/fcm-update 202 18.721 ms - 51
GET /cafe/go-to-orders 200 18.351 ms - 47
GET /cafe/filter?page=1 200 8.337 ms - 1449
POST /cafe/list 200 34.044 ms - 4308
POST /cafe/detail 200 14.339 ms - 1577
GET /cafe/item-category?cafe_id=82&page=1 200 74.160 ms - 468
GET /cafe/item?menu_id=1455&page=1&filter=1,2,3 200 20.902 ms - 3512
POST /cafe/item-detail 200 16.137 ms - 1161
POST /cafe/create-go-to-order 200 14.337 ms - 587
GET /cafe/go-to-orders 200 6.647 ms - 800
GET /in-house/get-order 200 10.437 ms - 58
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: {}
}
GET /group/get-group-list?page=1 500 11.017 ms - 61
GET /cafe/filter?page=1 200 21.410 ms - 1449
GET /cafe/go-to-orders 200 15.528 ms - 800
GET /cafe/go-to-orders 200 9.481 ms - 800
GET /in-house/get-order 200 5.713 ms - 58
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: {}
}
GET /group/get-group-list?page=1 500 8.479 ms - 61
GET /cafe/go-to-orders 200 9.309 ms - 800
GET /in-house/get-order 200 5.409 ms - 58
GET /auth/notification/count 200 13.802 ms - 56
GET /cafe/go-to-orders 200 11.469 ms - 800
GET /cafe/filter?page=1 200 8.090 ms - 1449
PUT /auth/fcm-update 202 7.225 ms - 51
POST /cafe/list 200 46.427 ms - 4308
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: {}
}
GET /group/get-group-list?page=1 500 6.001 ms - 61
GET /cafe/go-to-orders 200 9.273 ms - 800
GET /cafe/filter?page=1 200 9.703 ms - 1449
POST /cafe/list 200 35.158 ms - 4308
POST /auth/sign-up 201 3104.455 ms - 44
POST /auth/verify-otp 200 17.519 ms - 500
GET /auth/app-version?os_type=2 200 11.878 ms - 328
GET /cafe/go-to-orders 200 47.915 ms - 800
GET /auth/notification/count 200 45.401 ms - 56
PUT /auth/fcm-update 202 43.385 ms - 51
GET /cafe/filter?page=1 200 39.357 ms - 1449
POST /cafe/list 200 33.874 ms - 4308
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: {}
}
GET /group/get-group-list?page=1 500 13.062 ms - 61
GET /cafe/go-to-orders 200 69.750 ms - 1935
GET /auth/notification/count 200 66.851 ms - 56
GET /cafe/filter?page=1 200 89.896 ms - 1449
POST /cafe/list 200 32.933 ms - 4492
PUT /auth/fcm-update 202 6.176 ms - 51
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: {}
}
GET /group/get-group-list?page=1 500 9.257 ms - 61
GET /cafe/go-to-orders 200 11.642 ms - 1935
GET /cafe/filter?page=1 200 9.682 ms - 1449
POST /cafe/list 200 30.457 ms - 4492
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: {}
}
GET /group/get-group-list?page=1 500 5.962 ms - 61
GET /cafe/go-to-orders 200 15.352 ms - 1935
GET /cafe/filter?page=1 200 15.923 ms - 1449
POST /cafe/list 200 47.863 ms - 4492
POST /cafe/detail 200 9.600 ms - 3268
GET /cafe/item-category?cafe_id=82&page=1 200 46.480 ms - 468
GET /cafe/item?menu_id=1455&page=1&filter=1,2,3 200 13.572 ms - 3512
POST /cafe/item-detail 200 10.512 ms - 1161
POST /cafe/update-go-to-order 200 15.453 ms - 48
GET /cafe/go-to-orders 200 7.746 ms - 2480
GET /in-house/get-order 200 11.404 ms - 58
GET /auth/notification/count 200 8.903 ms - 56
GET /cafe/go-to-orders 200 25.736 ms - 760
PUT /auth/fcm-update 202 23.251 ms - 51
GET /cafe/filter?page=1 200 36.178 ms - 1449
POST /cafe/list 200 28.044 ms - 4308
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: {}
}
GET /group/get-group-list?page=1 500 8.151 ms - 61
GET /cafe/go-to-orders 200 21.199 ms - 760
GET /cafe/filter?page=1 200 21.491 ms - 1449
POST /cafe/list 200 37.861 ms - 4308
POST /auth/sign-in 200 99.758 ms - 495
GET /auth/app-version?os_type=2 200 6.662 ms - 328
GET /cafe/go-to-orders 200 9.312 ms - 800
PUT /auth/fcm-update 202 13.211 ms - 51
GET /cafe/filter?page=1 200 5.463 ms - 1449
POST /cafe/list 200 37.185 ms - 4308
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: {}
}
GET /group/get-group-list?page=1 500 23.944 ms - 61
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: {}
}
GET /group/get-group-list?page=1 500 30.967 ms - 61
GET /auth/notification/count 200 8.739 ms - 56
GET /cafe/filter?page=1 200 6.057 ms - 1449
GET /cafe/go-to-orders 200 6.895 ms - 47
POST /cafe/list 200 27.717 ms - 4308
PUT /auth/fcm-update 202 6.077 ms - 51
GET /cafe/filter?page=1 200 6.643 ms - 1449
PUT /auth/fcm-update 202 12.894 ms - 51
GET /cafe/go-to-orders 200 17.399 ms - 800
GET /auth/notification/count 200 9.710 ms - 56
POST /cafe/list 200 25.948 ms - 4308
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: {}
}
GET /group/get-group-list?page=1 500 5.715 ms - 61
GET /auth/notification/count 200 5.737 ms - 56
GET /cafe/go-to-orders 200 13.159 ms - 800
PUT /auth/fcm-update 202 12.636 ms - 51
GET /cafe/filter?page=1 200 6.143 ms - 1449
POST /cafe/list 200 28.979 ms - 4308