Error upgrading from 3.2.10 to 3.3.1

[fchip]

Following the recommended steps I've got this error:

Ideas?

--
ERROR: OTRS-CGI-10 Perl: 5.10.1 OS: linux Time: Mon Nov 18 15:57:13 2013

Message: Unknown column 'a_message_id_md5' in 'field list', SQL: 'INSERT INTO article (ticket_id, article_type_id, article_sender_type_id, a_from, a_reply_to, a_to, a_cc, a_subject, a_message_id, a_message_id_md5, a_in_reply_to, a_references, a_body, a_content_type, content_path, valid_id, incoming_time, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
'2013-11-18 15:57:13'
, ?,
'2013-11-18 15:57:13'
, ?)'

RemoteAddress: xx.xx.xx.xx
RequestURI: /otrs/customer.pl

Traceback (17668):
Module: Kernel::System::Ticket::Article::ArticleCreate (OTRS 3.3.1) Line: 264
Module: Kernel::Modules::CustomerTicketMessage::Run (OTRS 3.3.1) Line: 556
Module: Kernel::System::Web::InterfaceCustomer::Run (OTRS 3.3.1) Line: 992
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_customer_2epl::handler (unknown version) Line: 41
Module: (eval) (v1.99) Line: 204
Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31

[blastik]

I solved this by running scripts/DBUpdate-to-3.3.pl

[tanjix]

Ich habe das selbe bzuw. zumindestz ein ähnliches Problem. Beim Upgrade von 3.2.10 auf 3.3.1 passiert bei mir beim Ausführen des DBUpdate-to-3.3.pl:

Migration started...

Step 1 of 13: Refresh configuration cache...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAAuto.pm line 7.
Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAuto.pm line 7.
done.

Step 2 of 13: Check framework version... done.

DBD::mysql::db do failed: Unknown column 'a_message_id_md5' in 'field list' at /opt/otrs/Kernel/System/DB.pm line 499.
ERROR: OTRS-DBUpdate-to-3.3-10 Perl: 5.14.2 OS: linux Time: Mon Nov 25 15:05:17 2013

Message: Unknown column 'a_message_id_md5' in 'field list', SQL: '
UPDATE article
SET a_message_id_md5 = MD5(a_message_id)
WHERE a_message_id IS NOT NULL
'

Traceback (15882):
Module: main::_GenerateMessageIDMD5 (unknown version) Line: 588
Module: scripts/DBUpdate-to-3.3.pl (unknown version) Line: 96

Step 3 of 13: Generate MessageID md5sums... done.

Step 4 of 13: Migrate old settings... done.

Step 5 of 13: Migrate OTRSExternalTicketNumberRecognition... done.

Step 6 of 13: Checking Standard Template table columns...
Check if 'template_type' columns exists.
'template_type' column not found, create it.
ALTER TABLE standard_template ADD template_type VARCHAR (100) NULL
DBD::mysql::db do failed: Table 'otrs.standard_template' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 499.
ERROR: OTRS-DBUpdate-to-3.3-10 Perl: 5.14.2 OS: linux Time: Mon Nov 25 15:05:18 2013

Message: Table 'otrs.standard_template' doesn't exist, SQL: 'ALTER TABLE standard_template ADD template_type VARCHAR (100) NULL'

Traceback (15882):
Module: main::_AddTemplateTypeColumn (unknown version) Line: 484
Module: scripts/DBUpdate-to-3.3.pl (unknown version) Line: 123

ERROR: OTRS-DBUpdate-to-3.3-10 Perl: 5.14.2 OS: linux Time: Mon Nov 25 15:05:18 2013

Message: Error during execution of 'ALTER TABLE standard_template ADD template_type VARCHAR (100) NULL'!

Traceback (15882):
Module: main::_AddTemplateTypeColumn (unknown version) Line: 486
Module: scripts/DBUpdate-to-3.3.pl (unknown version) Line: 123

Died at scripts/DBUpdate-to-3.3.pl line 123.

Weiß hier jemand Rat?


Danke und VG,

tanjix

[rolandch]

You first Need to run the upgrade script like
mysql -uotrs -pxxx otrs <C:\OTRS\OTRS\scripts\DBUpdate-to-3.3.mysql.sql
before you run
perl C:\OTRS\OTRS\scripts\DBUpdate-to-3.3.pl

[ismael]

Executing the DBUpdate-to-3.3.pl perl script as blastik suggested worked for me. Thank you!

[florifreeman]

Hi there,

i got the same problem, but the database is local on the same machine. Any ideas how to solve this ? Really annoying error btw.

With regards,

Florian

[ptay]

You first Need to run the upgrade script like
mysql -uotrs -pxxx otrs <C:\OTRS\OTRS\scripts\DBUpdate-to-3.3.mysql.sql
before you run
perl C:\OTRS\OTRS\scripts\DBUpdate-to-3.3.pl

Your suggestion worked! Thank you for posting. The 3.3 admin manual skipped this step. It should be under Section 4. Upgrading the OTRS Framework number 9 Schema update.

I got same error following the manual then did what rolandch posted:

Code: Select all

otrs@~/scripts$ mysql -uotrs -pOtrsMysqlPasswordHere otrs </opt/otrs/scriptsDBUpdate-to-3.3.mysql.sql
...output cut out...
otrs@~/scripts$ ./DBUpdate-to-3.3.pl