Hallo zusammen,
beim Punkt 9. der Upgrade-Anleitung "Apply the database changes (part1/2)" erhalte ich nach dem ausführen von
cat scripts/DBUpdate-to-3.1.mysql.sql | mysql -p -f -u root otrs diese Fehler:
ERROR 1050 (42S01) at line 28: Table 'gi_webservice_config' already exists ERROR 1050 (42S01) at line 45: Table 'gi_webservice_config_history' already exists ERROR 1050 (42S01) at line 60: Table 'scheduler_task_list' already exists ERROR 1050 (42S01) at line 73: Table 'gi_debugger_entry' already exists ERROR 1050 (42S01) at line 87: Table 'gi_debugger_entry_content' already exists ERROR 1050 (42S01) at line 101: Table 'gi_object_lock_state' already exists ERROR 1062 (23000) at line 115: Duplicate entry 'EscalationSolutionTimeStop' for key 'ticket_history_type_name' ERROR 1062 (23000) at line 121: Duplicate entry 'EscalationResponseTimeStart' for key 'ticket_history_type_name' ERROR 1062 (23000) at line 127: Duplicate entry 'EscalationUpdateTimeStart' for key 'ticket_history_type_name' ERROR 1062 (23000) at line 133: Duplicate entry 'EscalationSolutionTimeStart' for key 'ticket_history_type_name' ERROR 1062 (23000) at line 139: Duplicate entry 'EscalationResponseTimeNotifyBefore' for key 'ticket_history_type_name' ERROR 1062 (23000) at line 145: Duplicate entry 'EscalationUpdateTimeNotifyBefore' for key 'ticket_history_type_name' ERROR 1062 (23000) at line 151: Duplicate entry 'EscalationSolutionTimeNotifyBefore' for key 'ticket_history_type_name' ERROR 1062 (23000) at line 157: Duplicate entry 'EscalationResponseTimeStop' for key 'ticket_history_type_name' ERROR 1062 (23000) at line 163: Duplicate entry 'EscalationUpdateTimeStop' for key 'ticket_history_type_name' ERROR 1050 (42S01) at line 169: Table 'smime_signer_cert_relations' already exists ERROR 1060 (42S21) at line 184: Duplicate column name 'process_change' ERROR 1062 (23000) at line 187: Duplicate entry '4467-Seen-4' for key 'ticket_flag_per_user' ERROR 1050 (42S01) at line 191: Table 'dynamic_field_value' already exists ERROR 1050 (42S01) at line 206: Table 'dynamic_field' already exists ERROR 1060 (42S21) at line 225: Duplicate column name 'imap_folder' ERROR 1005 (HY000) at line 226: Can't create table 'otrs.#sql-627_19' (errno: 150) ERROR 1005 (HY000) at line 227: Can't create table 'otrs.#sql-627_19' (errno: 150) ERROR 1005 (HY000) at line 228: Can't create table 'otrs.#sql-627_19' (errno: 150) ERROR 1005 (HY000) at line 229: Can't create table 'otrs.#sql-627_19' (errno: 121) ERROR 1005 (HY000) at line 230: Can't create table 'otrs.#sql-627_19' (errno: 150) ERROR 1005 (HY000) at line 231: Can't create table 'otrs.#sql-627_19' (errno: 150) ERROR 1005 (HY000) at line 232: Can't create table 'otrs.#sql-627_19' (errno: 121) ERROR 1005 (HY000) at line 233: Can't create table 'otrs.#sql-627_19' (errno: 121) ERROR 1005 (HY000) at line 234: Can't create table 'otrs.#sql-627_19' (errno: 121) ERROR 1005 (HY000) at line 235: Can't create table 'otrs.#sql-627_19' (errno: 150) ERROR 1005 (HY000) at line 236: Can't create table 'otrs.#sql-627_19' (errno: 150) ERROR 1005 (HY000) at line 237: Can't create table 'otrs.#sql-627_19' (errno: 121) ERROR 1005 (HY000) at line 238: Can't create table 'otrs.#sql-627_19' (errno: 150) ERROR 1005 (HY000) at line 239: Can't create table 'otrs.#sql-627_19' (errno: 150) ERROR 1005 (HY000) at line 240: Can't create table 'otrs.#sql-627_19' (errno: 150)
Wo könnte hier das Problem liegen? Ich habe anschl. das Script DPUpdate-to-3.1.pl ausgeführt und das lief problemlos durch.
Auch der part 2/2 "cat scripts/DBUpdate-to-3.1-post.mysql.sql | mysql -p -f -u root otrs" lief sauber durch.
Hab ich da hinterher jetzt irgendwelche Probleme zu erwarten?
Danke.
--
mit freundlichen Grüßen Lars Scheler _____________________________________________ ComWer GmbH Creidlitzer Str.140 96450 Coburg Telefon: 09561 /14-567 Telefax: 09561 /14-789 www.comwer.de lars@comwer.de HRB 3244 ,Amtsgericht 96450 Coburg USt-IDNr. DE173832986 Geschäftsführer:Manuel Fischer Bankverbindung: SparkasseCoburg-Lichtenfels BLZ 783 500 00 KTO 922 73 64 Deutsche Bank BLZ760 700 24 KTO 856 76 79