- Edited
Dear all,
We have an OsTicket v1.10.4 (035fd0a) installation with Apache/2.4.7 (Ubuntu), MySQL Version 5.5.62 and PHP Version 5.6.39-1+ubuntu14.04.1+deb.sury.org+1 that always had 0s in Statistics table, while at the same time proper numbers are shown in the Ticket Activity Diagram!
This is the System information page:
and the screenshot of the Statistics table showing the problem (Topics and Agent tabs also have 0s only):
Time and Date formats are as follows:
FYI, this server has been upgraded several times (from 1.9.4-6-12-15 and then to 1.10.x versions), so I fear (if nothing more obvious comes to mind) that /maybe/ I missed a DB upgrade in the meantime (or was not applied properly) or that a time/date/locale setting messes things up?
Also, I should note that i get no PHP errors when accessing the statistics page and that all date-related queries in advanced ticket search page, show the proper results.
I know that the statistics component is old, and may not be very accurate (and also that it will be revamped in newer versions). What I fear the most is that the 0s might not be an issue of the reports code (class.report.php is verified to be the current version) but an issue of the DB, or something that has to do with time/date formatting, and hence, it will remain even in the new version.
Any ideas would be welcome!
ps. I also read the forum about other issues in Service and Respond time of the reports page. I applied as a test the patch from the #3738 pull request in GitHub and numbers in Service and Respond time changed from 0s to actual numbers! (all the other columns kept showing 0s). Then I reverted the patch because it is of minor importance to us (and because it has no value if the general problem with 0s is not solved first)