search for: vicidial_list

...1 * * * * /usr/share/astguiclient/AST_flush_DBqueue.pl -q ### fix the vicidial_agent_log once every hour 33 * * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl ### updater for VICIDIAL hopper * * * * * /usr/share/astguiclient/AST_VDhopper.pl -q ### adjust the GMT offset for the leads in the vicidial_list table 1 1,7 * * * /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl --debug --postal-code-gmt ### reset several temporary-info tables in the database 2 1 * * * /usr/share/astguiclient/AST_reset_mysql_vars.pl ### optimize the database tables within the asterisk database 3 1 * * * /usr/share/...

...this is what the error looks like... SELECT count(*) FROM vicidial_hopper where campaign_id = '13' and status='READY'; 0 - leads left to call in hopper so the login fails.............. but these queries at the mysql cmd line tell me i got 7 leads in the database select * from vicidial_list; 7 rows in set (0.00 sec) but when i use count it gives this mysql>select count(1) from vicidial_hopper; +----------+ | count(1) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) mysql> select status,count(1) from vicidial_hopper group by status; Empty set (0.00 sec) mysql&...

...||IAX2/u32218094-1|insert to vicidial_manager -- VDAD vac record deleted: |0| |127.0.0.1 |UPDATE vicidial_log set status='DROP',end_epoch='1139506495',length_in_sec='20' where uniqueid = '1139506471.2';| -- VDAD vicidial_log update: |0|1139506471.2 |UPDATE vicidial_list set status='DROP' where lead_id = '0';| -- VDAD vicidial_list update: |0|0 -- AGI Script agi-VDADtransfer.agi completed, returning 0 -- Executing AGI("IAX2/u32218094-1", "agi-VDADtransfer.agi|8365") in new stack -- Launched AGI Script /var/lib/aste...