OSticket Version: v1.15.6 (1a64b84)
Web Server Software: Apache/2.4.51 (Win64) PHP/7.4.26
MySQL Version: 5.7.36
PHP Version: 7.4.26

Agent panel hangs after clicking the closed tab

I'm having the captioned issue, this can be recreated if the "Closed" tab or some of the sub menu tab are selected.

Sub menu under "Closed" tab without issue: Today (17), Yesterday (86), This week (103)
Sub menu under "Closed" tab with issue: This Month (1513), This Quarter (1513), This Year (2819)

Admin Panel is still responsive, this issue affects tickets.php.

No error populates in the error logs (PHP, Apache, MySQL) or the "System Logs" within the web app.

Issue is still persistent after upgrading to the latest version (v1.16.7) so it was rolled back.

    Melville-Reid

    Probably a long running query (ie. your system is having trouble executing the SQL query to load the Closed Queue). Enable MySQL slow query logs, set the time limit to 2 seconds and click on the closed queue. Afterwards you should see the query taking a long time to execute. If so then you will need to optimize and repair your database tables, convert all database tables to InnoDB engine, and if all else fails look at the other threads on here for the patch to separate the queue counts into individual queries.

    Cheers.

        8 days later
        Write a Reply...