Upgrading from 3.1.10 to 3.2.1 - Database migration fails

[52nEHJ]

I am trying to upgrade our OTRS installation from version 3.1.10 to 3.2.1

I followed the UPGRADING documentation and could not go on after 9) Apply the database changes because of the following error

Code: Select all

Server:/opt/otrs-3.2.1# scripts/DBUpdate-to-3.2.pl

Migration started...

Step 1 of 9: Refresh configuration cache...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
done.

Not framework version required at scripts/DBUpdate-to-3.2.pl line 217.
Step 2 of 9: Check framework version... 

The previous step gave me the following errors:

Code: Select all

Server:/opt/otrs-3.2.1# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql -p -f -u root otrs2
Enter password:
ERROR 1091 (42000) at line 7: Can't DROP 'group_read'; check that column/key exists
ERROR 1091 (42000) at line 11: Can't DROP 'group_write'; check that column/key exists
ERROR 1091 (42000) at line 15: Can't DROP 'other_read'; check that column/key exists
ERROR 1091 (42000) at line 19: Can't DROP 'other_write'; check that column/key exists
ERROR 1091 (42000) at line 20: Can't DROP 'ticket_answered'; check that column/key exists
ERROR 1091 (42000) at line 24: Can't DROP 'ticket_answered'; check that column/key exists
ERROR 1091 (42000) at line 25: Can't DROP 'article_flag_create_by'; check that column/key exists
ERROR 1091 (42000) at line 26: Can't DROP 'article_flag_article_id_article_key'; check that column/key exists
ERROR 1091 (42000) at line 31: Can't DROP 'group_id'; check that column/key exists
ERROR 1050 (42S01) at line 36: Table 'pm_process' already exists
ERROR 1050 (42S01) at line 53: Table 'pm_activity' already exists
ERROR 1050 (42S01) at line 68: Table 'pm_activity_dialog' already exists
ERROR 1050 (42S01) at line 83: Table 'pm_transition' already exists
ERROR 1050 (42S01) at line 98: Table 'pm_transition_action' already exists
ERROR 1050 (42S01) at line 113: Table 'pm_entity' already exists
ERROR 1050 (42S01) at line 120: Table 'pm_entity_sync' already exists
ERROR 1060 (42S21) at line 131: Duplicate column name 'internal_field'
ERROR 1062 (23000) at line 137: Duplicate entry 'ProcessManagementProcessID' for key 'dynamic_field_name'
ERROR 1062 (23000) at line 143: Duplicate entry 'ProcessManagementActivityID' for key 'dynamic_field_name'

I downloaded the latest source version from http://ftp.otrs.org/pub/otrs/otrs-3.2.1.tar.gz

Any hints, what I can do to fix this framework check?

What additional information do you need to help?

Thank you all in advance!

[52nEHJ]

Any ideas?

[sinnedG]

Hey,

execute the bin/CheckDB.pl script and try to solve any problem of the output.

Cheers
Dennis

[52nEHJ]

There were no erros (this step is already contained in the UPGRADING document).

[tifoso]

same problem here when upgrading from 3.1.12. --> 3.2.2

Code: Select all

otrs@helpdesk:/opt/otrs$ ./bin/otrs.CheckDB.pl 
Trying to connect to database
DSN: DBI:mysql:database=otrs;host=localhost;
DatabaseUser: otrs

It looks Ok!
otrs@helpdesk:/opt/otrs$ cat scripts/DBUpdate-to-3.2.mysql.sql | mysql -p -f -u root otrs
Enter password: 
otrs@helpdesk:/opt/otrs$ ./scripts/DBUpdate-to-3.2.pl 

Migration started...

Step 1 of 9: Refresh configuration cache... 
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
done.

Not framework version required at ./scripts/DBUpdate-to-3.2.pl line 217.
Step 2 of 9: Check framework version... otrs@helpdesk:/opt/otrs$ 

any idea???

Tifoso

[jojo]

Not framework version required at ./scripts/DBUpdate-to-3.2.pl line 217.

you are running the script on the wrong location (check your Config.pm)

[tifoso]

my error..

a used official backup and restore script for previous steps.. and for that also RELEASE file of old version was restored...

everything fine now!!
SORRY and THX !

[52nEHJ]

used official backup and restore script for previous steps.. and for that also RELEASE file of old version was restored...

What script did you use? I would like to test it, too.