Viewing: receive_sms_debug.log (last 200 lines)
[2025-12-07 03:23:48] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:23:48] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:23:48] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:23:48] SQL OK [create sms_responses] affected=0
[2025-12-07 03:23:48] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:23:48] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:23:48] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:23:48] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:23:48] ensure_open_conversation -> cid=282984
[2025-12-07 03:23:48] STMT OK [convo stamp cid=282984] affected=1 insert_id=0
[2025-12-07 03:23:48] STMT OK [convo select-after-stamp cid=282984] affected=-1 insert_id=0
[2025-12-07 03:23:48] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:23:48] STMT OK [msg insert IN cid=282984] affected=1 insert_id=573851
[2025-12-07 03:23:48] STMT OK [convo counters cid=282984] affected=1 insert_id=0
[2025-12-07 03:23:48] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:23:48] STMT OK [smsrec insert] affected=1 insert_id=289170
[2025-12-07 03:23:48] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:23:48] SQL OK [create sms_optins] affected=0
[2025-12-07 03:23:48] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+16192658383','+18624571680',NOW(),'stop')
[2025-12-07 03:23:48] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:23:48] keyword_code:[OPTOUT] is_optout:[1] auto_reply:[1] response_text:[You have been unsubscribed and will no longer receive notifications. Reply SUBSCRIBE to re-enroll.] match:[stop]
[2025-12-07 03:23:48] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:23:48] STMT OK [msg insert OUT cid=282984] affected=1 insert_id=573852
[2025-12-07 03:23:48] STMT OK [convo touch operator cid=282984] affected=1 insert_id=0
[2025-12-07 03:23:48] DONE
[2025-12-07 03:23:57] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:23:57] MO numbers raw_from=14156403574 raw_to(DID)=18624571680 norm_from=+14156403574 norm_to=+18624571680 msgId=789257c8-90fb-4b45-a709-5af9c34b1f0d rec_date=2025-12-07 03:23:57
[2025-12-07 03:23:57] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:23:57] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:23:57] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:23:57] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:23:57] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:23:57] SQL OK [create sms_responses] affected=0
[2025-12-07 03:23:57] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:23:57] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:23:57] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:23:57] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:23:57] ensure_open_conversation -> cid=282985
[2025-12-07 03:23:57] STMT OK [convo stamp cid=282985] affected=1 insert_id=0
[2025-12-07 03:23:57] STMT OK [convo select-after-stamp cid=282985] affected=-1 insert_id=0
[2025-12-07 03:23:57] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:23:57] STMT OK [msg insert IN cid=282985] affected=1 insert_id=573853
[2025-12-07 03:23:57] STMT OK [convo counters cid=282985] affected=1 insert_id=0
[2025-12-07 03:23:57] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:23:57] STMT OK [smsrec insert] affected=1 insert_id=289171
[2025-12-07 03:23:57] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:23:57] SQL OK [create sms_optins] affected=0
[2025-12-07 03:23:57] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+14156403574','+18624571680',NOW(),'stop')
[2025-12-07 03:23:57] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:23:57] keyword_code:[OPTOUT] is_optout:[1] auto_reply:[1] response_text:[You have been unsubscribed and will no longer receive notifications. Reply SUBSCRIBE to re-enroll.] match:[stop]
[2025-12-07 03:23:57] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:23:57] STMT OK [msg insert OUT cid=282985] affected=1 insert_id=573854
[2025-12-07 03:23:57] STMT OK [convo touch operator cid=282985] affected=1 insert_id=0
[2025-12-07 03:23:57] DONE
[2025-12-07 03:24:14] BEGIN method=POST ctype=application/json clen=420
[2025-12-07 03:24:14] MO numbers raw_from=15035397184 raw_to(DID)=18624571680 norm_from=+15035397184 norm_to=+18624571680 msgId=1c949a5c-22b1-452b-ba88-04f8001fc6c8 rec_date=2025-12-07 03:24:14
[2025-12-07 03:24:14] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:24:14] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:24:14] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:24:14] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:24:14] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:24:14] SQL OK [create sms_responses] affected=0
[2025-12-07 03:24:14] STMT OK [keyword reverse-like lookup norm=stoptoend] affected=-1 insert_id=0
[2025-12-07 03:24:14] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:24:14] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:24:14] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:24:14] ensure_open_conversation -> cid=282986
[2025-12-07 03:24:14] STMT OK [convo stamp cid=282986] affected=1 insert_id=0
[2025-12-07 03:24:14] STMT OK [convo select-after-stamp cid=282986] affected=-1 insert_id=0
[2025-12-07 03:24:14] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:24:14] STMT OK [msg insert IN cid=282986] affected=1 insert_id=573855
[2025-12-07 03:24:14] STMT OK [convo counters cid=282986] affected=1 insert_id=0
[2025-12-07 03:24:14] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:24:14] STMT OK [smsrec insert] affected=1 insert_id=289172
[2025-12-07 03:24:14] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:24:14] SQL OK [create sms_optins] affected=0
[2025-12-07 03:24:14] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+15035397184','+18624571680',NOW(),'stop')
[2025-12-07 03:24:14] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:24:14] keyword_code:[OPTOUT] is_optout:[1] auto_reply:[1] response_text:[You have been unsubscribed and will no longer receive notifications. Reply SUBSCRIBE to re-enroll.] match:[stop]
[2025-12-07 03:24:15] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:24:15] STMT OK [msg insert OUT cid=282986] affected=1 insert_id=573856
[2025-12-07 03:24:15] STMT OK [convo touch operator cid=282986] affected=1 insert_id=0
[2025-12-07 03:24:15] DONE
[2025-12-07 03:24:32] BEGIN method=POST ctype=application/json clen=412
[2025-12-07 03:24:32] MO numbers raw_from=15613580925 raw_to(DID)=18624571680 norm_from=+15613580925 norm_to=+18624571680 msgId=8292d111-8ca6-4ea7-893e-e18d170349b4 rec_date=2025-12-07 03:24:32
[2025-12-07 03:24:32] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:24:32] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:24:32] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:24:32] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:24:32] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:24:32] SQL OK [create sms_responses] affected=0
[2025-12-07 03:24:32] STMT OK [keyword reverse-like lookup norm=end] affected=-1 insert_id=0
[2025-12-07 03:24:32] KW result code=OPTOUT optout=1 auto_reply=1 match=end
[2025-12-07 03:24:32] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:24:32] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:24:32] ensure_open_conversation -> cid=282987
[2025-12-07 03:24:32] STMT OK [convo stamp cid=282987] affected=1 insert_id=0
[2025-12-07 03:24:32] STMT OK [convo select-after-stamp cid=282987] affected=-1 insert_id=0
[2025-12-07 03:24:32] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:24:32] STMT OK [msg insert IN cid=282987] affected=1 insert_id=573857
[2025-12-07 03:24:32] STMT OK [convo counters cid=282987] affected=1 insert_id=0
[2025-12-07 03:24:32] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:24:32] STMT OK [smsrec insert] affected=1 insert_id=289173
[2025-12-07 03:24:32] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:24:32] SQL OK [create sms_optins] affected=0
[2025-12-07 03:24:32] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+15613580925','+18624571680',NOW(),'end')
[2025-12-07 03:24:32] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:24:32] keyword_code:[OPTOUT] is_optout:[1] auto_reply:[1] response_text:[You have been unsubscribed and will no longer receive notifications. Reply SUBSCRIBE to re-enroll.] match:[end]
[2025-12-07 03:24:32] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:24:32] STMT OK [msg insert OUT cid=282987] affected=1 insert_id=573858
[2025-12-07 03:24:32] STMT OK [convo touch operator cid=282987] affected=1 insert_id=0
[2025-12-07 03:24:32] DONE
[2025-12-07 03:25:13] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:25:13] MO numbers raw_from=19097099631 raw_to(DID)=18624571680 norm_from=+19097099631 norm_to=+18624571680 msgId=59c41127-35d5-4d1c-af5b-0e906b253f5c rec_date=2025-12-07 03:25:13
[2025-12-07 03:25:13] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:25:13] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:25:13] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:25:13] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:25:13] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:25:13] SQL OK [create sms_responses] affected=0
[2025-12-07 03:25:13] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:25:13] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:25:13] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:25:13] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:25:13] ensure_open_conversation -> cid=282988
[2025-12-07 03:25:13] STMT OK [convo stamp cid=282988] affected=1 insert_id=0
[2025-12-07 03:25:13] STMT OK [convo select-after-stamp cid=282988] affected=-1 insert_id=0
[2025-12-07 03:25:13] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:25:13] STMT OK [msg insert IN cid=282988] affected=1 insert_id=573859
[2025-12-07 03:25:13] STMT OK [convo counters cid=282988] affected=1 insert_id=0
[2025-12-07 03:25:13] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:25:13] STMT OK [smsrec insert] affected=1 insert_id=289174
[2025-12-07 03:25:13] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:25:13] SQL OK [create sms_optins] affected=0
[2025-12-07 03:25:13] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+19097099631','+18624571680',NOW(),'stop')
[2025-12-07 03:25:13] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:25:13] keyword_code:[OPTOUT] is_optout:[1] auto_reply:[1] response_text:[You have been unsubscribed and will no longer receive notifications. Reply SUBSCRIBE to re-enroll.] match:[stop]
[2025-12-07 03:25:13] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:25:13] STMT OK [msg insert OUT cid=282988] affected=1 insert_id=573860
[2025-12-07 03:25:13] STMT OK [convo touch operator cid=282988] affected=1 insert_id=0
[2025-12-07 03:25:13] DONE
[2025-12-07 03:25:48] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:25:48] MO numbers raw_from=15035021981 raw_to(DID)=18624571680 norm_from=+15035021981 norm_to=+18624571680 msgId=1f0e9227-8c0d-4093-9fcb-99ddb6e97fe2 rec_date=2025-12-07 03:25:48
[2025-12-07 03:25:48] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:25:48] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:25:48] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:25:48] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:25:48] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:25:48] SQL OK [create sms_responses] affected=0
[2025-12-07 03:25:48] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:25:48] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:25:48] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:25:48] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:25:48] ensure_open_conversation -> cid=282989
[2025-12-07 03:25:48] STMT OK [convo stamp cid=282989] affected=1 insert_id=0
[2025-12-07 03:25:48] STMT OK [convo select-after-stamp cid=282989] affected=-1 insert_id=0
[2025-12-07 03:25:48] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:25:48] STMT OK [msg insert IN cid=282989] affected=1 insert_id=573861
[2025-12-07 03:25:48] STMT OK [convo counters cid=282989] affected=1 insert_id=0
[2025-12-07 03:25:48] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:25:48] STMT OK [smsrec insert] affected=1 insert_id=289175
[2025-12-07 03:25:48] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:25:48] SQL OK [create sms_optins] affected=0
[2025-12-07 03:25:48] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+15035021981','+18624571680',NOW(),'stop')
[2025-12-07 03:25:48] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:25:48] keyword_code:[OPTOUT] is_optout:[1] auto_reply:[1] response_text:[You have been unsubscribed and will no longer receive notifications. Reply SUBSCRIBE to re-enroll.] match:[stop]
[2025-12-07 03:25:48] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:25:48] STMT OK [msg insert OUT cid=282989] affected=1 insert_id=573862
[2025-12-07 03:25:48] STMT OK [convo touch operator cid=282989] affected=1 insert_id=0
[2025-12-07 03:25:48] DONE
[2025-12-07 03:26:02] BEGIN method=POST ctype=application/json clen=413
[2025-12-07 03:26:02] MO numbers raw_from=13109183644 raw_to(DID)=18624571680 norm_from=+13109183644 norm_to=+18624571680 msgId=9e64d3b3-7948-48c9-87a7-a5377da43781 rec_date=2025-12-07 03:26:02
[2025-12-07 03:26:02] STMT OK [did-lookup exact (raw) cand=18624571680] affected=-1 insert_id=0
[2025-12-07 03:26:02] STMT OK [did-lookup exact (+digits) cand=+18624571680] affected=-1 insert_id=0
[2025-12-07 03:26:02] DID HIT [+digits] cand=+18624571680 did=33 company=24
[2025-12-07 03:26:02] DID resolved did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:26:02] SQL OK [create sms_keywords] affected=0
[2025-12-07 03:26:02] SQL OK [create sms_responses] affected=0
[2025-12-07 03:26:02] STMT OK [keyword reverse-like lookup norm=stop] affected=-1 insert_id=0
[2025-12-07 03:26:02] KW result code=OPTOUT optout=1 auto_reply=1 match=stop
[2025-12-07 03:26:02] SQL OK [create sms_conversations] affected=0
[2025-12-07 03:26:02] SQL OK [create sms_conversation_msgs] affected=0
[2025-12-07 03:26:02] ensure_open_conversation -> cid=282990
[2025-12-07 03:26:02] STMT OK [convo stamp cid=282990] affected=1 insert_id=0
[2025-12-07 03:26:02] STMT OK [convo select-after-stamp cid=282990] affected=-1 insert_id=0
[2025-12-07 03:26:02] CONVO values now did_source_id=33 company_id=24 users_id=0
[2025-12-07 03:26:02] STMT OK [msg insert IN cid=282990] affected=1 insert_id=573863
[2025-12-07 03:26:02] STMT OK [convo counters cid=282990] affected=1 insert_id=0
[2025-12-07 03:26:02] SQL OK [create/alter smsrec] affected=0
[2025-12-07 03:26:02] STMT OK [smsrec insert] affected=1 insert_id=289176
[2025-12-07 03:26:02] SQL OK [create sms_optouts] affected=0
[2025-12-07 03:26:02] SQL OK [create sms_optins] affected=0
[2025-12-07 03:26:02] OPTOUT SQL: INSERT INTO sms_optouts (from_num,to_num,created_at,optout_string) VALUES ('+13109183644','+18624571680',NOW(),'stop')
[2025-12-07 03:26:02] STMT OK [optout upsert] affected=1 insert_id=0
[2025-12-07 03:26:02] keyword_code:[OPTOUT] is_optout:[1] auto_reply:[1] response_text:[You have been unsubscribed and will no longer receive notifications. Reply SUBSCRIBE to re-enroll.] match:[stop]
[2025-12-07 03:26:02] AUTO-REPLY send code=200 curl_errn=0 errm=
[2025-12-07 03:26:02] STMT OK [msg insert OUT cid=282990] affected=1 insert_id=573864
[2025-12-07 03:26:02] STMT OK [convo touch operator cid=282990] affected=1 insert_id=0
[2025-12-07 03:26:02] DONE