can´t see history ticket

DM_Julio Angulo

25 Sep 2012 25 Sep '12

11:04 p.m.

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

Attachments:

attachment.html (text/html — 6.6 KB)

Show replies by date

Carlos Andrés Gallego Arboleda

25 Sep 25 Sep

11:13 p.m.

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

...

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

DM_Julio Angulo

4 Oct 4 Oct

3:07 p.m.

New subject: [IE]:Re: can´t see history ticket

Hi all Thanks for the help, especially Mr. Gallegos by reponder so fast, I was doing this test and apparently resolved the issue, log messages returned to normal, but after running the mysqlcheck command I got another message and wanted to know how could affect me. \MySQL\bin>mysqlcheck --repair -u root otrs -p Enter password: otrs.agosto OK otrs.agosto1 OK otrs.agosto2 OK otrs.agosto3 OK otrs.article OK otrs.article_attachment OK otrs.article_flag OK otrs.article_plain OK otrs.article_search OK otrs.article_sender_type OK otrs.article_type OK otrs.auto_response OK otrs.auto_response_type OK otrs.calendar_event OK otrs.calendar_event_involved OK otrs.change_cab OK otrs.change_cip_allocate OK otrs.change_condition OK otrs.change_freekey OK otrs.change_freetext OK otrs.change_history OK otrs.change_history_type OK otrs.change_item OK otrs.change_notification OK otrs.change_notification_grps OK otrs.change_notification_rec OK otrs.change_state_machine OK otrs.change_template OK otrs.change_template_type OK otrs.change_wo_freekey OK otrs.change_wo_freetext OK otrs.change_workorder OK otrs.cip_allocate OK otrs.condition_action OK otrs.condition_attribute OK otrs.condition_expression OK otrs.condition_object OK otrs.condition_operator OK otrs.configitem OK otrs.configitem_counter OK otrs.configitem_definition OK otrs.configitem_history OK otrs.configitem_history_type OK otrs.configitem_version OK otrs.customer_company OK otrs.customer_preferences OK otrs.customer_user OK otrs.faq_attachment OK otrs.faq_category OK otrs.faq_category_group OK otrs.faq_history OK otrs.faq_item OK otrs.faq_language OK otrs.faq_log OK otrs.faq_state OK otrs.faq_state_type OK otrs.faq_voting OK otrs.follow_up_possible OK otrs.general_catalog OK otrs.general_catalog_preferences OK otrs.generic_agent_jobs OK otrs.group_customer_user OK otrs.group_role OK otrs.group_user OK otrs.groups OK otrs.imexport_format OK otrs.imexport_mapping OK otrs.imexport_mapping_format OK otrs.imexport_mapping_object OK otrs.imexport_object OK otrs.imexport_search OK otrs.imexport_template OK otrs.julio OK otrs.julio1 OK otrs.julio2 OK otrs.julio3 OK otrs.junio OK otrs.junio1 OK otrs.junio2 OK otrs.junio3 OK otrs.link_object OK otrs.link_relation OK otrs.link_state OK otrs.link_type OK otrs.mail_account OK otrs.notification_event OK otrs.notification_event_item OK otrs.notifications OK otrs.package_repository OK otrs.parent note : The storage engine for the table doesn't support repair otrs.personal_queues OK otrs.postmaster_filter OK otrs.process_id OK otrs.queue OK otrs.queue_auto_response OK otrs.queue_preferences OK otrs.queue_standard_response OK otrs.role_user OK otrs.roles OK otrs.salutation OK otrs.search_profile OK otrs.service OK otrs.service_customer_user OK otrs.service_preferences OK otrs.service_sla OK otrs.sessions OK otrs.setiembre OK otrs.signature OK otrs.sla OK otrs.sla_preferences OK otrs.standard_attachment OK otrs.standard_response OK otrs.standard_response_attachment OK otrs.support_bench_test OK otrs.system_address OK otrs.theme OK otrs.ticket OK otrs.ticket_history OK otrs.ticket_history_type OK otrs.ticket_index OK otrs.ticket_lock_index OK otrs.ticket_lock_type OK otrs.ticket_loop_protection OK otrs.ticket_priority OK otrs.ticket_state OK otrs.ticket_state_type OK otrs.ticket_type OK otrs.ticket_watcher OK otrs.time_accounting OK otrs.user_preferences OK otrs.users OK otrs.valid OK otrs.virtual_fs OK otrs.virtual_fs_db OK otrs.virtual_fs_preferences OK otrs.web_upload_cache OK otrs.xml_storage OK \MySQL\bin> Julio Angulo Telf.: +51 1 4150300 anexo: 1468 Movil: +51 997066155 De: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] En nombre de Carlos Andrés Gallego Arboleda Enviado el: Martes, 25 de Septiembre de 2012 06:13 p.m. Para: User questions and discussions about OTRS. Asunto: [IE]:Re: [otrs]can´t see history ticket 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 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 tel:%2B51%201%204150300%20anexo%3A%201468 Movil: +51 997066155 tel:%2B51%20997066155 --------------------------------------------------------------------- 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

