OTRS Ticket crashed\corrupt and needs to be repaired

Moderator: crythias

OTRS Ticket crashed\corrupt and needs to be repaired

Postby rashadreddy » 03 Apr 2011, 13:03

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'
rashadreddy
OTRS newbie
 
Posts: 4
Joined: 23 Dec 2010, 15:40

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

Postby jojo » 03 Apr 2011, 13:11

Thats a mysql error. You shoul run the repair command of mysql (check mysql admin book for further information)
"Produktiv": OTRS: 3.3.x, OTRS::ITSM 3.3, SIRIOS 2.3
"Testing": OTRS: 4 git
OS: Ubuntu
Apache2/MySQL 5+

Niemals die Defaults.pm ändern! :: Blog :: OTRS iPhone App
Professioneller Support, Consulting und Entwicklung: http://www.otrs.com :: Bei weiteren Fragen: enjoy@otrs.com hilft gerne
jojo
Moderator
 
Posts: 11280
Joined: 26 Jan 2007, 14:50

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

Postby rashadreddy » 03 Apr 2011, 13:23

thank you. Where do i find that.?
rashadreddy
OTRS newbie
 
Posts: 4
Joined: 23 Dec 2010, 15:40

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

Postby vkandersv » 03 Apr 2011, 13:35

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.
vkandersv
OTRS newbie
 
Posts: 36
Joined: 07 Mar 2011, 18:32

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

Postby MichaelR » 07 Apr 2011, 01:22

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
MichaelR
OTRS superhero
 
Posts: 250
Joined: 12 Oct 2010, 01:35


Return to Help

Who is online

Users browsing this forum: Bing [Bot] and 2 guests