Migrating from OTRS 1 to OTRS2

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

On 9/20/05, Braun Brelin
Is there a preferred method for migrating the MySQL db to the new instance of OTRS?
Yes, it is preferred that you read the UPGRADING file in the OTRS package, which was specifically written to assist with upgrading from 1.3 to 2.x (if you're upgrading from 1.2 or earlier there will be other steps required). It includes: ===== *) Update the database changes with: MySQL: cat $OTRS_HOME/scripts/DBUpdate-to-2.0.mysql.sql | mysql -p -f -u root otrs PostgreSQL: cat $OTRS_HOME/scripts/DBUpdate-to-2.0.postgresql.sql | psql otrs ===== Change the mysql command line options as required for your setup. Bryan
participants (2)
-
Braun Brelin
-
Bryan Fullerton