2023-08-27 19:00:52 - DEBUG --> Service start after 1 minutes.....1
2023-08-27 19:00:52 - DEBUG --> Call reply_email_reminder(): 1
2023-08-27 19:00:52 - DEBUG --> [ SELECT a.* FROM email_outbound a
WHERE to_address not in ('','-') and ((sent_status='0') or (sent_status='Q') or (sent_status is null))
AND subject = 'Reminder Pembayaran Tagihan Internet Megadata' ]
2023-08-27 19:00:52 - DEBUG --> [ UPDATE email_outbound SET sent_time=NOW(), sent_status='Q' WHERE id='94d0df79-19a4-4ed1-9722-40dd21d6f4a2 ' and status !='S' ]
2023-08-27 19:00:52 - DEBUG --> {Query SQL} Failed to execute update ERROR: column "status" does not exist
LINE 1: ...dd21d6f4a2 ' and status !='...
^
2023-08-27 19:03:12 - DEBUG --> Service start after 1 minutes.....1
2023-08-27 19:03:12 - DEBUG --> Call reply_email_reminder(): 1
2023-08-27 19:03:12 - DEBUG --> [ SELECT a.* FROM email_outbound a
WHERE to_address not in ('','-') and ((sent_status='0') or (sent_status='Q') or (sent_status is null))
AND subject = 'Reminder Pembayaran Tagihan Internet Megadata' ]
2023-08-27 19:03:12 - DEBUG --> [ UPDATE email_outbound SET sent_time=NOW(), sent_status='Q' WHERE id='94d0df79-19a4-4ed1-9722-40dd21d6f4a2 ' and status !='S' ]
2023-08-27 19:03:12 - DEBUG --> {Query SQL} Failed to execute update ERROR: column "status" does not exist
LINE 1: ...dd21d6f4a2 ' and status !='...
^
2023-08-27 19:03:54 - DEBUG --> Service start after 1 minutes.....1
2023-08-27 19:03:54 - DEBUG --> Call reply_email_reminder(): 1
2023-08-27 19:03:54 - DEBUG --> [ SELECT a.* FROM email_outbound a
WHERE to_address not in ('','-') and ((sent_status='0') or (sent_status='Q') or (sent_status is null))
AND subject = 'Reminder Pembayaran Tagihan Internet Megadata' ]
2023-08-27 19:03:54 - DEBUG --> [ UPDATE email_outbound SET sent_time=NOW(), sent_status='Q' WHERE id='94d0df79-19a4-4ed1-9722-40dd21d6f4a2 ' and sent_status !='S' ]
2023-08-27 19:03:54 - DEBUG --> Subject :: [ Reminder Pembayaran Tagihan Internet Megadata ]
2023-08-27 19:03:54 - DEBUG --> To Address :: [ hanivxgate@gmail.com ]
2023-08-27 19:03:54 - DEBUG --> To Address CC :: [ ]
2023-08-27 19:03:54 - DEBUG --> To Address BCC :: [ ]
2023-08-27 19:03:54 - DEBUG --> Message :: [
Kepada Yth.
Bapak/Ibu income iss
Terima Kasih atas kepercayaan Anda menggunakan Layanan Internet Megadata – HOME43_internet
Berikut ini adalah informasi tagihan Internet Megadata – HOME43_internet Anda : (Abaikan e-mail ini apabila Anda telah melakukan pembayaran).
Nomor Tagihan : BYR00000006
ID Pelanggan : ISS2308071000002
Status Pembayaran : Menunggu Pembayaran
Total Pembayaran : Rp.430000,-
Jatuh Tempo : 07 September 2023
Untuk proses pembayaran dapat melakukan transfer manual pada
Bank BRI : 051301000340566
Bank BCA : 3200598848
Bank Jateng : 2159040995
Atau dapat mengakses erp.income-iss.com untuk melakukan pembayaran secara online.
Terimakasih,
Income Sukses Sejahtera
]
2023-08-27 19:03:54 - DEBUG --> Email Activate
2023-08-27 19:04:10 - DEBUG --> Message sent!
2023-08-27 19:04:10 - DEBUG --> [ UPDATE email_outbound SET sent_time=NOW(), sent_status='S' WHERE id='94d0df79-19a4-4ed1-9722-40dd21d6f4a2 ' ]
2023-08-27 19:04:10 - DEBUG --> Call reply_email(): 1
2023-08-27 19:04:10 - DEBUG --> [ SELECT a.* FROM email_outbound a
WHERE to_address not in ('','-') and ((sent_status='0') or (sent_status='Q') or (sent_status is null))
AND subject != 'Reminder Pembayaran Tagihan Internet Megadata' ]
2023-08-27 22:06:29 - DEBUG --> Service start after 1 minutes.....1
2023-08-27 22:06:29 - DEBUG --> Call reply_email_reminder(): 1
2023-08-27 22:06:29 - DEBUG --> [ SELECT a.* FROM email_outbound a
WHERE to_address not in ('','-') and ((sent_status='0') or (sent_status='Q') or (sent_status is null))
AND subject = 'Reminder Pembayaran Tagihan Internet Megadata' ]
2023-08-27 22:06:29 - DEBUG --> [ UPDATE email_outbound SET sent_time=NOW(), sent_status='Q' WHERE id='aba8f422-b025-487e-8bba-7e8d9b1118a7 ' and sent_status !='S' ]
2023-08-27 22:06:29 - DEBUG --> Subject :: [ Reminder Pembayaran Tagihan Internet Megadata ]
2023-08-27 22:06:29 - DEBUG --> To Address :: [ hanivxgate@gmail.com ]
2023-08-27 22:06:29 - DEBUG --> To Address CC :: [ ]
2023-08-27 22:06:29 - DEBUG --> To Address BCC :: [ ]
2023-08-27 22:06:29 - DEBUG --> Message :: [
Yang terhormat Bapak/Ibu income iss
Terima Kasih atas kepercayaan Anda menggunakan Layanan Kami
Kami informasikan untuk tagihan internet anda sebagai berikut :
Nomor Tagihan : BYR00000006
ID Pelanggan : ISS2308071000002
Status Pembayaran : Menunggu Pembayaran
Total Pembayaran : Rp.430000,-
Jatuh Tempo : 01 September 2023
Untuk proses pembayaran secara online dapat melalui website payment.income-iss.com. Anda juga dapat melakukan transfer manual melalui rekening berikut :
Bank BRI : 051301000340566
Bank BCA : 3200598848
Bank Jateng : 2159040995
Terimakasih,
Income Sukses Sejahtera
*Mohon abaikan pesan ini apabila telah melakukan pembayaran
]
2023-08-27 22:06:29 - DEBUG --> Email Activate
2023-08-27 22:06:46 - DEBUG --> Message sent!
2023-08-27 22:06:46 - DEBUG --> [ UPDATE email_outbound SET sent_time=NOW(), sent_status='S' WHERE id='aba8f422-b025-487e-8bba-7e8d9b1118a7 ' ]
2023-08-27 22:06:46 - DEBUG --> Call reply_email(): 1
2023-08-27 22:06:46 - DEBUG --> [ SELECT a.* FROM email_outbound a
WHERE to_address not in ('','-') and ((sent_status='0') or (sent_status='Q') or (sent_status is null))
AND subject != 'Reminder Pembayaran Tagihan Internet Megadata' ]