HEX
Server: Apache/2.4.52 (Ubuntu)
System: Linux ip-10-0-8-47 6.8.0-1021-aws #23~22.04.1-Ubuntu SMP Tue Dec 10 16:31:58 UTC 2024 aarch64
User: ubuntu (1000)
PHP: 8.1.2-1ubuntu2.22
Disabled: NONE
$ pwd: /var/www/javago-nodeserver-hotfixes/
Upload Files
File: /var/www/javago-nodeserver-hotfixes/errorLog.log
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 13th 2024, 12:37:50 pm
API URL : http://192.168.4.218:6000/order/get-categories-coupon
API PARAMETER : {}
Error : Error: Error: WHERE parameter "cafe_id" has invalid "undefined" value

REQUEST DATE : December 13th 2024, 12:42:38 pm
API URL : http://192.168.4.218:6000/order/get-categories-coupon
API PARAMETER : {}
Error : Error: Cafe ID is required

REQUEST DATE : December 13th 2024, 12:42:41 pm
API URL : http://192.168.4.218:6000/order/get-categories-coupon
API PARAMETER : {}
Error : Error: Cafe ID is required

REQUEST DATE : December 13th 2024, 1:20:01 pm
API URL : http://192.168.4.218:6000/order/non-universal-card
API PARAMETER : {"cafe_id":"86"}
Error : Error: ReferenceError: CafeloyaltyStampExcludedItemsDB is not defined

REQUEST DATE : December 13th 2024, 1:21:10 pm
API URL : http://192.168.4.218:6000/order/non-universal-card
API PARAMETER : {"cafe_id":"86"}
Error : Error: ReferenceError: CafeloyaltyStampExcludedItemsDB is not defined

REQUEST DATE : December 13th 2024, 1:21:11 pm
API URL : http://192.168.4.218:6000/order/non-universal-card
API PARAMETER : {"cafe_id":"86"}
Error : Error: ReferenceError: CafeloyaltyStampExcludedItemsDB is not defined

REQUEST DATE : December 13th 2024, 1:21:16 pm
API URL : http://192.168.4.218:6000/order/non-universal-card
API PARAMETER : {"cafe_id":"86"}
Error : Error: ReferenceError: CafeloyaltyStampExcludedItemsDB is not defined

REQUEST DATE : December 13th 2024, 1:27:55 pm
API URL : http://192.168.4.218:6000/order/non-universal-card
API PARAMETER : {"cafe_id":"86"}
Error : Error: ReferenceError: CafeloyaltyStampExcludedItemsDB is not defined

REQUEST DATE : December 13th 2024, 1:43:29 pm
API URL : http://192.168.4.218:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: TypeError: Cannot read properties of undefined (reading '0')

REQUEST DATE : December 13th 2024, 1:44:10 pm
API URL : http://192.168.4.218:6000/order/loyalty-list?page=1
API PARAMETER : {}
Error : Error: TypeError: Cannot read properties of undefined (reading '0')

REQUEST DATE : December 13th 2024, 1:57:36 pm
API URL : http://192.168.4.218:6000/order/loyalty-list
API PARAMETER : {"cafe_id":86}
Error : Error: TypeError: orders is not iterable

REQUEST DATE : December 13th 2024, 1:57:55 pm
API URL : http://192.168.4.218:6000/order/loyalty-list
API PARAMETER : {"cafe_id":86}
Error : Error: TypeError: orders is not iterable

REQUEST DATE : December 13th 2024, 1:58:47 pm
API URL : http://192.168.4.218:6000/order/loyalty-list
API PARAMETER : {"cafe_id":86}
Error : Error: SyntaxError: "undefined" is not valid JSON

REQUEST DATE : December 13th 2024, 1:59:35 pm
API URL : http://192.168.4.218:6000/order/loyalty-list
API PARAMETER : {"cafe_id":86}
Error : Error: SyntaxError: "undefined" is not valid JSON

REQUEST DATE : December 13th 2024, 2:48:59 pm
API URL : http://192.168.4.218:6000/order/loyalty-list
API PARAMETER : {"cafe_id":86}
Error : Error: TypeError: Cannot read properties of undefined (reading 'LoyaltyStamps')

