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
AgentTicketQueue and problem with Blank Tickets
Moderator: 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
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
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
Re: AgentTicketQueue and problem with Blank Tickets
And this listing is in Table?
-
- 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
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
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