My server was working fine. But now I am facing a problem on a compagin from today,
My manual compaigns are working fine.
And two compaigns are working on predictive dialing.
One of them is working fine and dialer is doning predictive dialing,
whereas problem is being faced on second compaign whose name is CM26.
leads are not loading in hopper. It shows 0 leads in hopper.
Below is the output
- Code: Select all
[root@dial251 ~]# /usr/share/astguiclient/AST_VDhopper.pl --debug
----- DEBUG -----
TIME DEBUG: 5.00|5.00|0| GMT: 08:19
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 593
Inactive List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','252','255','261','260','258','259','262','263','264','265','266','271','270','272','273','274','275','276','277','278','279','280','281','282','283','284','285','286','287','288','289','290','291','292','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','343','344','345','346','347','348','349','350','351','352','353','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','410','411','412','413','422','423','424','425','426','427','428','431','432','435','437','438','439','440','441','442','443','444','445','446','447','448','449','450','451','452','453','454','455','456','457','458','459','460','461','462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','477','478','479','480','481','482','483','484','485','486','487','488','489','490','491','492','496','494','495','497','498','499','500','501','502','503','504','505','506','507','508','509','510','511','512','513','514','515','516','517','518','519','520','521','522','523','524','525','526','527','528','530','531','532','533','534','535','536','537','538','539','540','541','542','543','544','545','546','547','548','549','550','551','552','553','554','555','556','557','558','559','560','561','562','563','564','565','566','567','568','569','570','571','572','582','573','574','575','576','577','578','579','580','581','583','584','585','586','587','588','589','590','591','592','593','594','595','596','597','598','599','600','601','602','603','604','605','606','607','608','609','610','611','612','613','614','615','616','617','618','619','620','621','622','623','624','625','626','627','628','629','630','631','632','633','634','635','636','637','638','639','640','641','642','643','644','645','646','647','648','649','650','651','652','653','654','655','656','657','658','659','660','661','662','663','664','665','666','667','668','669','670','671','672','673','674','675','676','677','678','679','680','681','682','683','684','685','686','687','688','689','690','691','692','693','694','695','696','697','698','699','700','701','702','703','704','705','706','707','708','709','710','711','712','713','714','715','716','717','718','719','720','721','722','723','724','725','726','727','728','729','730','731','732','733','734','735','736','737','738','739','742','743','744','745','749','750','751','752','753','754','755','756','757','758','759','760','761','762','763','764','765','766','767','768','769','770','771','772','773','774','775','776','777','778','779','781','782','783','785','786','787','788','789','790','791','792','793','794','795','796','797','798','799','800','801','802','803','804','805','806','807','808','809','810','811','812','813','814','815','816','817','818','819','820','821','822','823','824','825','826','827','828','829','830');|
CALLBACK HOLD: 1|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2009-05-04 13:19:52' and status='ACTIVE';|
Scheduled Callbacks Activated: 1
ANYONE Scheduled Callbacks to Insert into hopper: 1
Scheduled Callbacks Activated: 1
ANYONE Scheduled Callback Inserted into hopper: 1|3473243
CAMPAIGNS TO PROCESSES HOPPER FOR: 12|11
Starting hopper run for CM4 campaign- GMT: 24hours HOPPER: 500
hopper DONE cleared: 0E0
hopper GMT BAD cleared: 0E0
hopper READY count: 860
Starting hopper run for CM7 campaign- GMT: 24hours HOPPER: 100
hopper DONE cleared: 0E0
hopper GMT BAD cleared: 0E0
hopper READY count: 196
Starting hopper run for CM9 campaign- GMT: 24hours HOPPER: 500
hopper DONE cleared: 0E0
hopper GMT BAD cleared: 0E0
hopper READY count: 592
Starting hopper run for CM10 campaign- GMT: 24hours HOPPER: 500
hopper DONE cleared: 0E0
hopper GMT BAD cleared: 0E0
hopper READY count: 562
Starting hopper run for CM11 campaign- GMT: 24hours HOPPER: 200
hopper DONE cleared: 0E0
hopper GMT BAD cleared: 0E0
hopper READY count: 292
Starting hopper run for CM15 campaign- GMT: 24hours HOPPER: 500
hopper DONE cleared: 0E0
hopper GMT BAD cleared: 0E0
hopper READY count: 0
hopper too low (0|500) starting hopper dump
campaign lists count: 0 | ''
campaign lists count: 0 | ''
lead filter CM15 defined for CM15
leads to call count: 0
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
Getting Leads to add to hopper
looking for RECYCLE leads, maximum of 100
RECYCLE leads to call count: 0
Adding to hopper: 0
DONE with this campaign
Starting hopper run for CM16 campaign- GMT: 24hours HOPPER: 200
hopper DONE cleared: 0E0
hopper GMT BAD cleared: 0E0
hopper READY count: 0
hopper too low (0|200) starting hopper dump
campaign lists count: 0 | ''
campaign lists count: 0 | ''
lead filter CM16 defined for CM16
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"%7455' at line 1 at /usr/share/astguiclient/AST_VDhopper.pl line 975.
executing: SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('') 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') ) ) and address1 = "Prepaid" and city not like "%6000%" and city not like "%7000%" and city not like "%7003%" and city not like "%7004%" and city not like "%7006%" and city not like "%7008%" and city not like "%7009%" and city not like "%7011%" and city not like "%7012%" and city not like "%7013%" and city not like "%7014%" and city not like "%7016%" and city not like "%7019%" and city not like "%7020%" and city not like "%7023%" and city not like "%7025%" and city not like "%7026%" and city not like "%7029%" and city not like "%7034%" and city not like "%7035%" and city not like "%7036%" and city not like "%7037%" and city not like "%7039%" and city not like "%7042%" and city not like "%7045%" and city not like "%7046%" and city not like "%7049%" and city not like "%7060%" and city not like "%7061%" and city not like "%7063%" and city not like "%7065%" and city not like "%7067%" and city not like "%7069%" and city not like "%7070%" and city not like "%7073%" and city not like "%7074%" and city not like "%7075%" and city not like "%7080%" and city not like "%7084%" and city not like "%7085%" and city not like "%7086%" and city not like "%7091%" and city not like "%7096%" and city not like "%7101%" and city not like"%7104%" and city not like "%7110%" and city not like "%7111%" and city not like "%7112%" and city not like "%7113%" and city not like "%7116%" and city not like "%7117%" and city not like "%7120%" and city not like "%7126%" and city not like "%7128%" and city not like "%7129%" and city not like "%7130%" and city not like "%7136%" and city not like "%7140%" and city not like "%7141%" and city not like "%7142%" and city not like "%7143%" and city not like "%7150%" and city not like "%7151%" and city not like "%7157%" and city not like "%7161%" and city not like "%7171%" and city not like "%7175%" and city not like "%7180%" and city not like "%7188%" and city not like "%7192%" and city not like "%7193%"and city not like "%7198%" and city not like "%7205%" and city not like "%7206%" and city not like "%7211%" and city not like "%7215%" and city not like "%7217%" and city not like "%7228%" and city not like "%7236%" and city not like "%7248%" and city not like "%7249%" and city not like "%7251%" and city not like "%7258%" and city not like "%7278%" and city not like "%7286%" and city not like "%7293%" and city not like "%7297%" and city not like "%7308%" and city not like "%7319%" and city not like "%7334%" and city not like "%7342%" and city not like "%7349%" and city not like "%7357%" and city not like "%7360%" and city not like "%7372%" and city not like "%7383%" and city not like "%7385%" and city not like "%7386%"and city not like "%7388%"and city not like "%7391%" and city not like "%7401%" and city not like "%7409%" and city not like "%7412%" and city not like "%7414%" and city not like "%7415%" and city not like "%7416%" and city not like "%7426%" and city not like "%7427%" and city not like "%7432%" and city not like "%7437%"and city not like "%7291%"and city not like "%7455%"and city not like "%7051%"and city not like "%7212%"and city not like "%7250%"and city not like "%7291%"and city not like "%7229%"and city not like "%7209%"and city not like "%7072%"and city not like "%7387%"and city not like "%7455; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"%7455' at line 1 at /usr/share/astguiclient/AST_VDhopper.pl line 975.