
Hello all, I'm trying to do a migration from OTRS 1.x to 2.x. My question is: Has the database schema changed? I'm getting errors like the following: Sep 21 06:52:49 localhost OTRS-CGI-10[2050]: [Error][Kernel::System::Ticket::Article::ArticleGet][Line:964]: Unknown column 'st.freekey3' in 'field list', SQL: 'SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject, sa.a_reply_to, sa. a_message_id, sa.a_body, st.create_time_unix, st.ticket_state_id, st.queue_id, sa.create_time, sa.a_content_type, sa.create_by, st.tn http://st.tn, article_sender_type_id, st.customer_id, st.until_time, st.ticket_priority_id, st.customer_user_id, st.user_id, su.login, sa.article_type_id, sa.a_freekey1, sa.a_freetext1, sa.a_freekey2, sa.a_freetext2, sa.a_freekey3, sa.a_freetext3, st.ticket_answered, sa.incoming_time, sa.id http://sa.id, st.freekey1, st.freetext1, st.freekey2, st.freetext2, st.freekey3, st.freetext3, st.freekey4, st.freetext4, st.freekey5, st.freetext5, st.freekey6, st.freetext6, st.freekey7, st.freetext7, st.freekey8, st.freetext8, st.ticket_lock_id, st.title, st.escalation_start_time, st.freetime1 , st.freetime2 FROM article sa, ticket st, system_user su where sa.idhttp://sa.id= 137072 AND sa. Is there a preferred method for migrating the MySQL db to the new instance of OTRS? THanks, Braun Brelin