HI If you database is on MySQL you can log as root and excecute this command
mysqlcheck --repair -u USER otrs -p Use your password and wait. 2012/9/25 DM_Julio Angulo <[email protected]> > hi guys, checking the log I find this message:**** > > ** ** > > ** ** > > [Tue Sep 25 13:05:01 > 2012][Error][Kernel::System::Ticket::HistoryAdd][6265] Table > '.\otrs\ticket_history' is marked as crashed and should be repaired, SQL: > 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, > queue_id, owner_id, priority_id, state_id, type_id, valid_id, > create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)'**** > > [Tue Sep 25 13:05:01 > 2012][Error][Kernel::System::Ticket::HistoryAdd][6265] Table > '.\otrs\ticket_history' is marked as crashed and should be repaired, SQL: > 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, > queue_id, owner_id, priority_id, state_id, type_id, valid_id, > create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)'**** > > [Tue Sep 25 13:05:01 > 2012][Error][Kernel::System::Ticket::HistoryAdd][6265] Table > '.\otrs\ticket_history' is marked as crashed and should be repaired, SQL: > 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, > queue_id, owner_id, priority_id, state_id, type_id, valid_id, > create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)'**** > > [Tue Sep 25 13:05:01 > 2012][Error][Kernel::System::Ticket::HistoryAdd][6265] Table > '.\otrs\ticket_history' is marked as crashed and should be repaired, SQL: > 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, > queue_id, owner_id, priority_id, state_id, type_id, valid_id, > create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)'**** > > [Tue Sep 25 13:05:01 > 2012][Error][Kernel::System::Ticket::HistoryAdd][6265] Table > '.\otrs\ticket_history' is marked as crashed and should be repaired, SQL: > 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, > queue_id, owner_id, priority_id, state_id, type_id, valid_id, > create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)'**** > > [Tue Sep 25 13:05:01 > 2012][Error][Kernel::System::Ticket::HistoryAdd][6265] Table > '.\otrs\ticket_history' is marked as crashed and should be repaired, SQL: > 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, > queue_id, owner_id, priority_id, state_id, type_id, valid_id, > create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)'**** > > [Tue Sep 25 13:05:02 > 2012][Error][Kernel::System::Ticket::HistoryAdd][6265] Table > '.\otrs\ticket_history' is marked as crashed and should be repaired, SQL: > 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, > queue_id, owner_id, priority_id, state_id, type_id, valid_id, > create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)'**** > > ** ** > > ** ** > > Now when I see the history of the ticket not displayed**** > > I do not understand the message, any help**** > > thanks**** > > ** ** > > Julio Angulo > Telf.: +51 1 4150300 anexo: 1468 > Movil: +51 997066155**** > > ** ** > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs >
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
