Page 1 of 1
callback not functional sometimes

Posted:
Thu Sep 25, 2008 11:29 am
by Freddy_rixcom
Hi all.
I've posted this one because I cannot find any solutions to a problem I found.
Sometimes, agent dispose a call as callback and vicidial_log show the status record as CBHOLD correctly but in vicidial_callabacks table record is not inserted.
This problem is random and i don't know how to solve it.
Have anyone found this problem before? Can be a client / browser problem?
thanks in advance for any help

Posted:
Thu Sep 25, 2008 12:29 pm
by mflorell
vicidial.php version and build?
Version and Build

Posted:
Fri Sep 26, 2008 1:47 am
by Freddy_rixcom
Hi Matt,
these are version and build of my vicidial.php
version = '2.0.4-142'
build = '71129-2025'
Thanks in advance

Posted:
Fri Sep 26, 2008 8:00 pm
by mflorell
Try upgrading to 2.0.4.1rc4
Upgading

Posted:
Thu Oct 02, 2008 6:39 am
by Freddy_rixcom
Many thanks Matt.
As soon as i can I will upgrade my release.
Just another question: do you think that agents take a callback in the past, for example setting 7:00 AM instead of 7:00 PM, in the current date, may cause this problem? Or taking it over dial time (i.e. out of range 9.00 to 21.00)?
For the upgrade: are existent Mysql data modified by the upgrade process?
thanks in advance as always.
Federico

Posted:
Thu Oct 02, 2008 6:38 pm
by mflorell
There should be no MySQL changes needed upgrading 2.0.4 to 2.0.4.1rc4

Posted:
Wed Dec 31, 2008 4:53 am
by Freddy_rixcom
Hi all,
maybe i've found the reason why callbacks sometimes have problems.
Comments field is varchar 255, if a user write more that 255 chars in comments, database give error and callback is not inserted in table.
Hoping this is useful I wish you all a Happy New Year.

Posted:
Wed Dec 31, 2008 12:45 pm
by mflorell
Are you referring ot callback comments or the customer information comments?
Callbacks comment

Posted:
Fri Jan 02, 2009 3:03 am
by Freddy_rixcom
I'm referring to callback comments

Posted:
Fri Jan 02, 2009 7:25 am
by mflorell
looks like I need to add a "maxlength=255" to that field. Thanks!

Posted:
Mon Jan 05, 2009 3:13 am
by Freddy_rixcom
I've tried to solved it changing MYSQL field from varchar to text.
So if a user need to write more than 255 chars it is possible to do.
Thanks
problem with callbacks solved

Posted:
Tue Jul 21, 2009 8:00 am
by Freddy_rixcom
Hi all
monitoring work of server and agents, I knew today that callbacks don't insert correctly record if it was an escape char in the comment text.
i changhe the following string
$stmt="INSERT INTO vicidial_callbacks (lead_id,list_id,campaign_id,status,entry_time,callback_time,user,recipient,comments,user_group) values('$lead_id','$list_id','$campaign','ACTIVE','$NOW_TIME','$CallBackDatETimE','$user','$recipient','$comments','$user_group');";
to a new one like this
$stmt="INSERT INTO vicidial_callbacks (lead_id,list_id,campaign_id,status,entry_time,callback_time,user,recipient,comments,user_group) values('$lead_id','$list_id','$campaign','ACTIVE','$NOW_TIME','$CallBackDatETimE','$user','$recipient','".addslashes($comments)."','$user_group');";
Now it works perfectly.
See you soon.
HI all

Posted:
Tue Jul 21, 2009 10:10 am
by mflorell
What was the version and build of the vdc_db_query.php file that you did this on?
version vdc_db_query.php

Posted:
Wed Jul 22, 2009 2:32 am
by Freddy_rixcom
hi Matt,
those are build and version
$version = '2.0.4-65';
$build = '71129-2025';

Posted:
Wed Jul 22, 2009 6:19 am
by mflorell
We do not support 2.0.4 anymore. I would suggest upgrading to 2.0.5.1rc1.