REQUEST DATE : June 14th 2024, 5:56:52 pm
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : June 15th 2024, 2:27:57 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 15th 2024, 2:28:04 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 15th 2024, 2:30:03 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 15th 2024, 2:30:03 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 15th 2024, 2:33:46 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 15th 2024, 2:34:08 pm
API URL : http://18.132.176.176:6000/order/loyalty-list?page=2
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : June 15th 2024, 2:34:08 pm
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : June 15th 2024, 2:34:08 pm
API URL : http://18.132.176.176:6000/order/loyalty-list?page=3
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : June 15th 2024, 2:34:12 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 15th 2024, 2:34:12 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 15th 2024, 2:34:12 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 15th 2024, 2:52:03 pm
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : June 15th 2024, 2:52:03 pm
API URL : http://18.132.176.176:6000/order/loyalty-list?page=2
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : June 15th 2024, 2:52:03 pm
API URL : http://18.132.176.176:6000/order/loyalty-list?page=3
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : June 15th 2024, 2:52:43 pm
API URL : http://18.132.176.176:6000/auth/update
API PARAMETER : {"name":"Testing ","profile_picture":null}
Error : Error: SequelizeDatabaseError: Column 'profile_picture' cannot be null

REQUEST DATE : June 15th 2024, 2:52:46 pm
API URL : http://18.132.176.176:6000/auth/update
API PARAMETER : {"name":"Testing ","profile_picture":null}
Error : Error: SequelizeDatabaseError: Column 'profile_picture' cannot be null

REQUEST DATE : June 15th 2024, 2:52:54 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 15th 2024, 2:52:54 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 15th 2024, 2:52:54 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 18th 2024, 12:57:18 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 18th 2024, 12:59:13 pm
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : June 18th 2024, 12:59:13 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 6:46:52 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 7:00:26 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 7:04:13 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 7:04:54 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : June 19th 2024, 12:42:19 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:44:10 pm
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : June 19th 2024, 12:44:14 pm
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : June 19th 2024, 12:44:33 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:44:35 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:48:53 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:49:31 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:49:33 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:50:06 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:50:08 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:51:35 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:51:37 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:53:39 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:54:40 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:54:42 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:55:19 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:56:00 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:56:02 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:56:03 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:56:42 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 12:59:17 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 1:57:54 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 1:59:00 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 2:05:50 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 2:07:23 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : June 19th 2024, 2:09:24 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : August 2nd 2024, 7:33:34 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : August 2nd 2024, 7:33:43 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : August 2nd 2024, 7:33:45 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : August 2nd 2024, 7:33:53 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : August 2nd 2024, 7:35:14 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : August 2nd 2024, 7:39:57 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : August 2nd 2024, 7:40:43 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : August 13th 2024, 12:27:42 pm
API URL : http://18.132.176.176:6000/cafe/item-detail
API PARAMETER : {"item_id":78}
Error : Error: ReferenceError: Sequelize is not defined

REQUEST DATE : September 5th 2024, 5:11:22 am
API URL : http://18.132.176.176:6000/cafe/item-category?cafe_id=59&page=0
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10, 10' at line 1

REQUEST DATE : September 5th 2024, 6:19:18 am
API URL : http://18.132.176.176:6000/group/get_group_details
API PARAMETER : {"group_id":132,"latitude":"40.615533","longitude":"-74.089313","user_id":125}
Error : Error: SequelizeEagerLoadingError: cafe_timings is not associated to group_cafes!

REQUEST DATE : September 5th 2024, 6:20:42 am
API URL : http://18.132.176.176:6000/group/get_group_details
API PARAMETER : {"group_id":132,"latitude":"40.615533","longitude":"-74.089313","user_id":125}
Error : Error: SequelizeEagerLoadingError: cafe_timings is not associated to group_cafes!

