OTRS Ticket crashed\corrupt and needs to be repaired
Moderator: crythias
-
- Znuny newbie
- Posts: 4
- Joined: 23 Dec 2010, 15:40
- Znuny Version: 2.93
OTRS Ticket crashed\corrupt and needs to be repaired
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'
Re: OTRS Ticket crashed\corrupt and needs to be repaired
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 4
- Joined: 23 Dec 2010, 15:40
- Znuny Version: 2.93
Re: OTRS Ticket crashed\corrupt and needs to be repaired
thank you. Where do i find that.?
Re: OTRS Ticket crashed\corrupt and needs to be repaired
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 startrashadreddy wrote:thank you. Where do i find that.?
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.
ORTS 3.0.6, Linux, MySQL, ActiveDirectory integration for Customer.
-
- 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
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
[Major Code Changes]
ArticleFreeTime1-3
Ability to search ArticleFreeText