PHP Warning: array_search() expects parameter 2 to be array, null given in /home/manage2/public_html/inc/process_functions.php on line 97 PHP Warning: array_search() expects parameter 2 to be array, null given in /home/manage2/public_html/inc/process_functions.php on line 98 2023-11-11 05:00:02[LOG]Starting Cron sh: line 0: kill: (17932) - No such process Kill Existing Process : 17932 SELECT * FROM voice_invoice_pulses_list WHERE status=0 AND campaign_start_date < 1699641000 no of campaigns : 37 SELECT * FROM voice_compaign_summary WHERE compaign_id=37250 LIMIT 1 campaign id found in summary tbl 37250 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37251 LIMIT 1 campaign id found in summary tbl 37251 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37251 LIMIT 1 campaign id found in summary tbl 37251 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37252 LIMIT 1 campaign id found in summary tbl 37252 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37252 LIMIT 1 campaign id found in summary tbl 37252 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37253 LIMIT 1 campaign id found in summary tbl 37253 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37254 LIMIT 1 campaign id found in summary tbl 37254 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37265 LIMIT 1 campaign id found in summary tbl 37265 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37270 LIMIT 1 campaign id found in summary tbl 37270 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37285 LIMIT 1 campaign id found in summary tbl 37285 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37285 LIMIT 1 campaign id found in summary tbl 37285 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37293 LIMIT 1 campaign id found in summary tbl 37293 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37304 LIMIT 1 campaign id found in summary tbl 37304 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37314 LIMIT 1 campaign id found in summary tbl 37314 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37314 LIMIT 1 campaign id found in summary tbl 37314 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37314 LIMIT 1 campaign id found in summary tbl 37314 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37330 LIMIT 1 campaign id found in summary tbl 37330 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37330 LIMIT 1 campaign id found in summary tbl 37330 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37336 LIMIT 1 campaign id found in summary tbl 37336 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37336 LIMIT 1 campaign id found in summary tbl 37336 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37345 LIMIT 1 campaign id found in summary tbl 37345 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37345 LIMIT 1 campaign id found in summary tbl 37345 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37428 LIMIT 1 campaign id found in summary tbl 37428 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37428 LIMIT 1 campaign id found in summary tbl 37428 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37765 LIMIT 1 campaign id found in summary tbl 37765 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=46720 LIMIT 1 campaign id found in summary tbl 46720 campaign reports counter is less than total sms pending report count is less than 50 so updating no of records : 1 cron_voice_compaign_user_credit_update cron run SELECT * FROM `voice_compaign_summary` WHERE status ='C' AND `sent_sms`<=(`answered_sms`+`busy_sms`+`congestion_sms`+`failed_sms`+`hangup_sms`+`no_answer_sms`+`timeout_duration_sms`+`timeout_ring_sms`+`cutting_sms`+`dnd_sms` ) AND total_sms=sent_sms+duplicate_sms AND compaign_file!=1 AND user_report_adjust=0 AND answer_per>0 AND manual_set=0 AND start_date>'1699227087' Compaign : 55247 \compaign_type : ATans per 38.38667
ans sms 4
dnd sms 0

require answer per : 2