REQUEST DATE : September 5th 2024, 6:28:20 am
API URL : http://18.132.176.176:6000/group/get_group_details
API PARAMETER : {"group_id":132,"latitude":"40.615533","longitude":"-74.089313","user_id":125}
Error : Error: ReferenceError: i is not defined

REQUEST DATE : September 5th 2024, 6:29:21 am
API URL : http://18.132.176.176:6000/group/get_group_details
API PARAMETER : {"group_id":132,"latitude":"30.7036694","longitude":"76.6927024","user_id":71}
Error : Error: ReferenceError: i is not defined

REQUEST DATE : September 5th 2024, 6:32:40 am
API URL : http://18.132.176.176:6000/group/get_group_details
API PARAMETER : {"group_id":132,"latitude":"30.7036694","longitude":"76.6927024","user_id":71}
Error : Error: ReferenceError: i is not defined

REQUEST DATE : September 5th 2024, 6:33:02 am
API URL : http://18.132.176.176:6000/group/get_group_details
API PARAMETER : {"group_id":132,"latitude":"30.7036694","longitude":"76.6927024","user_id":71}
Error : Error: ReferenceError: i is not defined

REQUEST DATE : September 5th 2024, 6:35:07 am
API URL : http://18.132.176.176:6000/group/get_group_details
API PARAMETER : {"group_id":132,"latitude":"30.7036694","longitude":"76.6927024","user_id":71}
Error : Error: TypeError: Cannot read properties of undefined (reading 'length')

REQUEST DATE : September 5th 2024, 6:37:41 am
API URL : http://18.132.176.176:6000/group/get_group_details
API PARAMETER : {"group_id":132,"latitude":"30.7036694","longitude":"76.6927024","user_id":71}
Error : Error: ReferenceError: i is not defined

REQUEST DATE : September 5th 2024, 9:30:57 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : September 5th 2024, 9:31:07 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : September 5th 2024, 9:31:35 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : September 5th 2024, 9:31:40 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : September 5th 2024, 9:31:46 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : September 5th 2024, 9:31:47 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : September 5th 2024, 9:31:47 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : September 5th 2024, 9:32:00 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : September 5th 2024, 9:32:02 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : September 5th 2024, 9:32:09 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : September 5th 2024, 9:32:09 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : September 5th 2024, 9:32:15 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : September 5th 2024, 9:32:15 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : September 5th 2024, 9:35:45 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : September 5th 2024, 9:35:57 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : September 5th 2024, 9:36:01 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : September 5th 2024, 9:39:09 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : September 5th 2024, 9:39:15 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : September 5th 2024, 9:39:18 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : September 5th 2024, 9:47:55 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : September 5th 2024, 9:47:55 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : September 5th 2024, 9:48:03 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : September 5th 2024, 9:48:03 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : September 5th 2024, 9:48:13 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : September 5th 2024, 9:48:13 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : September 5th 2024, 9:48:20 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : September 5th 2024, 9:48:20 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : September 5th 2024, 9:48:22 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : September 5th 2024, 9:48:22 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : September 5th 2024, 10:35:49 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : September 5th 2024, 10:35:49 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : September 9th 2024, 11:17:09 am
API URL : http://18.132.176.176:6000/cafe/searched-cafe
API PARAMETER : {"query":"ocean","latitude":"30.7036732","longitude":"76.6927013","user_id":71}
Error : Error: Invalid value { is_admin_approved: 1 }

REQUEST DATE : September 9th 2024, 11:17:12 am
API URL : http://18.132.176.176:6000/cafe/searched-cafe
API PARAMETER : {"query":"ocean wise","latitude":"30.7036732","longitude":"76.6927013","user_id":71}
Error : Error: Invalid value { is_admin_approved: 1 }

REQUEST DATE : September 20th 2024, 10:44:43 am
API URL : http://18.132.176.176:6000/order/non-universal-card
API PARAMETER : {"cafe_id":62}
Error : Error: SequelizeDatabaseError: Unknown column 'NaN' in 'where clause'