REQUEST DATE : December 13th 2024, 2:50:45 pm
API URL : http://192.168.4.218:6000/order/loyalty-list
API PARAMETER : {"cafe_id":86}
Error : Error: TypeError: Cannot read properties of undefined (reading 'LoyaltyStamps')

REQUEST DATE : December 13th 2024, 2:52:11 pm
API URL : http://192.168.4.218:6000/order/loyalty-list
API PARAMETER : {"cafe_id":86}
Error : Error: TypeError: Cannot read properties of undefined (reading 'manage_loyalty_stamps')

REQUEST DATE : December 13th 2024, 2:53:53 pm
API URL : http://192.168.4.218:6000/order/loyalty-list
API PARAMETER : {"cafe_id":86}
Error : Error: Error: WHERE parameter "stamp_id" has invalid "undefined" value

REQUEST DATE : December 13th 2024, 2:55:34 pm
API URL : http://192.168.4.218:6000/order/loyalty-list
API PARAMETER : {"cafe_id":86}
Error : Error: Error: WHERE parameter "stamp_id" has invalid "undefined" value

REQUEST DATE : December 13th 2024, 3:43:52 pm
API URL : http://192.168.4.218:6000/order/loyalty-list
API PARAMETER : {"cafe_id":86}
Error : Error: TypeError: Cannot read properties of undefined (reading 'push')

REQUEST DATE : December 13th 2024, 3:44:31 pm
API URL : http://192.168.4.218:6000/order/loyalty-list
API PARAMETER : {"cafe_id":86}
Error : Error: TypeError: Cannot read properties of undefined (reading 'push')

REQUEST DATE : December 13th 2024, 4:16:56 pm
API URL : http://192.168.4.218:6000/order/loyalty-list
API PARAMETER : {"cafe_id":86}
Error : Error: SequelizeDatabaseError: Undeclared variable: NaN

REQUEST DATE : December 13th 2024, 4:17:32 pm
API URL : http://192.168.4.218:6000/order/loyalty-list
API PARAMETER : {"cafe_id":86}
Error : Error: SequelizeDatabaseError: Undeclared variable: NaN

REQUEST DATE : December 13th 2024, 4:17:35 pm
API URL : http://192.168.4.218:6000/order/loyalty-list
API PARAMETER : {"cafe_id":86}
Error : Error: SequelizeDatabaseError: Undeclared variable: NaN

REQUEST DATE : December 13th 2024, 4:32:13 pm
API URL : http://192.168.4.218:6000/order/non-universal-card
API PARAMETER : {"cafe_id":83}
Error : Error: TypeError: Cannot read properties of null (reading 'id')

REQUEST DATE : December 13th 2024, 4:32:17 pm
API URL : http://192.168.4.218:6000/order/non-universal-card
API PARAMETER : {"cafe_id":82}
Error : Error: TypeError: Cannot read properties of null (reading 'dataValues')

REQUEST DATE : December 13th 2024, 4:32:20 pm
API URL : http://192.168.4.218:6000/order/non-universal-card
API PARAMETER : {"cafe_id":85}
Error : Error: TypeError: Cannot read properties of null (reading 'id')

REQUEST DATE : December 13th 2024, 4:33:17 pm
API URL : http://192.168.4.218:6000/order/non-universal-card
API PARAMETER : {"cafe_id":82}
Error : Error: TypeError: Cannot read properties of null (reading 'dataValues')

REQUEST DATE : December 13th 2024, 5:58:12 pm
API URL : http://192.168.4.218:6000/order/non-universal-card
API PARAMETER : {"cafe_id":82}
Error : Error: TypeError: Cannot read properties of null (reading 'dataValues')

