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
2024-12-21 05:00:02[LOG]Starting Cron
sh: line 0: kill: (2853256) - No such process
Kill Existing Process : 2853256
SELECT * FROM voice_invoice_pulses_list WHERE status=0 AND campaign_start_date < 1734719400
no of campaigns : 55
SELECT * FROM voice_compaign_summary WHERE compaign_id=551 LIMIT 1
campaign id found in summary tbl 551
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=619 LIMIT 1
campaign id found in summary tbl 619
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=1894 LIMIT 1
campaign id found in summary tbl 1894
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=1894 LIMIT 1
campaign id found in summary tbl 1894
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=2792 LIMIT 1
campaign id found in summary tbl 2792
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=2792 LIMIT 1
campaign id found in summary tbl 2792
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=3677 LIMIT 1
campaign id found in summary tbl 3677
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=3677 LIMIT 1
campaign id found in summary tbl 3677
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=4891 LIMIT 1
campaign id found in summary tbl 4891
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=4891 LIMIT 1
campaign id found in summary tbl 4891
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=5013 LIMIT 1
campaign id found in summary tbl 5013
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=5014 LIMIT 1
campaign id found in summary tbl 5014
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=5048 LIMIT 1
campaign id found in summary tbl 5048
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=5048 LIMIT 1
campaign id found in summary tbl 5048
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=5048 LIMIT 1
campaign id found in summary tbl 5048
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=5054 LIMIT 1
campaign id found in summary tbl 5054
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=5054 LIMIT 1
campaign id found in summary tbl 5054
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=5062 LIMIT 1
campaign id found in summary tbl 5062
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=5062 LIMIT 1
campaign id found in summary tbl 5062
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=5076 LIMIT 1
campaign id found in summary tbl 5076
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=5076 LIMIT 1
campaign id found in summary tbl 5076
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=5078 LIMIT 1
campaign id found in summary tbl 5078
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=5078 LIMIT 1
campaign id found in summary tbl 5078
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=5084 LIMIT 1
campaign id found in summary tbl 5084
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=5084 LIMIT 1
campaign id found in summary tbl 5084
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=5471 LIMIT 1
campaign id found in summary tbl 5471
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=5471 LIMIT 1
campaign id found in summary tbl 5471
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=5503 LIMIT 1
campaign id found in summary tbl 5503
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=5516 LIMIT 1
campaign id found in summary tbl 5516
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=5516 LIMIT 1
campaign id found in summary tbl 5516
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=5526 LIMIT 1
campaign id found in summary tbl 5526
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=5526 LIMIT 1
campaign id found in summary tbl 5526
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=5559 LIMIT 1
campaign id found in summary tbl 5559
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=5559 LIMIT 1
campaign id found in summary tbl 5559
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=5614 LIMIT 1
campaign id found in summary tbl 5614
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>'1734478754' SELECT * FROM voice_compaign_summary WHERE compaign_id=7401 LIMIT 1
campaign id found in summary tbl 7401
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7401 LIMIT 1
campaign id found in summary tbl 7401
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7718 LIMIT 1
campaign id found in summary tbl 7718
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7718 LIMIT 1
campaign id found in summary tbl 7718
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7718 LIMIT 1
campaign id found in summary tbl 7718
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7732 LIMIT 1
campaign id found in summary tbl 7732
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7732 LIMIT 1
campaign id found in summary tbl 7732
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=8817 LIMIT 1
campaign id found in summary tbl 8817
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9387 LIMIT 1
campaign id found in summary tbl 9387
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9387 LIMIT 1
campaign id found in summary tbl 9387
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9387 LIMIT 1
campaign id found in summary tbl 9387
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9387 LIMIT 1
campaign id found in summary tbl 9387
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9696 LIMIT 1
campaign id found in summary tbl 9696
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9696 LIMIT 1
campaign id found in summary tbl 9696
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=12088 LIMIT 1
campaign id found in summary tbl 12088
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=12088 LIMIT 1
campaign id found in summary tbl 12088
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=12238 LIMIT 1
campaign id found in summary tbl 12238
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=12238 LIMIT 1
campaign id found in summary tbl 12238
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=13065 LIMIT 1
campaign id found in summary tbl 13065
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=13066 LIMIT 1
campaign id found in summary tbl 13066
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
2024-12-21 07:00:02[LOG]Starting Cron
sh: line 0: kill: (1753965) - No such process
Kill Existing Process : 1753965
SELECT * FROM voice_invoice_pulses_list WHERE status=0 AND campaign_start_date < 1734719400
no of campaigns : 55
SELECT * FROM voice_compaign_summary WHERE compaign_id=551 LIMIT 1
campaign id found in summary tbl 551
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=619 LIMIT 1
campaign id found in summary tbl 619
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=1894 LIMIT 1
campaign id found in summary tbl 1894
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=1894 LIMIT 1
campaign id found in summary tbl 1894
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=2792 LIMIT 1
campaign id found in summary tbl 2792
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=2792 LIMIT 1
campaign id found in summary tbl 2792
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=3677 LIMIT 1
campaign id found in summary tbl 3677
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=3677 LIMIT 1
campaign id found in summary tbl 3677
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=4891 LIMIT 1
campaign id found in summary tbl 4891
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=4891 LIMIT 1
campaign id found in summary tbl 4891
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=5013 LIMIT 1
campaign id found in summary tbl 5013
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=5014 LIMIT 1
campaign id found in summary tbl 5014
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=5048 LIMIT 1
campaign id found in summary tbl 5048
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=5048 LIMIT 1
campaign id found in summary tbl 5048
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=5048 LIMIT 1
campaign id found in summary tbl 5048
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=5054 LIMIT 1
campaign id found in summary tbl 5054
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=5054 LIMIT 1
campaign id found in summary tbl 5054
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=5062 LIMIT 1
campaign id found in summary tbl 5062
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=5062 LIMIT 1
campaign id found in summary tbl 5062
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=5076 LIMIT 1
campaign id found in summary tbl 5076
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=5076 LIMIT 1
campaign id found in summary tbl 5076
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=5078 LIMIT 1
campaign id found in summary tbl 5078
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=5078 LIMIT 1
campaign id found in summary tbl 5078
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=5084 LIMIT 1
campaign id found in summary tbl 5084
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=5084 LIMIT 1
campaign id found in summary tbl 5084
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=5471 LIMIT 1
campaign id found in summary tbl 5471
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=5471 LIMIT 1
campaign id found in summary tbl 5471
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=5503 LIMIT 1
campaign id found in summary tbl 5503
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=5516 LIMIT 1
campaign id found in summary tbl 5516
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=5516 LIMIT 1
campaign id found in summary tbl 5516
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=5526 LIMIT 1
campaign id found in summary tbl 5526
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=5526 LIMIT 1
campaign id found in summary tbl 5526
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=5559 LIMIT 1
campaign id found in summary tbl 5559
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=5559 LIMIT 1
campaign id found in summary tbl 5559
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=5614 LIMIT 1
campaign id found in summary tbl 5614
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>'1734485402' SELECT * FROM voice_compaign_summary WHERE compaign_id=7401 LIMIT 1
campaign id found in summary tbl 7401
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7401 LIMIT 1
campaign id found in summary tbl 7401
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7718 LIMIT 1
campaign id found in summary tbl 7718
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7718 LIMIT 1
campaign id found in summary tbl 7718
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7718 LIMIT 1
campaign id found in summary tbl 7718
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7732 LIMIT 1
campaign id found in summary tbl 7732
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7732 LIMIT 1
campaign id found in summary tbl 7732
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=8817 LIMIT 1
campaign id found in summary tbl 8817
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9387 LIMIT 1
campaign id found in summary tbl 9387
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9387 LIMIT 1
campaign id found in summary tbl 9387
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9387 LIMIT 1
campaign id found in summary tbl 9387
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9387 LIMIT 1
campaign id found in summary tbl 9387
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9696 LIMIT 1
campaign id found in summary tbl 9696
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9696 LIMIT 1
campaign id found in summary tbl 9696
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=12088 LIMIT 1
campaign id found in summary tbl 12088
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=12088 LIMIT 1
campaign id found in summary tbl 12088
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=12238 LIMIT 1
campaign id found in summary tbl 12238
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=12238 LIMIT 1
campaign id found in summary tbl 12238
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=13065 LIMIT 1
campaign id found in summary tbl 13065
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=13066 LIMIT 1
campaign id found in summary tbl 13066
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
2024-12-21 10:00:01[LOG]Starting Cron
sh: line 0: kill: (2796677) - No such process
Kill Existing Process : 2796677
SELECT * FROM voice_invoice_pulses_list WHERE status=0 AND campaign_start_date < 1734719400
no of campaigns : 55
SELECT * FROM voice_compaign_summary WHERE compaign_id=551 LIMIT 1
campaign id found in summary tbl 551
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=619 LIMIT 1
campaign id found in summary tbl 619
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=1894 LIMIT 1
campaign id found in summary tbl 1894
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=1894 LIMIT 1
campaign id found in summary tbl 1894
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=2792 LIMIT 1
campaign id found in summary tbl 2792
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=2792 LIMIT 1
campaign id found in summary tbl 2792
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=3677 LIMIT 1
campaign id found in summary tbl 3677
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=3677 LIMIT 1
campaign id found in summary tbl 3677
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=4891 LIMIT 1
campaign id found in summary tbl 4891
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=4891 LIMIT 1
campaign id found in summary tbl 4891
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=5013 LIMIT 1
campaign id found in summary tbl 5013
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=5014 LIMIT 1
campaign id found in summary tbl 5014
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=5048 LIMIT 1
campaign id found in summary tbl 5048
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=5048 LIMIT 1
campaign id found in summary tbl 5048
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=5048 LIMIT 1
campaign id found in summary tbl 5048
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=5054 LIMIT 1
campaign id found in summary tbl 5054
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=5054 LIMIT 1
campaign id found in summary tbl 5054
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=5062 LIMIT 1
campaign id found in summary tbl 5062
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=5062 LIMIT 1
campaign id found in summary tbl 5062
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=5076 LIMIT 1
campaign id found in summary tbl 5076
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=5076 LIMIT 1
campaign id found in summary tbl 5076
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=5078 LIMIT 1
campaign id found in summary tbl 5078
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=5078 LIMIT 1
campaign id found in summary tbl 5078
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=5084 LIMIT 1
campaign id found in summary tbl 5084
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=5084 LIMIT 1
campaign id found in summary tbl 5084
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=5471 LIMIT 1
campaign id found in summary tbl 5471
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=5471 LIMIT 1
campaign id found in summary tbl 5471
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=5503 LIMIT 1
campaign id found in summary tbl 5503
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=5516 LIMIT 1
campaign id found in summary tbl 5516
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=5516 LIMIT 1
campaign id found in summary tbl 5516
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=5526 LIMIT 1
campaign id found in summary tbl 5526
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=5526 LIMIT 1
campaign id found in summary tbl 5526
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=5559 LIMIT 1
campaign id found in summary tbl 5559
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=5559 LIMIT 1
campaign id found in summary tbl 5559
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=5614 LIMIT 1
campaign id found in summary tbl 5614
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>'1734496202' SELECT * FROM voice_compaign_summary WHERE compaign_id=7401 LIMIT 1
campaign id found in summary tbl 7401
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7401 LIMIT 1
campaign id found in summary tbl 7401
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7718 LIMIT 1
campaign id found in summary tbl 7718
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7718 LIMIT 1
campaign id found in summary tbl 7718
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7718 LIMIT 1
campaign id found in summary tbl 7718
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7732 LIMIT 1
campaign id found in summary tbl 7732
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7732 LIMIT 1
campaign id found in summary tbl 7732
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=8817 LIMIT 1
campaign id found in summary tbl 8817
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9387 LIMIT 1
campaign id found in summary tbl 9387
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9387 LIMIT 1
campaign id found in summary tbl 9387
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9387 LIMIT 1
campaign id found in summary tbl 9387
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9387 LIMIT 1
campaign id found in summary tbl 9387
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9696 LIMIT 1
campaign id found in summary tbl 9696
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9696 LIMIT 1
campaign id found in summary tbl 9696
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=12088 LIMIT 1
campaign id found in summary tbl 12088
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=12088 LIMIT 1
campaign id found in summary tbl 12088
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=12238 LIMIT 1
campaign id found in summary tbl 12238
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=12238 LIMIT 1
campaign id found in summary tbl 12238
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=13065 LIMIT 1
campaign id found in summary tbl 13065
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=13066 LIMIT 1
campaign id found in summary tbl 13066
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
2024-12-21 15:00:03[LOG]Starting Cron
sh: line 0: kill: (165059) - No such process
Kill Existing Process : 165059
SELECT * FROM voice_invoice_pulses_list WHERE status=0 AND campaign_start_date < 1734719400
no of campaigns : 55
SELECT * FROM voice_compaign_summary WHERE compaign_id=551 LIMIT 1
campaign id found in summary tbl 551
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=619 LIMIT 1
campaign id found in summary tbl 619
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=1894 LIMIT 1
campaign id found in summary tbl 1894
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=1894 LIMIT 1
campaign id found in summary tbl 1894
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=2792 LIMIT 1
campaign id found in summary tbl 2792
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=2792 LIMIT 1
campaign id found in summary tbl 2792
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=3677 LIMIT 1
campaign id found in summary tbl 3677
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=3677 LIMIT 1
campaign id found in summary tbl 3677
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=4891 LIMIT 1
campaign id found in summary tbl 4891
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=4891 LIMIT 1
campaign id found in summary tbl 4891
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=5013 LIMIT 1
campaign id found in summary tbl 5013
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=5014 LIMIT 1
campaign id found in summary tbl 5014
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=5048 LIMIT 1
campaign id found in summary tbl 5048
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=5048 LIMIT 1
campaign id found in summary tbl 5048
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=5048 LIMIT 1
campaign id found in summary tbl 5048
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=5054 LIMIT 1
campaign id found in summary tbl 5054
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=5054 LIMIT 1
campaign id found in summary tbl 5054
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=5062 LIMIT 1
campaign id found in summary tbl 5062
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=5062 LIMIT 1
campaign id found in summary tbl 5062
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=5076 LIMIT 1
campaign id found in summary tbl 5076
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=5076 LIMIT 1
campaign id found in summary tbl 5076
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=5078 LIMIT 1
campaign id found in summary tbl 5078
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=5078 LIMIT 1
campaign id found in summary tbl 5078
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=5084 LIMIT 1
campaign id found in summary tbl 5084
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=5084 LIMIT 1
campaign id found in summary tbl 5084
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=5471 LIMIT 1
campaign id found in summary tbl 5471
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=5471 LIMIT 1
campaign id found in summary tbl 5471
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=5503 LIMIT 1
campaign id found in summary tbl 5503
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=5516 LIMIT 1
campaign id found in summary tbl 5516
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=5516 LIMIT 1
campaign id found in summary tbl 5516
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=5526 LIMIT 1
campaign id found in summary tbl 5526
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=5526 LIMIT 1
campaign id found in summary tbl 5526
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=5559 LIMIT 1
campaign id found in summary tbl 5559
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=5559 LIMIT 1
campaign id found in summary tbl 5559
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=5614 LIMIT 1
campaign id found in summary tbl 5614
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>'1734514203' Array
(
[0] => 14682
[compaign_id] => 14682
[1] => u485
[user_id] => u485
[2] => 15400,
[group_ids] => 15400,
[3] =>
[sender_id] =>
[4] => Eye Camp Vajra Bhaskar Reddy.mp3
[filename] => Eye Camp Vajra Bhaskar Reddy.mp3
[5] => 29
[duration] => 29
[6] => 1
[credits_per_sms] => 1
[7] => 30
[user_pulse] => 30
[8] => 1734772500
[start_date] => 1734772500
[9] => 0
[end_date] => 0
[10] => 7610
[total_sms] => 7610
[11] => 7610
[sent_sms] => 7610
[12] => 0
[duplicate_sms] => 0
[13] => 576
[answered_sms] => 576
[14] => 557
[busy_sms] => 557
[15] => 0
[congestion_sms] => 0
[16] => 1439
[failed_sms] => 1439
[17] => 0
[hangup_sms] => 0
[18] => 541
[no_answer_sms] => 541
[19] => 0
[timeout_duration_sms] => 0
[20] => 0
[timeout_ring_sms] => 0
[21] => 3400
[cutting_sms] => 3400
[22] => 1097
[dnd_sms] => 1097
[23] => 0
[blocked_sms] => 0
[24] => 0
[user_total_sms] => 0
[25] => 0
[user_sent_sms] => 0
[26] => 576
[user_answered_sms] => 576
[27] => 557
[user_busy_sms] => 557
[28] => 0
[user_congestion_sms] => 0
[29] => 1439
[user_failed_sms] => 1439
[30] => 0
[user_hangup_sms] => 0
[31] => 541
[user_no_answer_sms] => 541
[32] => 0
[user_timeout_duration_sms] => 0
[33] => 0
[user_timeout_ring_sms] => 0
[34] => 1097
[user_dnd_sms] => 1097
[35] => 0
[user_report_adjust] => 0
[36] => C
[status] => C
[37] => u485
[created_by] => u485
[38] => 1
[isScheduled] => 1
[39] => 1734770966
[create_date] => 1734770966
[40] => 0
[by_api] => 0
[41] => 0
[isRefund] => 0
[42] => 51
[cutting_per] => 51
[43] => 28
[answer_per] => 28
[44] => 0
[dnd_per] => 0
[45] => 0
[alloted_api] => 0
[46] => 0
[api_pulse] => 0
[47] => 0
[api_ring_time] => 0
[48] => 0
[api_channels] => 0
[49] => {"api_allot_time":1734772506,"compaign_read_start_time":1734772514,"compaign_read_complete_time":1734772644,"compaign_send_start_time":1734772683,"compaign_send_complete_time":1734772748}
[action_time] => {"api_allot_time":1734772506,"compaign_read_start_time":1734772514,"compaign_read_complete_time":1734772644,"compaign_send_start_time":1734772683,"compaign_send_complete_time":1734772748}
[50] => 0
[compaign_file] => 0
[51] => u485_14682_21122024_024505PM_236
[common_name] => u485_14682_21122024_024505PM_236
[52] => 1734753734_u485_voice_upload.wav
[voice_file] => 1734753734_u485_voice_upload.wav
[53] => answered
[plan_type] => answered
[54] => 0
[allowed_hits] => 0
[55] => 0
[used_hits] => 0
[56] => 0
[remote_group_id] => 0
[57] =>
[remote_compaign_id] =>
[58] => 0
[remote_recording_id] => 0
[59] =>
[campaign_create_ip] =>
[60] => contacts_temp_group_15400
[temp_group_table] => contacts_temp_group_15400
[61] => 0
[manual_set] => 0
[62] => 0
[manual_done] => 0
[63] => 1
[occupied] => 1
[64] => 0
[immediate_send] => 0
[65] =>
[remote_compaign_status] =>
[66] =>
[logs] =>
[67] => -1
[message_type] => -1
[68] => -1
[extension_key] => -1
[69] => 4
[credit_seq] => 4
[70] => 0
[reschedule_max] => 0
[71] =>
[reschedule_types] =>
[72] => 0
[reschedule_remaining] => 0
[73] =>
[reschedule_compaign_ids] =>
[74] => 0
[reschedule_last_check_time] => 0
[75] =>
[reschedule_ids] =>
[76] => 0
[contact_start_id] => 0
[77] => 0
[contact_end_id] => 0
[78] =>
[sub_cam_ids] =>
[79] => 0
[parent_compaign_id] => 0
[80] => 1734773402
[last_credit_update_time] => 1734773402
[81] => R
[compaign_type] => R
[82] => 0
[announcement_id] => 0
[83] => S
[api_type] => S
[84] => 802
[user_voice_plan_id] => 802
[85] => 10
[voice_plan_id] => 10
[86] => 0
[gateway_id] => 0
[87] => 30
[pulse] => 30
[88] => 0.25
[pulse_rate] => 0.25
[89] => promo
[delivery_route] => promo
[90] => answered
[delivery_type] => answered
[91] => static
[delivery_cli] => static
[92] =>
[caller_id] =>
[93] => 0
[is_ivr_campaign] => 0
[94] => 0
[ivr_id] => 0
[95] =>
[ivr_flow] =>
[96] => 0
[ivr_deduction] => 0
[97] => 0
[cnt_real_pulse] => 0
[98] => 0
[cnt_used_pulse] => 0
[99] => 0
[cnt_used_pulse_2] => 0
[100] => 0
[cnt_used_pulse_3] => 0
[101] => 0
[dtmf_wait_time] => 0
[102] => 0
[ext_duration] => 0
[103] =>
[rt_time] =>
[104] => 0
[rt_answer_duration] => 0
[105] =>
[clis] =>
[106] => [{"cli":"","g_id":"33"}]
[alloted_apis] => [{"cli":"","g_id":"33"}]
[107] => {"FNA":0,"FBZ":0,"FCG":0,"FFL":0}
[retry_value] => {"FNA":0,"FBZ":0,"FCG":0,"FFL":0}
[108] => 0
[retry_interval] => 0
[109] => 0
[stop_status] => 0
[110] => 0
[pause_resume_status] => 0
[111] =>
[compaign_name] =>
[112] => admin,sr33,sr101,sr124,sr136,u485
[uphierarchy] => admin,sr33,sr101,sr124,sr136,u485
[113] =>
[extra_params_json] =>
)
Compaign : 14682
\compaign_type : Rans per 26.44538
ans sms 7610
dnd sms 1097
require answer perrequire answer per : 1723
user answer per : 576
below is the redis data
1147
UPDATE voice_compaign_detail_14682 SET user_report='D' WHERE (api_id= -2 or report='FCG') AND whitelist_status=0 ORDER BY rand() LIMIT 1147
Total Failed : 2253
no_answer_count : 752
Busy count :579
congestion_count : 268
failed_count : 654UPDATE voice_compaign_detail_14682 SET user_report='FNA' WHERE api_id=-2 AND user_report='' ORDER BY rand() LIMIT 752
UPDATE voice_compaign_detail_14682 SET user_report='FBZ' WHERE api_id=-2 AND user_report='' ORDER BY rand() LIMIT 579
UPDATE voice_compaign_detail_14682 SET user_report='FCG' WHERE api_id=-2 AND user_report='' ORDER BY rand() LIMIT 268
UPDATE voice_compaign_detail_14682 SET user_report='FFL' WHERE api_id=-2 AND user_report='' ORDER BY rand() LIMIT 654
Blank User RecordArray
(
[0] =>
)
Blank User Record End
three UPDATE `voice_compaign_summary` SET `user_answered_sms`='1723', `user_busy_sms`='1136', `user_congestion_sms`='268', `user_failed_sms`='2093', `user_hangup_sms`='0', `user_no_answer_sms`='1293', `user_timeout_duration_sms`='0', `user_timeout_ring_sms`='0', `user_dnd_sms`='1097' WHERE `compaign_id`=14682 LIMIT 1
Time Diff : 0.071
SELECT * FROM voice_compaign_summary WHERE compaign_id=7401 LIMIT 1
campaign id found in summary tbl 7401
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7401 LIMIT 1
campaign id found in summary tbl 7401
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7718 LIMIT 1
campaign id found in summary tbl 7718
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7718 LIMIT 1
campaign id found in summary tbl 7718
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7718 LIMIT 1
campaign id found in summary tbl 7718
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7732 LIMIT 1
campaign id found in summary tbl 7732
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=7732 LIMIT 1
campaign id found in summary tbl 7732
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=8817 LIMIT 1
campaign id found in summary tbl 8817
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9387 LIMIT 1
campaign id found in summary tbl 9387
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9387 LIMIT 1
campaign id found in summary tbl 9387
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9387 LIMIT 1
campaign id found in summary tbl 9387
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9387 LIMIT 1
campaign id found in summary tbl 9387
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9696 LIMIT 1
campaign id found in summary tbl 9696
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=9696 LIMIT 1
campaign id found in summary tbl 9696
campaign total_sms is equal as reports count
cron_voice_compaign_user_credit_update cron run
SELECT * FROM voice_compaign_summary WHERE compaign_id=12088 LIMIT 1
campaign id found in summary tbl 12088
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=12088 LIMIT 1
campaign id found in summary tbl 12088
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=12238 LIMIT 1
campaign id found in summary tbl 12238
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=12238 LIMIT 1
campaign id found in summary tbl 12238
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=13065 LIMIT 1
campaign id found in summary tbl 13065
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=13066 LIMIT 1
campaign id found in summary tbl 13066
campaign reports counter is less than total sms
pending report count is more than 50 or may be 0 sending alert