REQUEST DATE : September 20th 2024, 10:45:34 am
API URL : http://18.132.176.176:6000/order/non-universal-card
API PARAMETER : {"cafe_id":62}
Error : Error: SequelizeDatabaseError: Unknown column 'NaN' in 'where clause'

REQUEST DATE : September 20th 2024, 10:46:10 am
API URL : http://18.132.176.176:6000/order/non-universal-card
API PARAMETER : {"cafe_id":62}
Error : Error: SequelizeDatabaseError: Unknown column 'NaN' in 'where clause'

REQUEST DATE : September 20th 2024, 10:47:33 am
API URL : http://18.132.176.176:6000/order/non-universal-card
API PARAMETER : {"cafe_id":62}
Error : Error: SequelizeDatabaseError: Unknown column 'NaN' in 'where clause'

REQUEST DATE : October 29th 2024, 6:32:51 am
API URL : http://18.132.176.176:6000/order
API PARAMETER : {"cafe_id":8,"group_id":142,"additional_note":"","is_main_order":1,"total_amount":20.45,"items_amount":20,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QF8ykH68ivyxSXq0VVTd1EC","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"PLIMIEVX4VVQBIZ","order_item_array":[{"item_id":53,"item_name":"Limbu pani","item_size":"Large","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/TCr7xoPFvT1XPDm4YHWU4mvkzEQNQ8KVo8fKbrjw.png","addon_sizes":[],"item_amount":20,"item_category":"","item_quantity":1,"item_description":"sweet salty sour but you never get bored","is_suggested_item":0}],"loggedInUser":170}
Error : Error: SequelizeForeignKeyConstraintError: Cannot add or update a child row: a foreign key constraint fails (`javago_staging`.`group_coffee_runs`, CONSTRAINT `group_coffee_runs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders_old` (`id`) ON DELETE CASCADE)

REQUEST DATE : October 29th 2024, 6:39:03 am
API URL : http://18.132.176.176:6000/order
API PARAMETER : {"cafe_id":8,"group_id":142,"additional_note":"","is_main_order":1,"total_amount":20.45,"items_amount":20,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QF94iH68ivyxSXq1XkfstM5","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"KBBGPXYEEGTALL0","order_item_array":[{"item_id":53,"item_name":"Limbu pani","item_size":"Large","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/TCr7xoPFvT1XPDm4YHWU4mvkzEQNQ8KVo8fKbrjw.png","addon_sizes":[],"item_amount":20,"item_category":"","item_quantity":1,"item_description":"sweet salty sour but you never get bored","is_suggested_item":0}],"loggedInUser":170}
Error : Error: SequelizeForeignKeyConstraintError: Cannot add or update a child row: a foreign key constraint fails (`javago_staging`.`group_coffee_runs`, CONSTRAINT `group_coffee_runs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders_old` (`id`) ON DELETE CASCADE)

REQUEST DATE : October 29th 2024, 6:47:11 am
API URL : http://18.132.176.176:6000/order
API PARAMETER : {"cafe_id":8,"group_id":142,"additional_note":"","is_main_order":1,"total_amount":20.45,"items_amount":20,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QF9CVH68ivyxSXq069R0c7H","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"1XJTANFT9FH6TUL","order_item_array":[{"item_id":53,"item_name":"Limbu pani","item_size":"Large","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/TCr7xoPFvT1XPDm4YHWU4mvkzEQNQ8KVo8fKbrjw.png","addon_sizes":[],"item_amount":20,"item_category":"","item_quantity":1,"item_description":"sweet salty sour but you never get bored","is_suggested_item":0}],"loggedInUser":170}
Error : Error: SequelizeForeignKeyConstraintError: Cannot add or update a child row: a foreign key constraint fails (`javago_staging`.`group_coffee_runs`, CONSTRAINT `group_coffee_runs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders_old` (`id`) ON DELETE CASCADE)