Carlos Andrés Gallego Arboleda

3:13 p.m.

New subject: [IE]:Re: can´t see history ticket

Hi Julio, This message say the table note is in other engine like INODB, but if Ticket_history appear ok in the output the command has repair. Check your log again. Regards. 2012/10/4 DM_Julio Angulo

...

Hi all****

** **

Thanks for the help, especially Mr. Gallegos by reponder so fast, I was doing this test and apparently resolved the issue, log messages returned to normal, but after running the mysqlcheck command I got another message and wanted to know how could affect me.****

** **

** **

\MySQL\bin>mysqlcheck --repair -u root otrs -p****

Enter password:****

otrs.agosto OK****

otrs.agosto1 OK****

otrs.agosto2 OK****

otrs.agosto3 OK****

otrs.article OK****

otrs.article_attachment OK****

otrs.article_flag OK****

otrs.article_plain OK****

otrs.article_search OK****

otrs.article_sender_type OK****

otrs.article_type OK****

otrs.auto_response OK****

otrs.auto_response_type OK****

otrs.calendar_event OK****

otrs.calendar_event_involved OK****

otrs.change_cab OK****

otrs.change_cip_allocate OK****

otrs.change_condition OK****

otrs.change_freekey OK****

otrs.change_freetext OK****

otrs.change_history OK****

otrs.change_history_type OK****

otrs.change_item OK****

otrs.change_notification OK****

otrs.change_notification_grps OK****

otrs.change_notification_rec OK****

otrs.change_state_machine OK****

otrs.change_template OK****

otrs.change_template_type OK****

otrs.change_wo_freekey OK****

otrs.change_wo_freetext OK****

otrs.change_workorder OK****

otrs.cip_allocate OK****

otrs.condition_action OK****

otrs.condition_attribute OK****

otrs.condition_expression OK****

otrs.condition_object OK****

otrs.condition_operator OK****

otrs.configitem OK****

otrs.configitem_counter OK****

otrs.configitem_definition OK****

otrs.configitem_history OK****

otrs.configitem_history_type OK****

otrs.configitem_version OK****

otrs.customer_company OK****

otrs.customer_preferences OK****

otrs.customer_user OK****

otrs.faq_attachment OK****

otrs.faq_category OK****

otrs.faq_category_group OK****

otrs.faq_history OK****

otrs.faq_item OK****

otrs.faq_language OK****

otrs.faq_log OK****

otrs.faq_state OK****

otrs.faq_state_type OK****

otrs.faq_voting OK****

otrs.follow_up_possible OK****

otrs.general_catalog OK****

otrs.general_catalog_preferences OK****

otrs.generic_agent_jobs OK****

otrs.group_customer_user OK****

otrs.group_role OK****

otrs.group_user OK****

otrs.groups OK****

otrs.imexport_format OK****

otrs.imexport_mapping OK****

otrs.imexport_mapping_format OK****

otrs.imexport_mapping_object OK****

otrs.imexport_object OK****

otrs.imexport_search OK****

otrs.imexport_template OK****

otrs.julio OK****

otrs.julio1 OK****

otrs.julio2 OK****

otrs.julio3 OK****

otrs.junio OK****

otrs.junio1 OK****

otrs.junio2 OK****

otrs.junio3 OK****

otrs.link_object OK****

otrs.link_relation OK****

otrs.link_state OK****

otrs.link_type OK****

otrs.mail_account OK****

otrs.notification_event OK****

otrs.notification_event_item OK****

otrs.notifications OK****

otrs.package_repository OK****

** **

otrs.parent****

*note : The storage engine for the table doesn't support repair***

** **

otrs.personal_queues OK****

otrs.postmaster_filter OK****

otrs.process_id OK****

otrs.queue OK****

otrs.queue_auto_response OK****

otrs.queue_preferences OK****

otrs.queue_standard_response OK****

otrs.role_user OK****

otrs.roles OK****

otrs.salutation OK****

otrs.search_profile OK****

otrs.service OK****

otrs.service_customer_user OK****

otrs.service_preferences OK****

otrs.service_sla OK****

otrs.sessions OK****

otrs.setiembre OK****

otrs.signature OK****

otrs.sla OK****

otrs.sla_preferences OK****

otrs.standard_attachment OK****

otrs.standard_response OK****

otrs.standard_response_attachment OK****

otrs.support_bench_test OK****

otrs.system_address OK****

otrs.theme OK****

otrs.ticket OK****

otrs.ticket_history OK****

otrs.ticket_history_type OK****

otrs.ticket_index OK****

otrs.ticket_lock_index OK****

otrs.ticket_lock_type OK****

otrs.ticket_loop_protection OK****

otrs.ticket_priority OK****

otrs.ticket_state OK****

otrs.ticket_state_type OK****

otrs.ticket_type OK****

otrs.ticket_watcher OK****

otrs.time_accounting OK****

otrs.user_preferences OK****

otrs.users OK****

otrs.valid OK****

otrs.virtual_fs OK****

otrs.virtual_fs_db OK****

otrs.virtual_fs_preferences OK****

otrs.web_upload_cache OK****

otrs.xml_storage OK****

** **

\MySQL\bin>****

** **

** **

** **

Julio Angulo Telf.: +51 1 4150300 anexo: 1468 Movil: +51 997066155****

** **

*De:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *En nombre de *Carlos Andrés Gallego Arboleda *Enviado el:* Martes, 25 de Septiembre de 2012 06:13 p.m. *Para:* User questions and discussions about OTRS. *Asunto:* [IE]:Re: [otrs]can´t see history ticket****

** **

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 ****

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****

** **

Gerald Young

3:16 p.m.

New subject: [IE]:Re: can´t see history ticket

http://stackoverflow.com/questions/226172/how-do-i-repair-an-innodb-table (the table is innodb and doesn't support the Repair option) It wasn't evidenced as problematic, so don't worry about it unless you know otherwise. Backup/mysqldump is a good idea before doing any repair of data. In my experience, you may "fix" the crash, but truncate data at the crash fix. automysqlbackup is helpful, as well. On Thu, Oct 4, 2012 at 11:07 AM, DM_Julio Angulo wrote:

...

Hi all****

** **

Thanks for the help, especially Mr. Gallegos by reponder so fast, I was doing this test and apparently resolved the issue, log messages returned to normal, but after running the mysqlcheck command I got another message and wanted to know how could affect me.****

** **

** **

\MySQL\bin>mysqlcheck --repair -u root otrs -p****

Enter password:****

otrs.agosto OK****

otrs.agosto1 OK****

otrs.agosto2 OK****

otrs.agosto3 OK****

otrs.article OK****

otrs.article_attachment OK****

otrs.article_flag OK****

otrs.article_plain OK****

otrs.article_search OK****

otrs.article_sender_type OK****

otrs.article_type OK****

otrs.auto_response OK****

otrs.auto_response_type OK****

otrs.calendar_event OK****

otrs.calendar_event_involved OK****

otrs.change_cab OK****

otrs.change_cip_allocate OK****

otrs.change_condition OK****

otrs.change_freekey OK****

otrs.change_freetext OK****

otrs.change_history OK****

otrs.change_history_type OK****

otrs.change_item OK****

otrs.change_notification OK****

otrs.change_notification_grps OK****

otrs.change_notification_rec OK****

otrs.change_state_machine OK****

otrs.change_template OK****

otrs.change_template_type OK****

otrs.change_wo_freekey OK****

