Support

Akeeba Ticket System

#38174 Wrong Last Reply author in the list of tickets (admin)

Posted in ‘Akeeba Ticket System for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
4.2.5
PHP version
n/a
Akeeba Ticket System version
5.2.0

Latest post by b2z on Tuesday, 13 December 2022 01:45 CST

b2z

Hello!

Noticed a small bug. Last reply in the list of tickets is displayed incorrectly.

See the last reply is displayed as from Supporter.

https://postimg.cc/ct7wCDBz

But that is wrong and should be from b2z.

https://postimg.cc/p9n98vvT

Best regards,

Dmitrijs

nicholas
Akeeba Staff
Manager

No, it's not wrong.

What you see is the modified_by field, translated from a user ID to a username. Typically, this field is updated when someone submits a reply. It is also updated when the client or the support staff edits the ticket's information, or modifies the ticket in any way.

Using this field is a deliberate choice that has to do with performance. Right now we only need to query one table, #__ats_tickets, to display a list of tickets. It is already a fairly slow query as it needs to join with the Joomla #__users table twice. If we were to also query the last post on the thread we'd have to do N queries to #__ats_posts where N is the number of tickets (joining with that table is worse, as it would take several minutes for the query to run once you have more than a few thousand posts). I have benchmarked the two alternatives. Reporting the accurate last post author takes between four and ten times as long which translates to the page loading in 3 to 12 seconds instead of under 1.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

b2z

Well, ok. Not so critical.

 

Best regards,

Dmitrijs 

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!