Jump to content

Changing Ticket Status Title - Loses Tickets

Recommended Posts

I was going to change some the default statuses myself, but will hold off on that for now given what you've said. If statuses are referenced by the 'title' column as opposed to 'id', that can and will lead to major issues; as suggested by you.


Having taken a quick look at the database, I see that 'tbltickets.status' is the textual title of the status, not the statuses ID. I would suggest that the 'tbltickets.status' be changed to reference the statuses ID number and whenever the status title needs to be known (i.e. when view a ticket), can be accomplished with a JOIN of the two tables (i.e. 'tbltickets' and 'tblticketstatuses'). At the very least, modify the code of configticketstatuses.php to update the 'tbltickets" (and any other tables which may reference the status) with the statuses new title.

Link to comment
Share on other sites

There are many other things that are refferenced with text, like Ticket Ratings (the admin column), and this one is a royal pain, too. try looking at your employee ticket rating.


Now ask one of your employees (Female that just got married) to change her name. Check out the ratings 5 days later.


ooops , you now have an extra employee in the graph.


Now imagine everyone decides to add their second last name (here in spain we have 2 last names),


oooops you just doubled your ratings graph size.


I think we need to start using ids for some areas.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated