DBUpdate-to-3.2.mysql.sql problem

[ZoltanBiro]

Hi All,

I'm facing the following errors when I tried to upgrade our 3.1.12 test system to 3.2.
Any idea what should I do?

Thanks!
Zoltan

Code: Select all

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

Connected.
root@otrstest02:/opt/otrs# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql -p -f -u root otrs
Enter password:
ERROR 1553 (HY000) at line 25: Cannot drop index 'article_flag_create_by': needed in a foreign key constraint
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 1005 (HY000) at line 160: Can't create table 'otrs.#sql-6fc2_3a' (errno: 121)
ERROR 1005 (HY000) at line 161: Can't create table 'otrs.#sql-6fc2_3a' (errno: 121)
ERROR 1005 (HY000) at line 162: Can't create table 'otrs.#sql-6fc2_3a' (errno: 121)
ERROR 1005 (HY000) at line 163: Can't create table 'otrs.#sql-6fc2_3a' (errno: 121)
ERROR 1005 (HY000) at line 164: Can't create table 'otrs.#sql-6fc2_3a' (errno: 121)
ERROR 1005 (HY000) at line 165: Can't create table 'otrs.#sql-6fc2_3a' (errno: 121)
ERROR 1005 (HY000) at line 166: Can't create table 'otrs.#sql-6fc2_3a' (errno: 121)
ERROR 1005 (HY000) at line 167: Can't create table 'otrs.#sql-6fc2_3a' (errno: 121)
ERROR 1005 (HY000) at line 168: Can't create table 'otrs.#sql-6fc2_3a' (errno: 121)
ERROR 1005 (HY000) at line 169: Can't create table 'otrs.#sql-6fc2_3a' (errno: 121)
root@otrstest02:/opt/otrs#

[ZoltanBiro]

It looks the DBUpdate-to-3.2.pl run without error...

Code: Select all

otrs@otrstest02:/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.

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

Step 3 of 9: Cleanup UserPreferences... done.

Step 4 of 9: Updating toolbar configuration... done.

Step 5 of 9: Updating AgentTicketZoom window configuration... done.

Step 6 of 9: Dropping obsolete columns from article_search... Check if columns exist.
Columns are not present, no need to drop them.
done.

Step 7 of 9: Migration cache backend configuration... done.

Step 8 of 9: Clean up the cache... done.

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

Migration completed!
otrs@otrstest02:/opt/otrs$