REQUEST DATE : October 29th 2024, 6:52:53 am
API URL : http://18.132.176.176:6000/order
API PARAMETER : {"cafe_id":8,"group_id":142,"additional_note":"","is_main_order":1,"total_amount":20.45,"items_amount":20,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QF9IBH68ivyxSXq0fdibHaM","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"FTHXH4FFMD3AY9G","order_item_array":[{"item_id":53,"item_name":"Limbu pani","item_size":"Large","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/TCr7xoPFvT1XPDm4YHWU4mvkzEQNQ8KVo8fKbrjw.png","addon_sizes":[],"item_amount":20,"item_category":"","item_quantity":1,"item_description":"sweet salty sour but you never get bored","is_suggested_item":0}],"loggedInUser":170}
Error : Error: SequelizeForeignKeyConstraintError: Cannot add or update a child row: a foreign key constraint fails (`javago_staging`.`group_coffee_runs`, CONSTRAINT `group_coffee_runs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders_old` (`id`) ON DELETE CASCADE)

REQUEST DATE : November 14th 2024, 4:15:02 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : November 14th 2024, 9:15:49 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : November 14th 2024, 9:16:29 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : November 14th 2024, 9:17:17 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : November 14th 2024, 9:17:22 pm
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : November 15th 2024, 5:47:41 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : November 15th 2024, 5:51:14 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : November 15th 2024, 5:53:59 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : November 15th 2024, 5:54:05 am
API URL : http://18.132.176.176:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : November 15th 2024, 5:54:28 am
API URL : http://18.132.176.176:6000/auth/update
API PARAMETER : {"name":"Neeraj ","profile_picture":null}
Error : Error: SequelizeDatabaseError: Column 'profile_picture' cannot be null

REQUEST DATE : November 15th 2024, 5:54:30 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : November 15th 2024, 5:54:32 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : November 15th 2024, 5:55:09 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : November 15th 2024, 5:55:39 am
API URL : http://18.132.176.176:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : November 15th 2024, 6:00:43 am
API URL : http://18.132.176.176:6000/auth/update
API PARAMETER : {"name":"Neeraj ","profile_picture":null}
Error : Error: SequelizeDatabaseError: Column 'profile_picture' cannot be null

REQUEST DATE : November 15th 2024, 6:04:03 am
API URL : http://18.132.176.176:6000/auth/update
API PARAMETER : {"name":"Neeraj ","profile_picture":null}
Error : Error: SequelizeDatabaseError: Column 'profile_picture' cannot be null

REQUEST DATE : November 15th 2024, 6:04:12 am
API URL : http://18.132.176.176:6000/auth/update
API PARAMETER : {"name":"Neeraj Lakhera","profile_picture":null}
Error : Error: SequelizeDatabaseError: Column 'profile_picture' cannot be null

REQUEST DATE : November 15th 2024, 8:44:03 am
API URL : http://18.132.176.176:6000/auth/update
API PARAMETER : {"name":"Neeraj","profile_picture":null}
Error : Error: SequelizeDatabaseError: Column 'profile_picture' cannot be null

REQUEST DATE : November 16th 2024, 7:18:19 am
API URL : http://18.132.176.176:6000/order
API PARAMETER : {"cafe_id":81,"group_id":145,"additional_note":"","is_main_order":1,"total_amount":3.6500000000000004,"items_amount":3.2,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QLgG1H68ivyxSXq0jYPhC22","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"QM14SXGE3ZLIVZK","order_item_array":[{"item_id":137,"item_name":"Flat White","item_size":"Medium","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/TtiERqfKnc68YVI3IEGhKhZ9rlGtkau3725VUkba.png","addon_sizes":[],"item_amount":3.2,"item_category":"","item_quantity":1,"item_description":"Flat white hot drink","is_suggested_item":0}],"loggedInUser":170}
Error : Error: SequelizeForeignKeyConstraintError: Cannot add or update a child row: a foreign key constraint fails (`javago_staging`.`group_coffee_runs`, CONSTRAINT `group_coffee_runs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders_old` (`id`) ON DELETE CASCADE)