user answer per : 3
Total Failed : 0 no_answer_count : 0 Busy count :0 congestion_count : 0 failed_count : 0 three Time Diff : 2504 SELECT * FROM voice_compaign_summary WHERE compaign_id=46720 LIMIT 1 campaign id found in summary tbl 46720 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=48120 LIMIT 1 campaign id found in summary tbl 48120 campaign reports counter is less than total sms pending report count is less than 50 so updating no of records : 1 cron_voice_compaign_user_credit_update cron run SELECT * FROM voice_compaign_summary WHERE compaign_id=48120 LIMIT 1 campaign id found in summary tbl 48120 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=51736 LIMIT 1 campaign id found in summary tbl 51736 campaign reports counter is less than total sms pending report count is less than 50 so updating no of records : 1 cron_voice_compaign_user_credit_update cron run SELECT * FROM voice_compaign_summary WHERE compaign_id=51736 LIMIT 1 campaign id found in summary tbl 51736 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=51812 LIMIT 1 campaign id found in summary tbl 51812 campaign reports counter is less than total sms pending report count is less than 50 so updating no of records : 1 cron_voice_compaign_user_credit_update cron run SELECT * FROM voice_compaign_summary WHERE compaign_id=51812 LIMIT 1 campaign id found in summary tbl 51812 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=52904 LIMIT 1 campaign id found in summary tbl 52904 campaign reports counter is less than total sms pending report count is less than 50 so updating no of records : 1 cron_voice_compaign_user_credit_update cron run SELECT * FROM voice_compaign_summary WHERE compaign_id=52904 LIMIT 1 campaign id found in summary tbl 52904 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=54629 LIMIT 1 campaign id found in summary tbl 54629 campaign reports counter is less than total sms pending report count is less than 50 so updating no of records : 1 cron_voice_compaign_user_credit_update cron run SELECT * FROM voice_compaign_summary WHERE compaign_id=54629 LIMIT 1 campaign id found in summary tbl 54629 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert PHP Warning: array_search() expects parameter 2 to be array, null given in /home/manage2/public_html/inc/process_functions.php on line 97 PHP Warning: array_search() expects parameter 2 to be array, null given in /home/manage2/public_html/inc/process_functions.php on line 98 2023-11-11 07:00:01[LOG]Starting Cron sh: line 0: kill: (23502) - No such process Kill Existing Process : 23502 SELECT * FROM voice_invoice_pulses_list WHERE status=0 AND campaign_start_date < 1699641000 no of campaigns : 25 SELECT * FROM voice_compaign_summary WHERE compaign_id=37250 LIMIT 1 campaign id found in summary tbl 37250 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37251 LIMIT 1 campaign id found in summary tbl 37251 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37251 LIMIT 1 campaign id found in summary tbl 37251 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37252 LIMIT 1 campaign id found in summary tbl 37252 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37252 LIMIT 1 campaign id found in summary tbl 37252 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37253 LIMIT 1 campaign id found in summary tbl 37253 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37254 LIMIT 1 campaign id found in summary tbl 37254 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37265 LIMIT 1 campaign id found in summary tbl 37265 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37270 LIMIT 1 campaign id found in summary tbl 37270 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37285 LIMIT 1 campaign id found in summary tbl 37285 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37285 LIMIT 1 campaign id found in summary tbl 37285 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37293 LIMIT 1 campaign id found in summary tbl 37293 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37304 LIMIT 1 campaign id found in summary tbl 37304 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37314 LIMIT 1 campaign id found in summary tbl 37314 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37314 LIMIT 1 campaign id found in summary tbl 37314 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37314 LIMIT 1 campaign id found in summary tbl 37314 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37330 LIMIT 1 campaign id found in summary tbl 37330 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37330 LIMIT 1 campaign id found in summary tbl 37330 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37336 LIMIT 1 campaign id found in summary tbl 37336 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37336 LIMIT 1 campaign id found in summary tbl 37336 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37345 LIMIT 1 campaign id found in summary tbl 37345 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37345 LIMIT 1 campaign id found in summary tbl 37345 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37428 LIMIT 1 campaign id found in summary tbl 37428 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37428 LIMIT 1 campaign id found in summary tbl 37428 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37765 LIMIT 1 campaign id found in summary tbl 37765 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert PHP Warning: array_search() expects parameter 2 to be array, null given in /home/manage2/public_html/inc/process_functions.php on line 97 PHP Warning: array_search() expects parameter 2 to be array, null given in /home/manage2/public_html/inc/process_functions.php on line 98 2023-11-11 10:00:01[LOG]Starting Cron sh: line 0: kill: (31381) - No such process Kill Existing Process : 31381 SELECT * FROM voice_invoice_pulses_list WHERE status=0 AND campaign_start_date < 1699641000 no of campaigns : 25 SELECT * FROM voice_compaign_summary WHERE compaign_id=37250 LIMIT 1 campaign id found in summary tbl 37250 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37251 LIMIT 1 campaign id found in summary tbl 37251 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37251 LIMIT 1 campaign id found in summary tbl 37251 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37252 LIMIT 1 campaign id found in summary tbl 37252 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37252 LIMIT 1 campaign id found in summary tbl 37252 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37253 LIMIT 1 campaign id found in summary tbl 37253 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37254 LIMIT 1 campaign id found in summary tbl 37254 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37265 LIMIT 1 campaign id found in summary tbl 37265 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37270 LIMIT 1 campaign id found in summary tbl 37270 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37285 LIMIT 1 campaign id found in summary tbl 37285 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37285 LIMIT 1 campaign id found in summary tbl 37285 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37293 LIMIT 1 campaign id found in summary tbl 37293 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37304 LIMIT 1 campaign id found in summary tbl 37304 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37314 LIMIT 1 campaign id found in summary tbl 37314 campaign total_sms is equal as reports count cron_voice_compaign_user_credit_update cron run SELECT * FROM `voice_compaign_summary` WHERE status ='C' AND `sent_sms`<=(`answered_sms`+`busy_sms`+`congestion_sms`+`failed_sms`+`hangup_sms`+`no_answer_sms`+`timeout_duration_sms`+`timeout_ring_sms`+`cutting_sms`+`dnd_sms` ) AND total_sms=sent_sms+duplicate_sms AND compaign_file!=1 AND user_report_adjust=0 AND answer_per>0 AND manual_set=0 AND start_date>'1699245114' Compaign : 55247 \compaign_type : ATans per 37.2059
ans sms 9
dnd sms 0

require answer per : 4

user answer per : 8
Total Failed : 0 no_answer_count : 0 Busy count :0 congestion_count : 0 failed_count : 0 three Time Diff : 3757.222 Compaign : 55256 \compaign_type : ATans per 42.97503
ans sms 28
dnd sms 0

require answer per : 13

user answer per : 13
Total Failed : 0 no_answer_count : 0 Busy count :0 congestion_count : 0 failed_count : 0 three Time Diff : 126.964 SELECT * FROM voice_compaign_summary WHERE compaign_id=37314 LIMIT 1 campaign id found in summary tbl 37314 campaign total_sms is equal as reports count cron_voice_compaign_user_credit_update cron run SELECT * FROM voice_compaign_summary WHERE compaign_id=37314 LIMIT 1 campaign id found in summary tbl 37314 campaign total_sms is equal as reports count cron_voice_compaign_user_credit_update cron run SELECT * FROM voice_compaign_summary WHERE compaign_id=37330 LIMIT 1 campaign id found in summary tbl 37330 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37330 LIMIT 1 campaign id found in summary tbl 37330 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37336 LIMIT 1 campaign id found in summary tbl 37336 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37336 LIMIT 1 campaign id found in summary tbl 37336 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37345 LIMIT 1 campaign id found in summary tbl 37345 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37345 LIMIT 1 campaign id found in summary tbl 37345 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37428 LIMIT 1 campaign id found in summary tbl 37428 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37428 LIMIT 1 campaign id found in summary tbl 37428 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37765 LIMIT 1 campaign id found in summary tbl 37765 campaign total_sms is equal as reports count cron_voice_compaign_user_credit_update cron run PHP Warning: array_search() expects parameter 2 to be array, null given in /home/manage2/public_html/inc/process_functions.php on line 97 PHP Warning: array_search() expects parameter 2 to be array, null given in /home/manage2/public_html/inc/process_functions.php on line 98 2023-11-11 15:00:02[LOG]Starting Cron sh: line 0: kill: (4609) - No such process Kill Existing Process : 4609 SELECT * FROM voice_invoice_pulses_list WHERE status=0 AND campaign_start_date < 1699641000 no of campaigns : 25 SELECT * FROM voice_compaign_summary WHERE compaign_id=37250 LIMIT 1 campaign id found in summary tbl 37250 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37251 LIMIT 1 campaign id found in summary tbl 37251 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37251 LIMIT 1 campaign id found in summary tbl 37251 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37252 LIMIT 1 campaign id found in summary tbl 37252 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37252 LIMIT 1 campaign id found in summary tbl 37252 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37253 LIMIT 1 campaign id found in summary tbl 37253 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37254 LIMIT 1 campaign id found in summary tbl 37254 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37265 LIMIT 1 campaign id found in summary tbl 37265 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37270 LIMIT 1 campaign id found in summary tbl 37270 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37285 LIMIT 1 campaign id found in summary tbl 37285 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37285 LIMIT 1 campaign id found in summary tbl 37285 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37293 LIMIT 1 campaign id found in summary tbl 37293 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37304 LIMIT 1 campaign id found in summary tbl 37304 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37314 LIMIT 1 campaign id found in summary tbl 37314 campaign total_sms is equal as reports count cron_voice_compaign_user_credit_update cron run SELECT * FROM `voice_compaign_summary` WHERE status ='C' AND `sent_sms`<=(`answered_sms`+`busy_sms`+`congestion_sms`+`failed_sms`+`hangup_sms`+`no_answer_sms`+`timeout_duration_sms`+`timeout_ring_sms`+`cutting_sms`+`dnd_sms` ) AND total_sms=sent_sms+duplicate_sms AND compaign_file!=1 AND user_report_adjust=0 AND answer_per>0 AND manual_set=0 AND start_date>'1699263033' Compaign : 55247 \compaign_type : ATans per 39.99641
ans sms 20
dnd sms 0