otrs.change_wo_freetext OK****

otrs.change_workorder OK****

otrs.cip_allocate OK****

otrs.condition_action OK****

otrs.condition_attribute OK****

otrs.condition_expression OK****

otrs.condition_object OK****

otrs.condition_operator OK****

otrs.configitem OK****

otrs.configitem_counter OK****

otrs.configitem_definition OK****

otrs.configitem_history OK****

otrs.configitem_history_type OK****

otrs.configitem_version OK****

otrs.customer_company OK****

otrs.customer_preferences OK****

otrs.customer_user OK****

otrs.faq_attachment OK****

otrs.faq_category OK****

otrs.faq_category_group OK****

otrs.faq_history OK****

otrs.faq_item OK****

otrs.faq_language OK****

otrs.faq_log OK****

otrs.faq_state OK****

otrs.faq_state_type OK****

otrs.faq_voting OK****

otrs.follow_up_possible OK****

otrs.general_catalog OK****

otrs.general_catalog_preferences OK****

otrs.generic_agent_jobs OK****

otrs.group_customer_user OK****

otrs.group_role OK****

otrs.group_user OK****

otrs.groups OK****

otrs.imexport_format OK****

otrs.imexport_mapping OK****

otrs.imexport_mapping_format OK****

otrs.imexport_mapping_object OK****

otrs.imexport_object OK****

otrs.imexport_search OK****

otrs.imexport_template OK****

otrs.julio OK****

otrs.julio1 OK****

otrs.julio2 OK****

otrs.julio3 OK****

otrs.junio OK****

otrs.junio1 OK****

otrs.junio2 OK****

otrs.junio3 OK****

otrs.link_object OK****

otrs.link_relation OK****

otrs.link_state OK****

otrs.link_type OK****

otrs.mail_account OK****

otrs.notification_event OK****

otrs.notification_event_item OK****

otrs.notifications OK****

otrs.package_repository OK****

** **

otrs.parent****

*note : The storage engine for the table doesn't support repair***

** **

otrs.personal_queues OK****

otrs.postmaster_filter OK****

otrs.process_id OK****

otrs.queue OK****

otrs.queue_auto_response OK****

otrs.queue_preferences OK****

otrs.queue_standard_response OK****

otrs.role_user OK****

otrs.roles OK****

otrs.salutation OK****

otrs.search_profile OK****

otrs.service OK****

otrs.service_customer_user OK****

otrs.service_preferences OK****

otrs.service_sla OK****

otrs.sessions OK****

otrs.setiembre OK****

otrs.signature OK****

otrs.sla OK****

otrs.sla_preferences OK****

otrs.standard_attachment OK****

otrs.standard_response OK****

otrs.standard_response_attachment OK****

otrs.support_bench_test OK****

otrs.system_address OK****

otrs.theme OK****

otrs.ticket OK****

otrs.ticket_history OK****

otrs.ticket_history_type OK****

otrs.ticket_index OK****

otrs.ticket_lock_index OK****

otrs.ticket_lock_type OK****

otrs.ticket_loop_protection OK****

otrs.ticket_priority OK****

otrs.ticket_state OK****

otrs.ticket_state_type OK****

otrs.ticket_type OK****

otrs.ticket_watcher OK****

otrs.time_accounting OK****

otrs.user_preferences OK****

otrs.users OK****

otrs.valid OK****

otrs.virtual_fs OK****

otrs.virtual_fs_db OK****

otrs.virtual_fs_preferences OK****

otrs.web_upload_cache OK****

otrs.xml_storage OK****

** **

\MySQL\bin>****

** **

** **

** **

Julio Angulo Telf.: +51 1 4150300 anexo: 1468 Movil: +51 997066155****

** **

*De:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *En nombre de *Carlos Andrés Gallego Arboleda *Enviado el:* Martes, 25 de Septiembre de 2012 06:13 p.m. *Para:* User questions and discussions about OTRS. *Asunto:* [IE]:Re: [otrs]can´t see history ticket****

** **

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 ****

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

4670

Age (days ago)

4679

Last active (days ago)

List overview

Download

4 comments

3 participants

participants (3)

Carlos Andrés Gallego Arboleda
DM_Julio Angulo
Gerald Young