"Ticket Activity" is displayed incorrectly

amqu

Hello everyone,

Issue:
On the "Ticket Activity" page in the osTicket admin panel, the chart is displayed incorrectly — it shifts to the top-left corner of the screen. With 1–2 tickets, the chart appears normally, but after creating more tickets or logging back in, the chart breaks
.

Screenshot Description:
— Dates on the X-axis repeat (e.g., "05-15-2025").
— The Y-axis contains "NaN" values, indicating data or formatting errors.

System Information:

osTicket
v1.18.2 (53339df) — latest version
Web Server
Apache/2.4.62 (Debian)
MySQL
10.5.28
PHP
8.1.31
PHP Extensions
gdlib, iconv, imap, ctype, xml, json, mbstring, phar, intl, fileinfo, zip, APCu, Zend Opcache
PHP Settings
date.timezone = Europe/Moscow, cgi.fix_pathinfo=1
Database
localhost, used 3.34 MiB
Language Packs
Russian (ru_RU.phar, version 173619 for v1.18), English (en_US)

Steps Taken:

The issue reproduces across multiple browsers (Chrome, Firefox, Edge) and devices (PC, laptop, mobile)
.
Clearing browser cache and cookies did not resolve the problem.
Timezone and encoding settings were verified — all match osTicket requirements.
osTicket is up-to-date; no updates available
.
Possible Causes:
— A bug in the chart data processing due to timezone conflicts or a rendering library issue.
— Data generation errors when handling a large number of tickets.

Questions for the Community:
— Has anyone encountered this? How did you fix it?
— Could the issue relate to browser settings or PHP extensions (e.g., gdlib or intl)?

KevinTheJedi

amqu

You didn't read the requirements apparently as v1.18.2 requires PHP 8.2-8.4; you have PHP 8.1 installed. You need to upgrade PHP asap and retest.
If you swap to just english does it work?

Cheers.

amqu

Thank you for your guidance. Here’s an update on the steps I’ve taken and observations:

PHP Upgrade :
Upgraded to PHP 8.3.16 (within the required 8.2–8.4 range for v1.18.2). All required extensions (gdlib, intl, phar, mysqli, etc.) are enabled and confirmed via phpinfo().
Language Switch :
Changed the system language to English (en_US) and cleared browser caches/server caches. The issue persists: the Ticket Activity chart still misaligns , showing repeated dates (e.g., "05-15-2025") and "NaN" values on the Y-axis.
Parallel Testing with Legacy System :
I’m running this new osTicket instance alongside a legacy system for testing. During trials:
Created tickets via email integration.
Deleted test tickets and manually cleared historical data by truncating the EVENT table (as suggested in a forum thread).
Key Question :
Could the manual cleanup of the EVENT table have disrupted the chart’s data integrity? For example:

If the activity graph relies on event logs for date ranges or ticket counts, truncating EVENT might cause empty/invalid datasets, leading to rendering errors.
Are there other tables (e.g., TICKET_ACTIVITY, TICKET_THREAD) that should be cleared synchronously to avoid orphaned records?
Next Steps Requested :
How can I validate the data integrity for the activity chart? Should I check specific SQL queries (e.g., in class.activity-report.php) for malformed outputs?
Are there known conflicts with PHAR plugins or customizations that could affect chart rendering? I’ve disabled all plugins temporarily, but the issue remains.
Could timezone mismatches (Europe/Moscow) or PHP 8.3-specific incompatibilities (e.g., json or date handling) be contributing?
Logs and browser console show no critical errors, but I can share screenshots or sanitized logs if needed.

Thank you for your support—I’d appreciate any targeted troubleshooting steps to resolve this!

Best regards,

KevinTheJedi

amqu

Never manually delete stuff from the database as there are always many associated records that must go as well. If you delete the _thread_events then you will need to delete the associated _thread, _thread_entries, _thread_entry_email, _ticket, _ticket__cdata, _form_entry, _form_entry_values, etc. There are many, many associated records.

Yea you could manually add debug statements to the code to see where it's failing at. I cannot replicate this so I can't really say what's going on without getting errors, logs, etc. of some sort.

Any 3rd party mods/plugins will always cause issues one way or another; which is why we never recommend using them. They always just cause bigger headaches down the road.

Timezones are certainly cause of some issues. Another possibility is the date/time formats in the system settings.

Cheers.