REQUEST DATE : November 16th 2024, 8:34:37 am
API URL : http://18.132.176.176:6000/order
API PARAMETER : {"cafe_id":81,"group_id":149,"additional_note":"","is_main_order":1,"total_amount":3.6500000000000004,"items_amount":3.2,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QLhRpH68ivyxSXq1yt0zz6Q","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"QLV208T2XF0H74K","order_item_array":[{"item_id":137,"item_name":"Flat White","item_size":"Medium","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/TtiERqfKnc68YVI3IEGhKhZ9rlGtkau3725VUkba.png","addon_sizes":[],"item_amount":3.2,"item_category":"","item_quantity":1,"item_description":"Flat white hot drink","is_suggested_item":0}],"loggedInUser":199}
Error : Error: SequelizeForeignKeyConstraintError: Cannot add or update a child row: a foreign key constraint fails (`javago_staging`.`group_coffee_runs`, CONSTRAINT `group_coffee_runs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders_old` (`id`) ON DELETE CASCADE)

REQUEST DATE : November 16th 2024, 8:34:40 am
API URL : http://18.132.176.176:6000/order
API PARAMETER : {"cafe_id":81,"group_id":149,"additional_note":"","is_main_order":1,"total_amount":3.6500000000000004,"items_amount":3.2,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QLhRpH68ivyxSXq1yt0zz6Q","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"QLV208T2XF0H74K","order_item_array":[{"item_id":137,"item_name":"Flat White","item_size":"Medium","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/TtiERqfKnc68YVI3IEGhKhZ9rlGtkau3725VUkba.png","addon_sizes":[],"item_amount":3.2,"item_category":"","item_quantity":1,"item_description":"Flat white hot drink","is_suggested_item":0}],"loggedInUser":199}
Error : Error: SequelizeForeignKeyConstraintError: Cannot add or update a child row: a foreign key constraint fails (`javago_staging`.`group_coffee_runs`, CONSTRAINT `group_coffee_runs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders_old` (`id`) ON DELETE CASCADE)

REQUEST DATE : November 16th 2024, 2:33:05 pm
API URL : http://18.132.176.176:6000/order
API PARAMETER : {"cafe_id":82,"group_id":149,"additional_note":"","is_main_order":1,"total_amount":4.65,"items_amount":4.2,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QLn2wH68ivyxSXq1YuN3lSN","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"DGGNKVADIQBNGXA","order_item_array":[{"item_id":138,"item_name":"Flat White","item_size":"Medium","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/TtiERqfKnc68YVI3IEGhKhZ9rlGtkau3725VUkba.png","addon_sizes":[],"item_amount":4.2,"item_category":"","item_quantity":1,"item_description":"Double espresso served with lightly steamed milk.","is_suggested_item":0}],"loggedInUser":199}
Error : Error: SequelizeForeignKeyConstraintError: Cannot add or update a child row: a foreign key constraint fails (`javago_staging`.`group_coffee_runs`, CONSTRAINT `group_coffee_runs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders_old` (`id`) ON DELETE CASCADE)

REQUEST DATE : November 20th 2024, 12:38:41 pm
API URL : http://18.132.176.176:6000/cafe/suggested-item
API PARAMETER : {"item_id":"137","page":1}
Error : Error: SequelizeDatabaseError: Unknown column 'cafe_menu_item->addon_size_cafe_items->addon_size->addon.addon_size_price' in 'field list'

REQUEST DATE : November 20th 2024, 12:38:45 pm
API URL : http://18.132.176.176:6000/cafe/suggested-item
API PARAMETER : {"item_id":"137","page":1}
Error : Error: SequelizeDatabaseError: Unknown column 'cafe_menu_item->addon_size_cafe_items->addon_size->addon.addon_size_price' in 'field list'

