Edit Category ID?

[Ring-A-Nerd]

Script URL: http://ringanerd.co.za/Helpdesk
Version of script: 2.4.2
Hosting company: Hetzner

Hi there guys! Can someone tell me if it is possible to edit the ID of a category, and what implications it might cause, such as previous tickets kept as records?

The reason I want to do this is because one of the most important categories (and frequently used) is now at the bottom of the display (when viewed by categories).

I know I could achieve this by renaming ID 1 to what I want the first to be, but that means shifting some several hundred tickets around, which could prove to take much longer than a possible fix that someone might have?

Thanks in advance!

[dr_patso]

do you mean the ticket list when grouped by category you want it showing up first?

Do you currently have a category with the ID of 1? if so it would be very easy to move all tickets in X category to another.. I don't know about modifying the ID of a category but it may be okay...

This really is what you need to do once you figure out where the categories need to go.

use phpmyadmin, or mysql.exe

UPDATE hesk_tickets SET category= 'X' WHERE category = 'Y'



X is the category you are keeping

Y is the category you want to consilidate into X....



an example of it working


notes:category 11 = General Support
category 17 = Meetings

We are changing all tickets under category of Meetings(17) to be under General Support(11)

UPDATE hesk_tickets SET category= '11' WHERE category = '17'