When I search for some specific tickets, then the amount of tickets found is mostly wrong and also when I switch between pages there is empty pages.

Example:
I search for "Test", it shows me at the bottom right that there is about 4464 Tickets.
But now if I jump to page 10, it already shows me the last tickets from the current date and at the bottom it says "showing 451 - 500" even so this page is only listing 18 tickets and not 50....

I also had the problem with the amount showing 500 fixed, but that was already solved here: https://forum.osticket.com/d/93557-pagination-inaccuracies/3

Any idea what could be the reason that the amount is shown wrong?


I just activated the LOG for all errors, could it be because sometimes I receive an "DB Error #1064" ?

See Screenshot.

I have changed from a older Debian running MySQL to a new Debian 9 running MariaDB, could this be some problem?

5 days later

DB Error #1064 was caused by some old saves searches, it was solved by deleting the entrees from the database. But the main issue why I opened the ticket is still now solved. Any idea what could be the reason? Or something that I can check?

Write a Reply...