schon mal solch eine Fehlermeldung gehabt?
Ich sehe keine Tickets mehr im System - alles weg - alles leer.
Kann ich irgendwas retten / wiederherstellen?
Code: Select all
[Tue Apr 14 11:33:43 2015][Error][Kernel::System::TicketSearch::TicketSearch][1623] Table '.\otrs\ticket' is marked as crashed and last (automatic?) repair failed, SQL: 'SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN ticket_watcher tw ON st.id = tw.ticket_id WHERE 1=1 AND tw.user_id IN (94) AND archive_flag = 0 LIMIT 10000'
[Tue Apr 14 11:33:43 2015][Error][Kernel::System::TicketSearch::TicketSearch][1623] Table '.\otrs\ticket' is marked as crashed and last (automatic?) repair failed, SQL: 'SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN ticket_watcher tw ON st.id = tw.ticket_id INNER JOIN ticket_flag tf1 ON st.id = tf1.ticket_id WHERE 1=1 AND tw.user_id IN (94) AND tf1.ticket_key = 'Seen' AND tf1.ticket_value = '1' AND tf1.create_by = 94 AND archive_flag = 0 LIMIT 10000'
[Tue Apr 14 11:33:43 2015][Error][Kernel::System::TicketSearch::TicketSearch][1623] Table '.\otrs\ticket' is marked as crashed and last (automatic?) repair failed, SQL: 'SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN ticket_watcher tw ON st.id = tw.ticket_id WHERE 1=1 AND st.ticket_state_id IN ( 6 ) AND tw.user_id IN (94) AND st.ticket_state_id IN (6, 7, 8) AND st.until_time <= 1429003963 AND archive_flag = 0 LIMIT 10000'
[Tue Apr 14 11:33:43 2015][Error][Kernel::System::TicketSearch::TicketSearch][1623] Table '.\otrs\ticket' is marked as crashed and last (automatic?) repair failed, SQL: 'SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id WHERE 1=1 AND st.ticket_lock_id IN (2,3) AND st.user_id IN (94) AND archive_flag = 0 LIMIT 10000'
[Tue Apr 14 11:33:43 2015][Error][Kernel::System::TicketSearch::TicketSearch][1623] Table '.\otrs\ticket' is marked as crashed and last (automatic?) repair failed, SQL: 'SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN ticket_flag tf1 ON st.id = tf1.ticket_id WHERE 1=1 AND st.ticket_lock_id IN (2,3) AND st.user_id IN (94) AND tf1.ticket_key = 'Seen' AND tf1.ticket_value = '1' AND tf1.create_by = 94 AND archive_flag = 0 LIMIT 10000'
[Tue Apr 14 11:33:43 2015][Error][Kernel::System::TicketSearch::TicketSearch][1623] Table '.\otrs\ticket' is marked as crashed and last (automatic?) repair failed, SQL: 'SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id WHERE 1=1 AND st.ticket_state_id IN ( 6 ) AND st.ticket_lock_id IN (2,3) AND st.user_id IN (94) AND st.ticket_state_id IN (6, 7, 8) AND st.until_time <= 1429003963 AND archive_flag = 0 LIMIT 10000'
[Tue Apr 14 11:33:43 2015][Error][Kernel::System::Ticket::TicketGet][1065] Table '.\otrs\ticket' is marked as crashed and last (automatic?) repair failed, SQL: 'SELECT st.id, st.queue_id, sq.name, st.ticket_state_id, st.ticket_lock_id, sp.id, sp.name, st.create_time_unix, st.create_time, sq.group_id, st.tn, st.customer_id, st.customer_user_id, st.user_id, st.responsible_user_id, st.until_time, st.change_time, st.title, st.escalation_update_time, st.timeout, st.type_id, st.service_id, st.sla_id, st.escalation_response_time, st.escalation_solution_time, st.escalation_time, st.archive_flag, st.create_by, st.change_by FROM ticket st, ticket_priority sp, queue sq WHERE sp.id = st.ticket_priority_id AND sq.id = st.queue_id AND st.id = ? LIMIT 1'
[Tue Apr 14 11:33:43 2015][Error][Kernel::System::Ticket::TicketGet][1065] Table '.\otrs\ticket' is marked as crashed and last (automatic?) repair failed, SQL: 'SELECT st.id, st.queue_id, sq.name, st.ticket_state_id, st.ticket_lock_id, sp.id, sp.name, st.create_time_unix, st.create_time, sq.group_id, st.tn, st.customer_id, st.customer_user_id, st.user_id, st.responsible_user_id, st.until_time, st.change_time, st.title, st.escalation_update_time, st.timeout, st.type_id, st.service_id, st.sla_id, st.escalation_response_time, st.escalation_solution_time, st.escalation_time, st.archive_flag, st.create_by, st.change_by FROM ticket st, ticket_priority sp, queue sq WHERE sp.id = st.ticket_priority_id AND sq.id = st.queue_id AND st.id = ? LIMIT 1'
[Tue Apr 14 11:33:43 2015][Error][Kernel::System::Ticket::TicketGet][1065] Table '.\otrs\ticket' is marked as crashed and last (automatic?) repair failed, SQL: 'SELECT st.id, st.queue_id, sq.name, st.ticket_state_id, st.ticket_lock_id, sp.id, sp.name, st.create_time_unix, st.create_time, sq.group_id, st.tn, st.customer_id, st.customer_user_id, st.user_id, st.responsible_user_id, st.until_time, st.change_time, st.title, st.escalation_update_time, st.timeout, st.type_id, st.service_id, st.sla_id, st.escalation_response_time, st.escalation_solution_time, st.escalation_time, st.archive_flag, st.create_by, st.change_by FROM ticket st, ticket_priority sp, queue sq WHERE sp.id = st.ticket_priority_id AND sq.id = st.queue_id AND st.id = ? LIMIT 1'
[Tue Apr 14 11:33:43 2015][Error][Kernel::System::Queue::GetQueueGroupID][598] Need QueueID!