AgentTicketQueue and problem with Blank Tickets

Moderator: crythias

Locked
billias
Znuny newbie
Posts: 2
Joined: 27 Aug 2010, 12:19
Znuny Version: 2.4.4

AgentTicketQueue and problem with Blank Tickets

Post by billias »

After merging some tickets i discovered some blank tickets left behind.

I accessed SQL and discovered the Ticket_history table was crashed, and repaired it. Now how can i Fix the Blank ticket lines?

Check the image for more details.
ImageShack Image
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: AgentTicketQueue and problem with Blank Tickets

Post by crythias »

you could browse the db directly, such as with phpmyadmin...
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
billias
Znuny newbie
Posts: 2
Joined: 27 Aug 2010, 12:19
Znuny Version: 2.4.4

Re: AgentTicketQueue and problem with Blank Tickets

Post by billias »

And this listing is in Table?
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: AgentTicketQueue and problem with Blank Tickets

Post by crythias »

I believe it'll be ticket. I strongly suggest backing up (mysqldump?) the database before deleting entries. I disclaim any issues if you delete items that are critical to OTRS working. (That said, I doubt blank items are critical, but I don't want to be held responsible for my thoughts on the matter. :)
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Locked