Callback window freezes

[DruRoland]

When agents try to call back leads, the call is not initiated, and the browser window is effectively frozen. This occurred with an upgrade to the latest SVN version yesterday.
/var/log/apache2/error.log repeatedly shows:
[Sat Apr 20 12:31:00 2013] [error] [client 10.0.0.10] PHP Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /srv/www/htdocs/agc/vdc_db_query.php on line 5804, referer: http://dialer2.livecallconnect.com/agc/vicidial.php
[Sat Apr 20 12:31:00 2013] [error] [client 10.0.0.10] PHP Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /srv/www/htdocs/agc/functions.php on line 112, referer: http://dialer2.livecallconnect.com/agc/vicidial.php

[mflorell]

What does your Firefox Error Console say when this happens?

[mflorell]

I can't duplicate this on most recent svn/trunk code.

[williamconley]

not to sound stupid, but the basics ... did you upgrade the db and verify that the upgrade was successful? svn rev? dbschema?

[DruRoland]

FireFox error console message:
[11:16:56.142] vcFormIFrame.document.form_custom_fields[CFN_field] is undefined @ http://dialer.XXX.com/agc/vicidial.php:8540

Yes, I saved a db snapshot, then upgraded the db, then ran install.pl, then rebuilt conf files, then restarted the server.
Post restart I verified screens were all present and doing what they're supposed to.
SVN rev 1968, db_schema_version 1345

[mflorell]

That's an error related in some ways to custom fields. I added some custom fields, added a scheduled callback, then called it back(all in Firefox) and still had no issues.

This may be an issue with your custom fields in some way.

[DruRoland]

We've had the same problem, on 2 different campaigns, with 2 different lists, with 2 different sets of custom variables.
These are also existing campaigns/lists/variables that have been run multiple times previously with no problems.

The agents are using Debian wheezy, with IceWeasel instead of FireFox, though that shouldn't make any difference.

[DruRoland]

Also, newly created callbacks are dialed correctly. It's just ones prior to the update that have the problem.

[williamconley]

Another client of mine posted a fix to this in the Issue Tracker earlier today.

He posted earlier with that same error, but quoted a different one in the Issue Tracker, but I believe it to be related.

http://www.vicidial.org/VICIDIALmantis/view.php?id=485

[DruRoland]

Bingo!

In each list, there was 1 field that had nothing listed under field_type. Set to DISPLAY, and callbacks started working again.

[williamconley]

Remember to thank him for his post

This is why Matt built this system.