2023-08-13 8:04:23 - DEBUG --> Service start after 1 minutes.....1 2023-08-13 8:04:23 - DEBUG --> Call reply_wa(): 1 2023-08-13 8:04:23 - DEBUG --> [ SELECT a.* FROM wa_outbound a WHERE a.to_number not in ('','-') and ((status='0') or (status='Q') or (status is null)) ] 2023-08-13 8:04:23 - DEBUG --> [ UPDATE wa_outbound SET updated_time=NOW(), status='Q' WHERE id='65b73c53-18a9-4748-ae4d-e9905dfa272e ' and sent_retry <= 3 ] 2023-08-13 8:04:23 - DEBUG --> {Query SQL} Failed to execute update ERROR: column "updated_time" of relation "wa_outbound" does not exist LINE 1: UPDATE wa_outbound SET updated_time=NOW(), status='Q' WHERE ... ^ 2023-08-13 8:05:01 - DEBUG --> Service start after 1 minutes.....1 2023-08-13 8:05:01 - DEBUG --> Call reply_wa(): 1 2023-08-13 8:05:01 - DEBUG --> [ SELECT a.* FROM wa_outbound a WHERE a.to_number not in ('','-') and ((status='0') or (status='Q') or (status is null)) ] 2023-08-13 8:05:01 - DEBUG --> [ UPDATE wa_outbound SET update_time=NOW(), status='Q' WHERE id='65b73c53-18a9-4748-ae4d-e9905dfa272e ' and sent_retry <= 3 ] 2023-08-13 8:05:01 - DEBUG --> Message sent!{"status":false,"message":"token invalid","token":"xbnzZrDtbZ51BTevkojC18Sf4rcx200F3b1pg1ptPe5YLdgi8LgdBxbDSYoyhbfJ"} 2023-08-13 8:05:01 - DEBUG --> [ UPDATE wa_outbound SET update_time=NOW(), status='S' WHERE id='65b73c53-18a9-4748-ae4d-e9905dfa272e ' ] 2023-08-13 8:05:01 - DEBUG --> [ UPDATE wa_outbound SET update_time=NOW(), status='Q' WHERE id='26fbb33b-4188-467e-a873-8c7039af1e99 ' and sent_retry <= 3 ] 2023-08-13 8:05:01 - DEBUG --> Message sent!{"status":false,"message":"token invalid","token":"xbnzZrDtbZ51BTevkojC18Sf4rcx200F3b1pg1ptPe5YLdgi8LgdBxbDSYoyhbfJ"} 2023-08-13 8:05:01 - DEBUG --> [ UPDATE wa_outbound SET update_time=NOW(), status='S' WHERE id='26fbb33b-4188-467e-a873-8c7039af1e99 ' ] 2023-08-13 8:06:00 - DEBUG --> Service start after 1 minutes.....1 2023-08-13 8:06:00 - DEBUG --> Call reply_wa(): 1 2023-08-13 8:06:00 - DEBUG --> [ SELECT a.* FROM wa_outbound a WHERE a.to_number not in ('','-') and ((status='0') or (status='Q') or (status is null)) ] 2023-08-13 8:06:00 - DEBUG --> [ UPDATE wa_outbound SET update_time=NOW(), status='Q' WHERE id='65b73c53-18a9-4748-ae4d-e9905dfa272e ' and sent_retry <= 3 ] 2023-08-13 8:06:00 - DEBUG --> Message sent!{"status":false,"message":"token invalid","token":"xbnzZrDtbZ51BTevkojC18Sf4rcx200F3b1pg1ptPe5YLdgi8LgdBxbDSYoyhbfJ"} 2023-08-13 8:06:00 - DEBUG --> [ UPDATE wa_outbound SET update_time=NOW(), status='S' WHERE id='65b73c53-18a9-4748-ae4d-e9905dfa272e ' ] 2023-08-13 8:07:45 - DEBUG --> Service start after 1 minutes.....1 2023-08-13 8:07:45 - DEBUG --> Call reply_wa(): 1 2023-08-13 8:07:45 - DEBUG --> [ SELECT a.* FROM wa_outbound a WHERE a.to_number not in ('','-') and ((status='0') or (status='Q') or (status is null)) ] 2023-08-13 22:50:41 - DEBUG --> Service start after 1 minutes.....1 2023-08-13 22:50:41 - DEBUG --> Call reply_wa(): 1 2023-08-13 22:50:41 - DEBUG --> [ SELECT a.* FROM wa_outbound a WHERE a.to_number not in ('','-') and ((status='0') or (status='Q') or (status is null)) ] 2023-08-13 22:50:41 - DEBUG --> [ UPDATE wa_outbound SET update_time=NOW(), status='Q' WHERE id='65b73c53-18a9-4748-ae4d-e9905dfa272e ' and sent_retry <= 3 ] 2023-08-13 22:50:41 - DEBUG --> Message sent!{"status":true,"message":"Text Message is pending and waiting to be processed. with error: 0","data":{"device_id":"6D10M1","quota":59999,"messages":[{"id":"bcadaaf2-df0c-49f0-ba3b-075ca98cf931","phone":"6282115146714","message":"Kepada Yth.\r\nBapak\/Ibu *income iss*\r\n\r\nTerima Kasih atas kepercayaan Anda menggunakan HOME43 Internet Stream Fast By Megadata - *HOME43_internet*\r\nBerikut ini adalah informasi tagihan Internet Stream Fast By Megadata - *HOME43_internet* Anda : (Abaikan pesan ini apabila Anda telah melakukan pembayaran).\r\n \r\nNomor Tagihan : *BYR00000006*\r\nID Pelanggan : *ISS2308071000002*\r\nStatus Pembayaran : *Menunggu Pembayaran*\r\nTotal Pembayaran : *Total Biaya + Biaya Administrasi sesuai metode pembayaran*\r\nJatuh Tempo : *07 September 2023*\r\n \r\nUntuk proses pembayaran dapat melakukan transfer manual pada\r\nBank BRI : 051301000340566\r\nBank BCA : 3200598848\r\nBank Jateng : 2159040995\r\n \r\nAtau dapat mengakses erp.income-iss.com untuk melakukan pembayaran secara online.\r\n \r\n \r\nTerimakasih,\r\n \r\n \r\n*Income Sukses Sejahtera*","status":"pending","ref_id":null}]}} 2023-08-13 22:50:41 - DEBUG --> [ UPDATE wa_outbound SET update_time=NOW(), status='S' WHERE id='65b73c53-18a9-4748-ae4d-e9905dfa272e ' ] 2023-08-13 23:07:37 - DEBUG --> Service start after 1 minutes.....1 2023-08-13 23:07:37 - DEBUG --> Call reply_wa(): 1 2023-08-13 23:07:37 - DEBUG --> [ SELECT a.* FROM wa_outbound a WHERE a.to_number not in ('','-') and ((status='0') or (status='Q') or (status is null)) ] 2023-08-13 23:07:37 - DEBUG --> [ UPDATE wa_outbound SET update_time=NOW(), status='Q' WHERE id='fd9fc7cc-a28c-41e3-a53e-7b8b88f82571 ' and sent_retry <= 3 ] 2023-08-13 23:07:37 - DEBUG --> Message sent!{"status":true,"message":"Text Message is pending and waiting to be processed. with error: 0","data":{"device_id":"6D10M1","quota":59998,"messages":[{"id":"bf33e9d6-909e-4fb7-a48c-f7829533fd42","phone":"62882115146714","message":"Kepada Yth.\r\nBapak\/Ibu *income iss*\r\n\r\nTerima Kasih atas kepercayaan Anda menggunakan Layanan Internet Megadata - *HOME43_internet*\r\nBerikut ini adalah informasi tagihan Internet Megadata - *HOME43_internet* Anda : (Abaikan pesan ini apabila Anda telah melakukan pembayaran).\r\n \r\nNomor Tagihan : *BYR00000006*\r\nID Pelanggan : *ISS2308071000002*\r\nStatus Pembayaran : *Menunggu Pembayaran*\r\nTotal Pembayaran : *Total Biaya + Biaya Administrasi sesuai metode pembayaran*\r\nJatuh Tempo : *07 September 2023*\r\n \r\nUntuk proses pembayaran dapat melakukan transfer manual pada\r\nBank BRI : 051301000340566\r\nBank BCA : 3200598848\r\nBank Jateng : 2159040995\r\n \r\nAtau dapat mengakses erp.income-iss.com untuk melakukan pembayaran secara online.\r\n \r\n \r\nTerimakasih,\r\n \r\n \r\n*Income Sukses Sejahtera*","status":"pending","ref_id":null}]}} 2023-08-13 23:07:37 - DEBUG --> [ UPDATE wa_outbound SET update_time=NOW(), status='S' WHERE id='fd9fc7cc-a28c-41e3-a53e-7b8b88f82571 ' ] 2023-08-13 23:13:26 - DEBUG --> Service start after 1 minutes.....1 2023-08-13 23:13:26 - DEBUG --> Call reply_wa(): 1 2023-08-13 23:13:26 - DEBUG --> [ SELECT a.* FROM wa_outbound a WHERE a.to_number not in ('','-') and ((status='0') or (status='Q') or (status is null)) ] 2023-08-13 23:13:26 - DEBUG --> [ UPDATE wa_outbound SET update_time=NOW(), status='Q' WHERE id='87a205ba-be75-4e5c-8fa4-d2d36d656803 ' and sent_retry <= 3 ] 2023-08-13 23:13:26 - DEBUG --> Message sent!{"status":true,"message":"Text Message is pending and waiting to be processed. with error: 0","data":{"device_id":"6D10M1","quota":59997,"messages":[{"id":"b31dc45e-5d71-4445-a6ce-a0c8c6de4cce","phone":"082115146714","message":"Kepada Yth.\r\nBapak\/Ibu *income iss*\r\n\r\nTerima Kasih atas kepercayaan Anda menggunakan Layanan Internet Megadata - *HOME43_internet*\r\nBerikut ini adalah informasi tagihan Internet Megadata - *HOME43_internet* Anda : (Abaikan pesan ini apabila Anda telah melakukan pembayaran).\r\n \r\nNomor Tagihan : *BYR00000006*\r\nID Pelanggan : *ISS2308071000002*\r\nStatus Pembayaran : *Menunggu Pembayaran*\r\nTotal Pembayaran : *Total Biaya + Biaya Administrasi sesuai metode pembayaran*\r\nJatuh Tempo : *07 September 2023*\r\n \r\nUntuk proses pembayaran dapat melakukan transfer manual pada\r\nBank BRI : 051301000340566\r\nBank BCA : 3200598848\r\nBank Jateng : 2159040995\r\n \r\nAtau dapat mengakses erp.income-iss.com untuk melakukan pembayaran secara online.\r\n \r\n \r\nTerimakasih,\r\n \r\n \r\n*Income Sukses Sejahtera*","status":"pending","ref_id":null}]}} 2023-08-13 23:13:26 - DEBUG --> [ UPDATE wa_outbound SET update_time=NOW(), status='S' WHERE id='87a205ba-be75-4e5c-8fa4-d2d36d656803 ' ] 2023-08-13 23:22:35 - DEBUG --> Service start after 1 minutes.....1 2023-08-13 23:22:35 - DEBUG --> Call reply_wa(): 1 2023-08-13 23:22:35 - DEBUG --> [ SELECT a.* FROM wa_outbound a WHERE a.to_number not in ('','-') and ((status='0') or (status='Q') or (status is null)) ] 2023-08-13 23:22:35 - DEBUG --> [ UPDATE wa_outbound SET update_time=NOW(), status='Q' WHERE id='1c9d38b2-8e4f-483a-8ee1-658d0610c381 ' and sent_retry <= 3 ] 2023-08-13 23:22:35 - DEBUG --> Message sent!{"status":true,"message":"Text Message is pending and waiting to be processed. with error: 0","data":{"device_id":"6D10M1","quota":59996,"messages":[{"id":"8b857926-7bcd-4918-b69c-aae5f477a7e5","phone":"6282115146714","message":"Kepada Yth.\r\nBapak\/Ibu *income iss*\r\n\r\nTerima Kasih atas kepercayaan Anda menggunakan Layanan Internet Megadata - *HOME43_internet*\r\nBerikut ini adalah informasi tagihan Internet Megadata - *HOME43_internet* Anda : (Abaikan pesan ini apabila Anda telah melakukan pembayaran).\r\n \r\nNomor Tagihan : *BYR00000006*\r\nID Pelanggan : *ISS2308071000002*\r\nStatus Pembayaran : *Menunggu Pembayaran*\r\nTotal Pembayaran : *Total Biaya + Biaya Administrasi sesuai metode pembayaran*\r\nJatuh Tempo : *07 September 2023*\r\n \r\nUntuk proses pembayaran dapat melakukan transfer manual pada\r\nBank BRI : 051301000340566\r\nBank BCA : 3200598848\r\nBank Jateng : 2159040995\r\n \r\nAtau dapat mengakses erp.income-iss.com untuk melakukan pembayaran secara online.\r\n \r\n \r\nTerimakasih,\r\n \r\n \r\n*Income Sukses Sejahtera*","status":"pending","ref_id":null}]}} 2023-08-13 23:22:35 - DEBUG --> [ UPDATE wa_outbound SET update_time=NOW(), status='S' WHERE id='1c9d38b2-8e4f-483a-8ee1-658d0610c381 ' ]