I am experiencing an issue with ticket pagination in osTicket. When searching for tickets, the pagination incorrectly displays:

"Showing 1 - 9 of about 9"

However, there are 14 tickets in the search results. This means the pagination count is not reflect the actual number of tickets.

see this screenshot
total number of open ticket for user is 14 but its show only 9

system info

why did this happen can you please let me know and how I can fix this?

    narendraidrive

    1. Looks like you are using a modified version as we don’t have that specific error message.
    2. Looks like you are not all the way up to date. I would suggest upgrading to v1.18.2 and retesting.

    Cheers.

    ChadPhilip

    What is the queue's configuration? I cannot replicate this nor have I received any other reports than you two. Do you have any modifications? Do you have any referred Tickets, assigned tickets, children tickets, etc. related to Tickets in this queue?

    Cheers.

    We have only ever used the default settings for Queues:

    Also, no modifications of any kind have been made to our installation. It's basically a vanilla installation aside from the plugins we have installed.

      ChadPhilip

      Okay, during off hours login to the help desk, go to the queue, go to the include/class.orm.php file on line 3481, make a new line under it, add var_dump($sql);, save the file, go to the queue, reload the page, and find the query for the queue. Copy the whole query and run it in MySQL/MariaDB and compare that with what you see in the UI. Make sure you remove the change as fast as possible so no one has issues. Let me know the outcome.

      Cheers.

      21 days later

      Here's the change that we made:

      And this was the resulting output:

        Hello,
        We encountered the same issue after upgrading to v1.18.2. Adding $agent as an argument helped resolve the problem. It seems that we are not using any custom functionality. Will this patch be included in the next release?

          Write a Reply...