FOP2 Community Forum

We have FOP2 v2.31.29 running with FreePBX v15.0.17.34.

When a change is made in FOP, the display (Interface with all the users/console) stops responding, the FOP flashes…showing trying to connect, flashes again, trying to connect, then the windows to select which Queue the user wants to be added shows up then flashes, even after selecting a Queue, it would flash a couple of times. This appears, then to be in a loop, with flashing and trying to connect. Last time I saw this was when trying to update a CSR template from agent to Supervisor and again when an attempt was being made to apply configs in FreePBX.

I think the order of users by alphabet gets disrupted by some users, but not all. Seen the issue where user status is hung and does not change. Also, see that the calls waiting to get into the queue stay at the bottom of the queue. Again, this is on some of the FOP users but not all.

When running, /usr/local/fop2/fop2_server stop, we get the following over and over and it doesn't stop:
PHP Fatal error: SQL Error: SELECT a.agent,unix_timestamp(now())-unix_timestamp(min(datetime)) as ST FROM qagent a LEFT JOIN agent_activity b ON a.agent=b.agent WHERE date(datetime)=CURDATE() GROUP BY b.agent
Table 'qstats.agent_activity' doesn't exist in /var/www/html/fop2/admin/dblib.php on line 108
PHP Fatal error: SQL Error: SELECT a.agent,unix_timestamp(now())-unix_timestamp(min(datetime)) as ST FROM qagent a LEFT JOIN agent_activity b ON a.agent=b.agent WHERE date(datetime)=CURDATE() GROUP BY b.agent
Table 'qstats.agent_activity' doesn't exist in /var/www/html/fop2/admin/dblib.php on line 108
PHP Fatal error: SQL Error: SELECT a.agent,unix_timestamp(now())-unix_timestamp(min(datetime)) as ST FROM qagent a LEFT JOIN agent_activity b ON a.agent=b.agent WHERE date(datetime)=CURDATE() GROUP BY b.agent
Table 'qstats.agent_activity' doesn't exist in /var/www/html/fop2/admin/dblib.php on line 108
PHP Fatal error: SQL Error: SELECT a.agent,unix_timestamp(now())-unix_timestamp(min(datetime)) as ST FROM qagent a LEFT JOIN agent_activity b ON a.agent=b.agent WHERE date(datetime)=CURDATE() GROUP BY b.agent
Table 'qstats.agent_activity' doesn't exist in /var/www/html/fop2/admin/dblib.php on line 108
PHP Fatal error: SQL Error: SELECT a.agent,unix_timestamp(now())-unix_timestamp(min(datetime)) as ST FROM qagent a LEFT JOIN agent_activity b ON a.agent=b.agent WHERE date(datetime)=CURDATE() GROUP BY b.agent
Table 'qstats.agent_activity' doesn't exist in /var/www/html/fop2/admin/dblib.php on line 108
PHP Fatal error: SQL Error: SELECT a.agent,unix_timestamp(now())-unix_timestamp(min(datetime)) as ST FROM qagent a LEFT JOIN agent_activity b ON a.agent=b.agent WHERE date(datetime)=CURDATE() GROUP BY b.agent
Table 'qstats.agent_activity' doesn't exist in /var/www/html/fop2/admin/dblib.php on line 108
PHP Fatal error: SQL Error: SELECT a.agent,unix_timestamp(now())-unix_timestamp(min(datetime)) as ST FROM qagent a LEFT JOIN agent_activity b ON a.agent=b.agent WHERE date(datetime)=CURDATE() GROUP BY b.agent
Table 'qstats.agent_activity' doesn't exist in /var/www/html/fop2/admin/dblib.php on line 108
PHP Fatal error: SQL Error: SELECT a.agent,unix_timestamp(now())-unix_timestamp(min(datetime)) as ST FROM qagent a LEFT JOIN agent_activity b ON a.agent=b.agent WHERE date(datetime)=CURDATE() GROUP BY b.agent
Table 'qstats.agent_activity' doesn't exist in /var/www/html/fop2/admin/dblib.php on line 108