Hello all,<br>
<br>
I'm trying to do a migration from OTRS 1.x to 2.x.&nbsp; My question
is:&nbsp; Has the database schema changed?&nbsp; I'm getting errors
like the following: <br>
<br>
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,&nbsp; sa.a_reply_to, sa.
a_message_id, sa.a_body,&nbsp; st.create_time_unix, st.ticket_state_id,
st.queue_id, sa.create_time,&nbsp; sa.a_content_type, sa.create_by,
<a href="http://st.tn">st.tn</a>, article_sender_type_id, st.customer_id,&nbsp; st.until_time,
st.ticket_priority_id, st.customer_user_id, st.user_id,&nbsp; su.login,
sa.article_type_id,&nbsp; sa.a_freekey1, sa.a_freetext1, sa.a_freekey2,
sa.a_freetext2,&nbsp; sa.a_freekey3, sa.a_freetext3,
st.ticket_answered,&nbsp; sa.incoming_time, <a href="http://sa.id">sa.id</a>, 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,&nbsp; st.ticket_lock_id, st.title,
st.escalation_start_time,&nbsp; st.freetime1 , st.freetime2&nbsp;
FROM&nbsp; article sa, ticket st,&nbsp; system_user su&nbsp;
where&nbsp; <a href="http://sa.id">sa.id</a> = 137072 AND&nbsp; sa.<br>
<br>
Is there a preferred method for migrating the MySQL db to the new instance of OTRS?<br>
<br>
THanks,<br>
<br>
Braun Brelin<br>
<br>