vicidial.org

Hi

We have a intermittent problem of leads not loading to hopper, output of AST_VDhopper --debugX is as below. One change was DB server was rebooted (clean restart) last night.
mysql --auto repair and optimize is executed and no tables were corrupt. Is there any log file for AST_VDhopper.pl that which particular lead is creating a problem. I have seen couple of leads in DB with out the phone number . Can it create this issue?


Logs__________________________________________________________________________________________________________________________________
-Adding to hopper: 1
Doing DNC Check: \ - Y
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 ''\'' at line 1 at /usr/share/astguiclient/AST_VDhopper.pl line 2364.
executing: SELECT count(*) FROM vicidial_dnc where phone_number='\'; 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 ''\'' at line 1 at /usr/share/astguiclient/AST_VDhopper.pl line 2364.
____________________________________________________________________________________________________________________________________



thanks in advance

lvish

----------------------------------------------------------------------------
DB ,Web ,Asterisks-- Dell R720 -Hexa core 16GB, -- 60 Agents --64Bit version
Asterisks ,Web -- ML110 , 1 X Quad core 8GB RAM -- 25 Agents --- 4 PRis 32 bit

VERSION: 2.8-409a
130809-1410
Dahdi 2.6 -PRI trunks X 6 no.s
Vicibox 4.0.1,
Balance dialing -- Yes in 1 server where PRI is connected.

I guess you have a lead where alt_phone contains this char: \

try to find it:
SELECT * FROM vicidial_list WHERE alt_phone LIKE '\\'

Thanks Domedan,

There was one lead having '\' in phone_number field . But in the lead info page same lead ID was dialed out few weeks back with proper number and was set as call back . Probably issue started when it was trying to load to hopper as the callback date and time has triggered.

Not sure from where this \ got into phone_number field.

Will do further investigation..

thank you once again.

lvish