callback not functional sometimes

[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

[mflorell]

vicidial.php version and build?

[Freddy_rixcom]

Hi Matt,
these are version and build of my vicidial.php
version = '2.0.4-142'
build = '71129-2025'
Thanks in advance

[mflorell]

Try upgrading to 2.0.4.1rc4

[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

[mflorell]

There should be no MySQL changes needed upgrading 2.0.4 to 2.0.4.1rc4

[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.

[mflorell]

Are you referring ot callback comments or the customer information comments?

[Freddy_rixcom]

I'm referring to callback comments

[mflorell]

looks like I need to add a "maxlength=255" to that field. Thanks!

[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

[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

[mflorell]

What was the version and build of the vdc_db_query.php file that you did this on?

[Freddy_rixcom]

hi Matt,
those are build and version

$version = '2.0.4-65';
$build = '71129-2025';

[mflorell]

We do not support 2.0.4 anymore. I would suggest upgrading to 2.0.5.1rc1.