Wednesday, April 18, 2012

Remove recurrence tickets in Kayako

The best way to remove them is to just login to phpmyadmin or whatever mysql interface you have, search for swticketrecurrences and delete entries you want to remove


really you could login via ssh, if you arent experianced with using SSH or MySQL via shell be careful! or make a backup (mysqldump -u root -p[password] [database] > database_date.sql)

    # mysql
    show databases;
    find the kayako_database(whatever name you have setup)
    use kayako_database ^^
    select * from swticketrecurrences;

this way you can see all the tickets /id numbers for deletion

DELETE FROM swticketrecurrences
WHERE ticketrecurrenceid = the id of the ticket you want to stop

essentially looking at the table structure you can update the ticket this way, which doesn't look too hard to do(but its prob easier to just remove it and recreate if needed) 


No comments:

Post a Comment