osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
ticket_id and ticketID do not always correspond - after migration
First,thanks for this great software!
We are using version OST 1.7 on CentOS 6.5 with apache 2.2 and mysql distr 5.1.
This last weekend I migrated our existing OST install to a new server. At the time of the migration there were to versions of the tables in the same database. I was unaware that the table prefix didn't necessarily guarantee that the data would only be written to the specified prefix tables, it seems the first tables in alpha/numeric order are used. So I quickly deleted the extra tables.
However, since the migration there have been a few email notifications of tickets that have incorrect ticket_id values.
Following these links either go to a non-existent ticket or an older unrelated ticket that is closed.
I believe I've broken the order between the random ticketID and the next ticket_id.
I realize that this information is a bit abstract, I've not provided any logs(because the software appears to be working normally).
But I'm hoping that someone in the community has seen this kind of issue before and can offer some ideas on how I can resync these fields or at least proceed with further troubleshooting.