vicidial.org

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

What does your Firefox Error Console say when this happens?

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

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

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

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.

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.

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

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

Bingo!

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

Remember to thank him for his post

This is why Matt built this system.