REQUEST DATE : December 13th 2024, 6:27:20 pm
API URL : http://192.168.4.218:6000/cafe/suggested-item
API PARAMETER : {"item_id":"142,144","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 16th 2024, 7:55:39 am
API URL : http://18.132.176.176:6010/cafe/list
API PARAMETER : {"filter_flag":0,"page":1,"latitude":"51.51958841152327","longitude":"-0.13518328174761302","user_id":297}
Error : Error: SequelizeDatabaseError: Unknown column 'cafes.is_admin_approved' in 'where clause'

REQUEST DATE : December 16th 2024, 7:56:13 am
API URL : http://18.132.176.176:6010/cafe/list
API PARAMETER : {"filter_flag":0,"page":1,"latitude":"51.51958841152327","longitude":"-0.13518328174761302","user_id":297}
Error : Error: SequelizeDatabaseError: Unknown column 'cafes.is_admin_approved' in 'where clause'

REQUEST DATE : December 16th 2024, 7:57:30 am
API URL : http://18.132.176.176:6010/cafe/list
API PARAMETER : {"filter_flag":0,"page":1,"latitude":"51.51958841152327","longitude":"-0.13518328174761302","user_id":297}
Error : Error: SequelizeDatabaseError: Unknown column 'cafes.is_admin_approved' in 'where clause'

REQUEST DATE : December 16th 2024, 8:00:04 am
API URL : http://18.132.176.176:6010/cafe/list
API PARAMETER : {"filter_flag":0,"page":1,"latitude":"51.51958841152327","longitude":"-0.13518328174761302","user_id":297}
Error : Error: SequelizeDatabaseError: Unknown column 'cafes.is_admin_approved' in 'where clause'

REQUEST DATE : December 16th 2024, 8:02:07 am
API URL : http://18.132.176.176:6010/cafe/list
API PARAMETER : {"page":1,"group_id":"89","latitude":"23.0318227","longitude":"72.5552259","filter_flag":0,"user_id":71}
Error : Error: SequelizeDatabaseError: Unknown column 'cafes.is_admin_approved' in 'where clause'

REQUEST DATE : December 16th 2024, 8:02:55 am
API URL : http://18.132.176.176:6010/cafe/list
API PARAMETER : {"page":1,"group_id":"89","latitude":"23.0318227","longitude":"72.5552259","filter_flag":0,"user_id":71}
Error : Error: SequelizeDatabaseError: Unknown column 'cafes.is_admin_approved' in 'where clause'

REQUEST DATE : December 16th 2024, 8:20:01 am
API URL : http://18.132.176.176:6010/cafe/suggested-item
API PARAMETER : {"item_id":"157","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 16th 2024, 8:20:49 am
API URL : http://18.132.176.176:6010/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_3QWZXWH68ivyxSXq1z7ORYIe","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"GERKPZJAV8XRLS2","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, 8:23:56 am
API URL : http://18.132.176.176:6010/cafe/suggested-item
API PARAMETER : {"item_id":"157","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 16th 2024, 8:35:09 am
API URL : http://18.132.176.176:6010/cafe/suggested-item
API PARAMETER : {"item_id":"157","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 16th 2024, 8:36:20 am
API URL : http://18.132.176.176:6010/cafe/suggested-item
API PARAMETER : {"item_id":"157","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 16th 2024, 9:21:22 am
API URL : http://18.132.176.176:6010/cafe/suggested-item
API PARAMETER : {"item_id":"157","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 16th 2024, 9:25:50 am
API URL : http://18.132.176.176:6010/cafe/suggested-item
API PARAMETER : {"item_id":"157","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 16th 2024, 9:47:24 am
API URL : http://18.132.176.176:6010/order
API PARAMETER : {"cafe_id":86,"group_id":153,"additional_note":"","is_main_order":1,"total_amount":190.45,"items_amount":190,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QWatKH68ivyxSXq0bz6detW","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"1U3VDEIPUPNKFRB","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":1},{"item_id":156,"item_name":"ice tea","item_size":"Medium","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/bk9ggEuXQ3RnYkqmY1vm3oEnR3h55fKex5ktpt58.png","addon_sizes":[],"item_amount":100,"item_category":"Iced drinks","item_quantity":1,"item_description":"ice tea in iced drinks","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:52:29 am
API URL : http://18.132.176.176:6010/order
API PARAMETER : {"cafe_id":86,"group_id":153,"additional_note":"","is_main_order":1,"total_amount":100.45,"items_amount":100,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QWayAH68ivyxSXq1tvkE7rU","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"KL6UBJIQ7YTA99Q","order_item_array":[{"item_id":156,"item_name":"ice tea","item_size":"Medium","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/bk9ggEuXQ3RnYkqmY1vm3oEnR3h55fKex5ktpt58.png","addon_sizes":[],"item_amount":100,"item_category":"Iced drinks","item_quantity":1,"item_description":"ice tea in iced drinks","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:55:40 am
API URL : http://18.132.176.176:6010/order
API PARAMETER : {"cafe_id":86,"group_id":153,"additional_note":"","is_main_order":1,"total_amount":190.45,"items_amount":190,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QWb1IH68ivyxSXq1z4tFabg","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"BLRZL6LPMENBE7D","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":1},{"item_id":156,"item_name":"ice tea","item_size":"Medium","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/bk9ggEuXQ3RnYkqmY1vm3oEnR3h55fKex5ktpt58.png","addon_sizes":[],"item_amount":100,"item_category":"Iced drinks","item_quantity":1,"item_description":"ice tea in iced drinks","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:57:16 am
API URL : http://18.132.176.176:6010/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_3QWb2iH68ivyxSXq1qn3pbL2","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"ZUAQDWQKB87G0VJ","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":"Iced drinks","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, 10:03:43 am
API URL : http://18.132.176.176:6010/order
API PARAMETER : {"cafe_id":86,"group_id":153,"additional_note":"","is_main_order":1,"total_amount":100.45,"items_amount":100,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QWb92H68ivyxSXq0cLsKvOp","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"MJZM6PXJ7ZEUGJT","order_item_array":[{"item_id":156,"item_name":"ice tea","item_size":"Medium","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/bk9ggEuXQ3RnYkqmY1vm3oEnR3h55fKex5ktpt58.png","addon_sizes":[],"item_amount":100,"item_category":"Iced drinks","item_quantity":1,"item_description":"ice tea in iced drinks","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, 10:05:12 am
API URL : http://18.132.176.176:6010/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_3QWbAaH68ivyxSXq0xbYMlwA","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"JXUZG7QSJCD0PFN","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":"Iced drinks","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, 10:08:48 am
API URL : http://18.132.176.176:6010/order
API PARAMETER : {"cafe_id":86,"group_id":153,"additional_note":"","is_main_order":1,"total_amount":100.45,"items_amount":100,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QWbDpH68ivyxSXq0m1etQIa","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"VKPW3M1FIKZGVDT","order_item_array":[{"item_id":156,"item_name":"ice tea","item_size":"Medium","item_type":"1","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/bk9ggEuXQ3RnYkqmY1vm3oEnR3h55fKex5ktpt58.png","addon_sizes":[],"item_amount":100,"item_category":"Iced drinks","item_quantity":1,"item_description":"ice tea in iced drinks","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 20th 2024, 6:10:16 am
API URL : http://18.132.176.176:6010/order
API PARAMETER : {"cafe_id":80,"group_id":155,"additional_note":"","is_main_order":1,"total_amount":3.35,"items_amount":2.9,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QXzPHH68ivyxSXq0nRcQgpY","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"UIJ0OAUOOFUPYLM","order_item_array":[{"item_id":136,"item_name":"Espresso","item_size":"Small","item_type":"3","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/TtiERqfKnc68YVI3IEGhKhZ9rlGtkau3725VUkba.png","addon_sizes":[],"item_amount":2.9,"item_category":"","item_quantity":1,"item_description":"Big, bold and chocolatey espresso blend.","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 20th 2024, 6:25:32 am
API URL : http://18.132.176.176:6010/order
API PARAMETER : {"cafe_id":80,"group_id":155,"additional_note":"","is_main_order":1,"total_amount":3.35,"items_amount":2.9,"tax":null,"service_charge":0.45,"other_charge":null,"transaction_id":"pi_3QXze6H68ivyxSXq174VwrYh","loyalty_stamp_id":null,"discount_amount":null,"group_coffee_run_id":"ZW0DJJ5S759FKYA","order_item_array":[{"item_id":136,"item_name":"Espresso","item_size":"Small","item_type":"3","item_image":"https://javago-intelivita-bucket.s3.eu-west-2.amazonaws.com/images/pre-defined-item-images/TtiERqfKnc68YVI3IEGhKhZ9rlGtkau3725VUkba.png","addon_sizes":[],"item_amount":2.9,"item_category":"","item_quantity":1,"item_description":"Big, bold and chocolatey espresso blend.","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)
@ Telegram