OTRS Ticket crashed\corrupt and needs to be repaired

Moderator: crythias

Post Reply
rashadreddy
Znuny newbie
Posts: 4
Joined: 23 Dec 2010, 15:40
Znuny Version: 2.93

OTRS Ticket crashed\corrupt and needs to be repaired

Post by rashadreddy »

Table './otrs/ticket' is marked as crashed and should be repaired, SQL: 'SELECT ar.id, ar.article_sender_type_id, ti.id, ar.create_by, ti.create_time_unix, ti.until_time, tst.name, ar.article_type_id FROM ticket ti, article ar, ticket_state ts, ticket_state_type tst WHERE ti.ticket_lock_id NOT IN ( 1, 3 ) AND ti.user_id = ? AND ar.ticket_id = ti.id AND ts.id = ti.ticket_state_id AND ts.type_id = tst.id ORDER BY ar.create_time DESC'
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS Ticket crashed\corrupt and needs to be repaired

Post by jojo »

Thats a mysql error. You shoul run the repair command of mysql (check mysql admin book for further information)
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
rashadreddy
Znuny newbie
Posts: 4
Joined: 23 Dec 2010, 15:40
Znuny Version: 2.93

Re: OTRS Ticket crashed\corrupt and needs to be repaired

Post by rashadreddy »

thank you. Where do i find that.?
vkandersv
Znuny newbie
Posts: 36
Joined: 07 Mar 2011, 18:32
Znuny Version: 3.0.6

Re: OTRS Ticket crashed\corrupt and needs to be repaired

Post by vkandersv »

rashadreddy wrote:thank you. Where do i find that.?
Without any promises... try this; be careful of course... you need some tool to connect to the database to be able to send sql-commands; if you are used to command line then "mysql"-command is good start

http://dev.mysql.com/doc/refman/5.0/en/check-table.html
http://dev.mysql.com/doc/refman/5.0/en/ ... table.html

if you are on a Windows-box you might try installing a gui-tool and just "right click on the table" and select repair.

http://dev.mysql.com/downloads/gui-tools/5.0.html

these are not the current gui for mysql but the only one i can understand.

if you are on a linux-box then perhaps you have webmin or some similar stuff that you can use to access the database?
--
ORTS 3.0.6, Linux, MySQL, ActiveDirectory integration for Customer.
MichaelR
Znuny expert
Posts: 250
Joined: 12 Oct 2010, 01:35
Znuny Version: 3.0.9
Company: LRS Health

Re: OTRS Ticket crashed\corrupt and needs to be repaired

Post by MichaelR »

install phpMyAdmin or something like that, easy!
OTRS: 3.0.9 & ITSM 3.0.4 - OS: Windows 7 - DB: MySQL - Heaps of random/useful hacks :)
[Major Code Changes]
ArticleFreeTime1-3
Ability to search ArticleFreeText
Post Reply