REQUEST DATE : December 5th 2024, 11:32:15 am
API URL : https://api.javaapp.co.uk:6000/order
API PARAMETER : {"cafe_id":81,"group_id":146,"additional_note":"","is_main_order":1,"total_amount":3.6500000000000004,"items_amount":3.2,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QSdHhH68ivyxSXq0IfU4xNf","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"SFU4GACMW74CEFC","order_item_array":[{"item_id":137,"item_name":"Flat White","item_size":"Medium","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/TtiERqfKnc68YVI3IEGhKhZ9rlGtkau3725VUkba.png","addon_sizes":[],"item_amount":3.2,"item_category":"","item_quantity":1,"item_description":"Flat white hot drink","is_suggested_item":0}],"loggedInUser":170}
Error : Error: SequelizeForeignKeyConstraintError: Cannot add or update a child row: a foreign key constraint fails (`javago_staging`.`group_coffee_runs`, CONSTRAINT `group_coffee_runs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders_old` (`id`) ON DELETE CASCADE)

REQUEST DATE : December 5th 2024, 11:57:47 am
API URL : https://api.javaapp.co.uk:6000/order
API PARAMETER : {"cafe_id":81,"group_id":151,"additional_note":"","is_main_order":1,"total_amount":3.6500000000000004,"items_amount":3.2,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QSdgSH68ivyxSXq0U06cTql","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"FGFFNRN2WAY0UZX","order_item_array":[{"item_id":137,"item_name":"Flat White","item_size":"Medium","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/TtiERqfKnc68YVI3IEGhKhZ9rlGtkau3725VUkba.png","addon_sizes":[],"item_amount":3.2,"item_category":"","item_quantity":1,"item_description":"Flat white hot drink","is_suggested_item":0}],"loggedInUser":170}
Error : Error: SequelizeForeignKeyConstraintError: Cannot add or update a child row: a foreign key constraint fails (`javago_staging`.`group_coffee_runs`, CONSTRAINT `group_coffee_runs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders_old` (`id`) ON DELETE CASCADE)

REQUEST DATE : December 16th 2024, 9:43:49 am
API URL : https://api.javaapp.co.uk:6000/order
API PARAMETER : {"cafe_id":86,"group_id":153,"additional_note":"","is_main_order":1,"total_amount":90.45,"items_amount":90,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QWapmH68ivyxSXq0GMyqY7Q","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"GNFOJMMH22WVJIU","order_item_array":[{"item_id":157,"item_name":"lassi","item_size":"Medium","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/TCr7xoPFvT1XPDm4YHWU4mvkzEQNQ8KVo8fKbrjw.png","addon_sizes":[],"item_amount":90,"item_category":"","item_quantity":1,"item_description":"lassi for you","is_suggested_item":0}],"loggedInUser":297}
Error : Error: SequelizeForeignKeyConstraintError: Cannot add or update a child row: a foreign key constraint fails (`javago_staging`.`group_coffee_runs`, CONSTRAINT `group_coffee_runs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders_old` (`id`) ON DELETE CASCADE)

REQUEST DATE : December 16th 2024, 9:44:47 am
API URL : https://api.javaapp.co.uk:6000/order
API PARAMETER : {"cafe_id":86,"group_id":153,"additional_note":"","is_main_order":1,"total_amount":90.45,"items_amount":90,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QWaqpH68ivyxSXq1x7fWaCo","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"GHIBEG4DNY9UNTZ","order_item_array":[{"item_id":157,"item_name":"lassi","item_size":"Medium","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/TCr7xoPFvT1XPDm4YHWU4mvkzEQNQ8KVo8fKbrjw.png","addon_sizes":[],"item_amount":90,"item_category":"","item_quantity":1,"item_description":"lassi for you","is_suggested_item":0}],"loggedInUser":297}
Error : Error: SequelizeForeignKeyConstraintError: Cannot add or update a child row: a foreign key constraint fails (`javago_staging`.`group_coffee_runs`, CONSTRAINT `group_coffee_runs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders_old` (`id`) ON DELETE CASCADE)