require answer per : 8

user answer per : 13
Total Failed : 0 no_answer_count : 0 Busy count :0 congestion_count : 0 failed_count : 0 three Time Diff : 2498.95 Compaign : 55248 \compaign_type : ATans per 43.57076
ans sms 19
dnd sms 0

require answer per : 9

user answer per : 5
Total Failed : 0 no_answer_count : 0 Busy count :0 congestion_count : 0 failed_count : 0 three Time Diff : 1629.895 Compaign : 55256 \compaign_type : ATans per 44.59656
ans sms 28
dnd sms 0

require answer per : 13

user answer per : 13
Total Failed : 0 no_answer_count : 0 Busy count :0 congestion_count : 0 failed_count : 0 three Time Diff : 127.036 SELECT * FROM voice_compaign_summary WHERE compaign_id=37314 LIMIT 1 campaign id found in summary tbl 37314 campaign total_sms is equal as reports count cron_voice_compaign_user_credit_update cron run SELECT * FROM voice_compaign_summary WHERE compaign_id=37314 LIMIT 1 campaign id found in summary tbl 37314 campaign total_sms is equal as reports count cron_voice_compaign_user_credit_update cron run SELECT * FROM voice_compaign_summary WHERE compaign_id=37330 LIMIT 1 campaign id found in summary tbl 37330 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37330 LIMIT 1 campaign id found in summary tbl 37330 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37336 LIMIT 1 campaign id found in summary tbl 37336 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37336 LIMIT 1 campaign id found in summary tbl 37336 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37345 LIMIT 1 campaign id found in summary tbl 37345 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37345 LIMIT 1 campaign id found in summary tbl 37345 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37428 LIMIT 1 campaign id found in summary tbl 37428 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37428 LIMIT 1 campaign id found in summary tbl 37428 campaign reports counter is less than total sms pending report count is more than 50 or may be 0 sending alert SELECT * FROM voice_compaign_summary WHERE compaign_id=37765 LIMIT 1 campaign id found in summary tbl 37765 campaign total_sms is equal as reports count cron_voice_compaign_user_credit_update cron run