1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

HT Remove Help Desk Tickets

Discussion in 'Plesk for Windows - 8.x and Older' started by Tikkune, Dec 21, 2005.

  1. Tikkune

    Tikkune Guest

    0
     
    Playing with the Help Desk, I created some test tickets that I'd now like deleted/removed. Am I missing the obvious? How does the Admin or Ticket Reporter delete/remove an unwanted ticket?
     
  2. Pavluha

    Pavluha Guest

    0
     
    Write to ticket and ask close it.
    There is second complicated way - to check all tables tts_* in MySQL PSA database and to delete mistake records.
     
  3. JackL

    JackL Guest

    0
     
    Follow these steps:

    1. Start->Run-cmd
    2. cd "%plesk_dir%\mysql\bin"
    3. mysql -uadmin -padmin-password -P8306 psa
    ------------------------------
    below are mysql commands
    _________________

    4. delete from tts_tickets;
    5. delete from tts_tickets_events;
    6. delete from tts_reporters;
    7. quit
    _________________
    Refresh page

    John S.G.
     
  4. Tikkune

    Tikkune Guest

    0
     
    JackL: thank you for the pointers! I had a whole lot of trouble getting access to MySQL via the command prompt. I kept getting Error 1045: (28000) Access denied for user 'admin'@'localhost' (using password: YES). This on a Windows Server 2003 machine, GoDaddy hosted. But figuring I could work around this using the table names you provided:

    4. delete from tts_tickets;
    5. delete from tts_tickets_events;
    6. delete from tts_reporters;

    ... and a necessary port number (-P8306) you mention, I decided to use Plesk's hook into phpMyAdmin to get at the MySQL tables GUI-style. From there, I could 'empty' the tables you listed, clearing *all* Help Desk Tickets.

    Exactly how I got there in Plesk for Windows 7.5:

    Server > Sevices: Databases > [MySQL] tab > Connection: Server name*: localhost : 8306 > Tools : MySQL RootWebAdmin > Database: PSA

    (Welcome to phpMyAdmin 2.6.0-pl3)

    Scrolling way down the list of tables, then one at a time clicking the trash can on the tables:

    tts_tickets
    tts_tickets_events
    tts_reporters

    "Do you really want to: TRUNCATE 'table_name'?"
    <OK>

    Back into the Help Desk, ALL the dummy/test tickets I created are gone, just as I wanted! But be sure you want to delete all tickets before choosing to 'empty' the tables.
     
Loading...