REQUEST DATE : February 2nd 2025, 12:31:40 pm
API URL : https://api.javaapp.co.uk:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : February 2nd 2025, 12:32:59 pm
API URL : https://api.javaapp.co.uk:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : February 2nd 2025, 12:33:00 pm
API URL : https://api.javaapp.co.uk:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : February 2nd 2025, 12:33:47 pm
API URL : https://api.javaapp.co.uk:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'javago_staging.orders.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

REQUEST DATE : February 2nd 2025, 12:33:48 pm
API URL : https://api.javaapp.co.uk:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : February 2nd 2025, 1:53:18 pm
API URL : https://api.javaapp.co.uk:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : February 2nd 2025, 2:12:00 pm
API URL : https://api.javaapp.co.uk:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : February 2nd 2025, 2:12:02 pm
API URL : https://api.javaapp.co.uk:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : February 4th 2025, 12:21:51 pm
API URL : https://api.javaapp.co.uk:6000/order
API PARAMETER : {"cafe_id":82,"group_id":154,"additional_note":"","is_main_order":1,"total_amount":5.05,"items_amount":4.6,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3Qol7vH68ivyxSXq1nJHQaq2","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"DQUNEIDYVP0JHKO","order_item_array":[{"item_id":169,"item_name":"Chai matcha","item_size":"Medium","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/co2zNWrdEAFmAyETLpeqRCyUJ5bDPhFFmZBa4vAO.png","addon_sizes":[],"item_amount":4.6,"item_category":"Matcha","item_quantity":1,"item_description":"Chai matcha- sweet, peppery","is_suggested_item":0}],"loggedInUser":300}
Error : Error: SequelizeForeignKeyConstraintError: Cannot add or update a child row: a foreign key constraint fails (`javago_staging`.`group_coffee_runs`, CONSTRAINT `group_coffee_runs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders_old` (`id`) ON DELETE CASCADE)

REQUEST DATE : February 4th 2025, 12:57:24 pm
API URL : https://api.javaapp.co.uk:6000/order
API PARAMETER : {"cafe_id":80,"group_id":154,"additional_note":"","is_main_order":1,"total_amount":3.75,"items_amount":3.3,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QolgXH68ivyxSXq1GZor0Ns","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"JMJHYCGT1U63C6Y","order_item_array":[{"item_id":204,"item_name":"Decaf English Breakfast","item_size":"Large","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/co2zNWrdEAFmAyETLpeqRCyUJ5bDPhFFmZBa4vAO.png","addon_sizes":[],"item_amount":3.3,"item_category":"Tea","item_quantity":1,"item_description":"All the boldness of English Breakfast, without the caffeine.","is_suggested_item":0}],"loggedInUser":300}
Error : Error: SequelizeForeignKeyConstraintError: Cannot add or update a child row: a foreign key constraint fails (`javago_staging`.`group_coffee_runs`, CONSTRAINT `group_coffee_runs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders_old` (`id`) ON DELETE CASCADE)

REQUEST DATE : February 5th 2025, 4:55:55 pm
API URL : https://api.javaapp.co.uk:6000/order
API PARAMETER : {"cafe_id":80,"group_id":156,"additional_note":"","is_main_order":1,"total_amount":4.05,"items_amount":3.5999999999999996,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QpBsbH68ivyxSXq1LWnBio3","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"LZAGHJ3DCEJEVBT","order_item_array":[{"item_id":198,"item_name":"Green Tea","item_size":"Large","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/co2zNWrdEAFmAyETLpeqRCyUJ5bDPhFFmZBa4vAO.png","addon_sizes":[{"addon_name":"Milk","addon_size_id":1861,"addon_size_name":"Oat milk","addon_size_price":0.3}],"item_amount":3.5999999999999996,"item_category":"Tea","item_quantity":1,"item_description":"Delicate and refreshing, with a light, grassy flavor.","is_suggested_item":0}],"loggedInUser":300}
Error : Error: SequelizeForeignKeyConstraintError: Cannot add or update a child row: a foreign key constraint fails (`javago_staging`.`group_coffee_runs`, CONSTRAINT `group_coffee_runs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders_old` (`id`) ON DELETE CASCADE)

