4.0.5 db upgrade errors

Moderator: crythias

Locked
freak
Znuny newbie
Posts: 19
Joined: 22 Sep 2014, 17:30
Znuny Version: 4.0.5

4.0.5 db upgrade errors

Post by freak »

I am running an upgrade from 3.3.9 to 4.0.5 and got these errors when running the command below from the docs at http://otrs.github.io/doc/manual/admin/ ... ading.html. Not sure what to do about it. Everything is backed up. Any tips are appreciated!

Code: Select all

root@kona:/var/www2/otrs# cat scripts/DBUpdate-to-4.mysql.sql | mysql -h 10.0.0.25 -p -f -u root otrs
Enter password:
ERROR 1060 (42S21) at line 9: Duplicate column name 'disposition'
ERROR 1060 (42S21) at line 13: Duplicate column name 'disposition'
INFO: Foreign key constraint FK_ticket_valid_id_id does not exist, skipping.
INFO: Foreign key constraint FK_ticket_valid_id_id does not exist, skipping.
ERROR 1091 (42000) at line 23: Can't DROP 'valid_id'; check that column/key exists
INFO: Foreign key constraint FK_ticket_history_valid_id_id does not exist, skipping.
INFO: Foreign key constraint FK_ticket_history_valid_id_id does not exist, skipping.
ERROR 1091 (42000) at line 33: Can't DROP 'valid_id'; check that column/key exists
ERROR 1050 (42S01) at line 38: Table 'personal_services' already exists
ERROR 1091 (42000) at line 47: Can't DROP 'content_size'; check that column/key exists
ERROR 1050 (42S01) at line 51: Table 'system_maintenance' already exists
ERROR 1005 (HY000) at line 66: Can't create table 'otrs.#sql-41b6_1d6d50' (errno: 121)
ERROR 1005 (HY000) at line 67: Can't create table 'otrs.#sql-41b6_1d6d50' (errno: 121)
ERROR 1005 (HY000) at line 68: Can't create table 'otrs.#sql-41b6_1d6d50' (errno: 121)
ERROR 1005 (HY000) at line 69: Can't create table 'otrs.#sql-41b6_1d6d50' (errno: 121)
ERROR 1005 (HY000) at line 70: Can't create table 'otrs.#sql-41b6_1d6d50' (errno: 121)
Locked