Merge Selected Tickets Bug? -- Not chronological order by date
Posted: Wed Feb 05, 2020 3:31 pm
Script URL: mixingonbeat.com/support/
Version of script: 2.8.5
Hosting company: canaca.com
URL of phpinfo.php: PHP 7.*
URL of session_test.php:
What terms did you try when SEARCHING for a solution:
Write your message below:
What I did was merge multiple older and newer tickets into one ticket. Once I completed this, I noticed that the ticket replies were not on a chronological order by date (from oldest to newest). The last replies at the bottom were below the most recent replies (by date).
I believe the issue was that I did not do this in one hit, but several at different times when I did the merging.
NOTE: Under the Help Desk settings, I have the following setting: Reply order set to Newest reply at bottom
P.S. the reason why I did the merge, was that the end-user had told me that he had used a different work email, and he asked me if I could merge those previous older tickets to the ongoing ticket we were discussing, in order to have a source of past conversations in one ticket page and etc.
In order for me to solve my issue with the ticket page not showing all the replies in a chronological order by date, I had to go into my cPanel and adjust the SQL database, by renumbering the ID numbers under the hesk_replies table for that ticket number. -- It seems to me that when topics get merged all the ID numbers get renumbered to a certain order (I guess?), and it seems that the ticket page fetches those ID numbers to set the reply order on the ticket page.
I wonder if it would be best if it should order them by the Date column instead of the ID column from the SQL table? I think that would be more accurate to avoid this mishap, but again, this is just speculation on my part, maybe there is a better fix for this?
Let me know if you have any additional questions or something for me to test and etc.
Version of script: 2.8.5
Hosting company: canaca.com
URL of phpinfo.php: PHP 7.*
URL of session_test.php:
What terms did you try when SEARCHING for a solution:
Write your message below:
What I did was merge multiple older and newer tickets into one ticket. Once I completed this, I noticed that the ticket replies were not on a chronological order by date (from oldest to newest). The last replies at the bottom were below the most recent replies (by date).
I believe the issue was that I did not do this in one hit, but several at different times when I did the merging.
NOTE: Under the Help Desk settings, I have the following setting: Reply order set to Newest reply at bottom
P.S. the reason why I did the merge, was that the end-user had told me that he had used a different work email, and he asked me if I could merge those previous older tickets to the ongoing ticket we were discussing, in order to have a source of past conversations in one ticket page and etc.
In order for me to solve my issue with the ticket page not showing all the replies in a chronological order by date, I had to go into my cPanel and adjust the SQL database, by renumbering the ID numbers under the hesk_replies table for that ticket number. -- It seems to me that when topics get merged all the ID numbers get renumbered to a certain order (I guess?), and it seems that the ticket page fetches those ID numbers to set the reply order on the ticket page.
I wonder if it would be best if it should order them by the Date column instead of the ID column from the SQL table? I think that would be more accurate to avoid this mishap, but again, this is just speculation on my part, maybe there is a better fix for this?
Let me know if you have any additional questions or something for me to test and etc.