REQUEST DATE : February 6th 2025, 5:35:47 pm
API URL : https://api.javaapp.co.uk:6000/order
API PARAMETER : {"cafe_id":88,"group_id":156,"additional_note":"","is_main_order":1,"total_amount":3.6,"items_amount":3.15,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QpYysH68ivyxSXq120DHjGt","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"PVMC18DSPONMMXE","order_item_array":[{"item_id":246,"item_name":"Macchiato","item_size":"Medium","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/qd3IMeFE2Trv6DULWKolQgSmtoqkSYr8PjJmDMFs.png","addon_sizes":[{"addon_name":"Milk","addon_size_id":2126,"addon_size_name":"Oat milk","addon_size_price":0}],"item_amount":3.15,"item_category":"Hot Drinks","item_quantity":1,"item_description":"Espresso topped with a delicate dollop of milk foam.","is_suggested_item":0}],"loggedInUser":300}
Error : Error: SequelizeForeignKeyConstraintError: Cannot add or update a child row: a foreign key constraint fails (`javago_staging`.`group_coffee_runs`, CONSTRAINT `group_coffee_runs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders_old` (`id`) ON DELETE CASCADE)

REQUEST DATE : March 10th 2025, 9:55:47 am
API URL : https://api.javaapp.co.uk:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : March 10th 2025, 9:56:58 am
API URL : https://api.javaapp.co.uk:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : March 10th 2025, 10:04:47 am
API URL : https://api.javaapp.co.uk:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : March 10th 2025, 10:06:49 am
API URL : https://api.javaapp.co.uk:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : March 10th 2025, 10:07:19 am
API URL : https://api.javaapp.co.uk:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : March 10th 2025, 10:07:23 am
API URL : https://api.javaapp.co.uk:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : March 10th 2025, 10:24:15 am
API URL : https://api.javaapp.co.uk:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : March 10th 2025, 10:25:19 am
API URL : https://api.javaapp.co.uk:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : March 10th 2025, 10:25:19 am
API URL : https://api.javaapp.co.uk:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : March 10th 2025, 10:27:25 am
API URL : https://api.javaapp.co.uk:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : March 10th 2025, 10:29:46 am
API URL : https://api.javaapp.co.uk:6000/group/get-group-list?page=1
API PARAMETER : {}
Error : Error: SequelizeDatabaseError: 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

REQUEST DATE : March 10th 2025, 10:39:00 am
API URL : https://api.javaapp.co.uk:6000/order
API PARAMETER : {"cafe_id":88,"group_id":158,"additional_note":"","is_main_order":1,"total_amount":6.45,"items_amount":6,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3R13ibH68ivyxSXq17HZV4Xo","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"NKS6VF4HLDAAUWT","order_item_array":[{"item_id":280,"item_name":"Almond Butter","item_size":"Medium","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/TtiERqfKnc68YVI3IEGhKhZ9rlGtkau3725VUkba.png","addon_sizes":[],"item_amount":3.5,"item_category":"","item_quantity":1,"item_description":"Almond butter - sides","is_suggested_item":0},{"item_id":281,"item_name":"Peanut Butter","item_size":"Medium","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/TtiERqfKnc68YVI3IEGhKhZ9rlGtkau3725VUkba.png","addon_sizes":[],"item_amount":2.5,"item_category":"","item_quantity":1,"item_description":"Peanut butter -sides","is_suggested_item":0}],"loggedInUser":393}
Error : Error: SequelizeForeignKeyConstraintError: Cannot add or update a child row: a foreign key constraint fails (`javago_staging`.`group_coffee_runs`, CONSTRAINT `group_coffee_runs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders_old` (`id`) ON DELETE CASCADE)