Hello i have a problem with script mantis upgrade. Mi version de otrs is 3.2.15 i have upgrade to 3.3.6 but al execute the script failed with erros:
Errors
ERROR 1050 (42S01) at line 30: Table 'system_data' already exists
INFO: Foreign key constraint FK_standard_response_valid_id_id does not exist, sk ipping.
INFO: Foreign key constraint FK_standard_response_valid_id_id does not exist, sk ipping.
INFO: Foreign key constraint FK_standard_response_create_by_id does not exist, s kipping.
INFO: Foreign key constraint FK_standard_response_create_by_id does not exist, s kipping.
INFO: Foreign key constraint FK_standard_response_change_by_id does not exist, s kipping.
INFO: Foreign key constraint FK_standard_response_change_by_id does not exist, s kipping.
INFO: Foreign key constraint FK_queue_standard_response_standard_response_id_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_standard_response_id_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_queue_id_id does not exi st, skipping.
INFO: Foreign key constraint FK_queue_standard_response_queue_id_id does not exi st, skipping.
INFO: Foreign key constraint FK_queue_standard_response_create_by_id does not ex ist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_create_by_id does not ex ist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_change_by_id does not ex ist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_change_by_id does not ex ist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_standard_response_i d_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_standard_response_i d_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_standard_attachment _id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_standard_attachment _id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_create_by_id does n ot exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_create_by_id does n ot exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_change_by_id does n ot exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_change_by_id does n ot exist, skipping.
ERROR 1050 (42S01) at line 117: Table 'queue_standard_template' already exists
ERROR 1005 (HY000) at line 123: Can't create table 'otrs2.#sql-1d98_614' (errno: 121)
ERROR 1452 (23000) at line 124: Cannot add or update a child row: a foreign key constraint fails (`otrs2`.`#sql-1d98_614`, CONSTRAINT `FK_standard_template_crea te_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`))
ERROR 1452 (23000) at line 125: Cannot add or update a child row: a foreign key constraint fails (`otrs2`.`#sql-1d98_614`, CONSTRAINT `FK_standard_template_chan ge_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`))
ERROR 1054 (42S22) at line 129: Unknown column 'standard_response_id' in 'queue_ standard_template'
ERROR 1005 (HY000) at line 140: Can't create table 'otrs2.#sql-1d98_614' (errno: 121)
ERROR 1005 (HY000) at line 141: Can't create table 'otrs2.#sql-1d98_614' (errno: 121)
ERROR 1005 (HY000) at line 142: Can't create table 'otrs2.#sql-1d98_614' (errno: 121)
ERROR 1005 (HY000) at line 143: Can't create table 'otrs2.#sql-1d98_614' (errno: 121)
ERROR 1146 (42S02) at line 148: Table 'otrs2.virtual_fs' doesn't exist
ERROR 1146 (42S02) at line 149: Table 'otrs2.virtual_fs' doesn't exist
ERROR 1146 (42S02) at line 150: Table 'otrs2.virtual_fs_db' doesn't exist
ERROR 1146 (42S02) at line 151: Table 'otrs2.virtual_fs_db' doesn't exist
ERROR 1005 (HY000) at line 152: Can't create table 'otrs2.#sql-1d98_614' (errno: 121)
ERROR 1005 (HY000) at line 153: Can't create table 'otrs2.#sql-1d98_614' (errno: 121)
Any Help ?
Debian 7 - MySQL - Problem Upgrade 3.2.15 to 3.3.6
Moderator: crythias