Vicibox 10 can't call the extended numbers

[frank83]

Hello guys, I installed vicibox 10 with the latest updates but I can't call the extended numbers, someone can help me please?
With the previous version I had no problems.

Thanks

[frank83]

This is the debug of AST_VDhopper.pl

----- SUPER DEBUG -----

TIME DEBUG: 1.00|1.00|0| GMT: 09:15
SELECT list_id FROM vicidial_lists where ( (active='N') or ( (active='Y') and (expiration_date < "2021-11-09") ) );Inactive Lists: 1
Inactive and Expired List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('999') ;|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2021-11-09 10:15:41' and status IN('ACTIVE','TFHCCL') ;|
hopper DNC count: 0
|SELECT count(*) from vicidial_hopper where status='DNC';|
---------------Auto Hopper Level Enabled For CA_TEST---------------------
Number of Agents = 1
Number of Paused Agents = 0
Auto Dial Level = 1
Dial Timeout = 35
Dial Timeout Multiplier = 1.71428571428571
Auto Hopper Multipier = 2.0
Minimum Hopper Level = 10
Auto Hopper Level Adjustment = 4
Final Hopper Level = 10

CAMPAIGNS TO PROCESS HOPPER FOR: 1|0

Starting hopper run for CA_TEST campaign- GMT: 24hours HOPPER LEVEL: 10 ORDER: DOWN|Y|LEAD_ASCEND

|GMT-DAY-HOUR| |13.00-2-2215||12.75-2-2200||12.50-2-2145||12.25-2-2130||12.00-2-2115||11.75-2-2100||11.50-2-2045||11.25-2-2030||11.00-2-2015||10.75-2-2000||10.50-2-1945||10.25-2-1930||10.00-2-1915||9.75-2-1900||9.50-2-1845||9.25-2-1830||9.00-2-1815||8.75-2-1800||8.50-2-1745||8.25-2-1730||8.00-2-1715||7.75-2-1700||7.50-2-1645||7.25-2-1630||7.00-2-1615||6.75-2-1600||6.50-2-1545||6.25-2-1530||6.00-2-1515||5.75-2-1500||5.50-2-1445||5.25-2-1430||5.00-2-1415||4.75-2-1400||4.50-2-1345||4.25-2-1330||4.00-2-1315||3.75-2-1300||3.50-2-1245||3.25-2-1230||3.00-2-1215||2.75-2-1200||2.50-2-1145||2.25-2-1130||2.00-2-1115||1.75-2-1100||1.50-2-1045||1.25-2-1030||1.00-2-1015||0.75-2-1000||0.50-2-945||0.25-2-930||0.00-2-915||-0.25-2-900||-0.50-2-845||-0.75-2-830||-1.00-2-815||-1.25-2-800||-1.50-2-745||-1.75-2-730||-2.00-2-715||-2.25-2-700||-2.50-2-645||-2.75-2-630||-3.00-2-615||-3.25-2-600||-3.50-2-545||-3.75-2-530||-4.00-2-515||-4.25-2-500||-4.50-2-445||-4.75-2-430||-5.00-2-415||-5.25-2-400||-5.50-2-345||-5.75-2-330||-6.00-2-315||-6.25-2-300||-6.50-2-245||-6.75-2-230||-7.00-2-215||-7.25-2-200||-7.50-2-145||-7.75-2-130||-8.00-2-115||-8.25-2-100||-8.50-2-45||-8.75-2-30||-9.00-2-15||-9.25-2-0||-9.50-1-2345||-9.75-1-2330||-10.00-1-2315||-10.25-1-2300||-10.50-1-2245||-10.75-1-2230||-11.00-1-2215||-11.25-1-2200||-11.50-1-2145||-11.75-1-2130||-12.00-1-2115||-12.25-1-2100||-12.50-1-2045||-12.75-1-2030|
|SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_default_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tuesday_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_stop,ct_state_call_times,ct_holidays FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|2|1|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='CA_TEST' and status='READY';|
Processing GMT for list 1001
campaign lists count ACTIVE:1 | TOTAL:1
LIST ID SQL (list_id IN('1001')) |SELECT count(*) from vicidial_hopper where campaign_id='CA_TEST' and status='READY';|
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='CA_TEST' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where (campaign_id='CA_TEST' and ((gmt_offset_now NOT IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ));|
no lead filter defined for campaign: CA_TEST
|NONE|
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('NEW') and ((list_id IN('1001'))) and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) ;|
leads to call count: 0
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('NEW') and ((list_id IN('1001'))) and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
NO DIALABLE LEADS FOR THIS CAMPAIGN
hopper too low (0|10) starting hopper dump
ERROR CANNOT ADD ANY LEADS TO HOPPER
vicidial_campaign_stats_debug UPDATE: 1|UPDATE vicidial_campaign_stats_debug SET entry_time='2021-11-09 10:15:41',debug_output="Starting hopper run for CA_TEST campaign- GMT: 24hours HOPPER LEVEL: 10 ORDER: DOWN|Y|LEAD_ASCEND
Hopper Ready count: 0 Local Call Time: 24hours
campaign lists count ACTIVE: 1 | TOTAL: 1
leads to call count: 0
hopper too low (0|10) starting hopper dump
ERROR CANNOT ADD ANY LEADS TO HOPPER
" where campaign_id='CA_TEST' and server_ip='HOPPER';|

SUMMARY: 1 campaigns
CA_TEST 0 10 0
DONE. Script execution time in seconds: 0

There's this error ERROR CANNOT ADD ANY LEADS TO HOPPER " where campaign_id='CA_TEST' and server_ip='HOPPER' why?

The vicidial_list_alt_phones table is filled rightly, I don't know what else to look at...

[carpenox]

try to run it with --clear-hopper-now i believe is the trigger

[frank83]

Hello carpenox,
I tried but it's the same, the system doesn't call the extended number...it seems to ignore the table vicidial_list_alt_phones, but I don't know how can i debug it, could be a bug?

[carpenox]

it could be, try to submit it to the tracker and see what they say

[frank83]

Ok, thanks bud.

[frank83]

It wasn't the vicibox version but the vicidial update (also the latest version 3589). The problem is on AST_VDauto_dial, the while condition fails because the last operator try to compare $Xlast (value 0 number) and string LAST with the operator != (string are always zero there).
I changed the operator to ne and now it's working fine.

[carpenox]

great postback