I'm following the upgrade guide from the source tar.....I get the errors running the first DB 2.3 MySQL script....
Manuel Fernández Panzuela <manuelfernandezpanzu...@gmail.com> wrote: How are you trying upgrade, are you following any reference? Un saludo Manuel Fernández Panzuela www.mfernandez.es 2010/7/10 Isaac Gonzalez <igonza...@autoreturn.com> > Upgrading from 2.2.x to 2.4.x(cent os 5, mysql 4.1.18) > > > > I ran into some errors during the db upgrade for mysql for 2.2 to 2.3 > > The first error was on line 4 for the statement > > > > ALTER TABLE sla DROP FOREIGN KEY FK_sla_service_id_id; > > > > Gave the error of rename of dbname\sla to #sql2-25000-b > > > > > > And then every alter statement below that tried to add a constraint also > gave back an error cannot create table \dbname\#sql 2500_b.frm .can I > just safely ignore this?...i have rolled everything back to how it was with > 2.2, but would love to complete the upgrade process . > > > > > > ALTER TABLE ticket_watcher ADD CONSTRAINT FK_ticket_watcher_ticket_id_id > FOREIGN KEY (ticket_id) REFERENCES ticket (id); > > ALTER TABLE ticket_watcher ADD CONSTRAINT FK_ticket_watcher_user_id_id > FOREIGN KEY (user_id) REFERENCES users (id); > > ALTER TABLE ticket_watcher ADD CONSTRAINT FK_ticket_watcher_create_by_id > FOREIGN KEY (create_by) REFERENCES users (id); > > ALTER TABLE ticket_watcher ADD CONSTRAINT FK_ticket_watcher_change_by_id > FOREIGN KEY (change_by) REFERENCES users (id); > > ALTER TABLE queue_preferences ADD CONSTRAINT > FK_queue_preferences_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue > (id); > > ALTER TABLE service_sla ADD CONSTRAINT FK_service_sla_service_id_id FOREIGN > KEY (service_id) REFERENCES service (id); > > ALTER TABLE service_sla ADD CONSTRAINT FK_service_sla_sla_id_id FOREIGN KEY > (sla_id) REFERENCES sla (id); > > ALTER TABLE link_type ADD CONSTRAINT FK_link_type_create_by_id FOREIGN KEY > (create_by) REFERENCES users (id); > > ALTER TABLE link_type ADD CONSTRAINT FK_link_type_change_by_id FOREIGN KEY > (change_by) REFERENCES users (id); > > ALTER TABLE link_type ADD CONSTRAINT FK_link_type_valid_id_id FOREIGN KEY > (valid_id) REFERENCES valid (id); > > ALTER TABLE link_state ADD CONSTRAINT FK_link_state_create_by_id FOREIGN > KEY (create_by) REFERENCES users (id); > > ALTER TABLE link_state ADD CONSTRAINT FK_link_state_change_by_id FOREIGN > KEY (change_by) REFERENCES users (id); > > ALTER TABLE link_state ADD CONSTRAINT FK_link_state_valid_id_id FOREIGN KEY > (valid_id) REFERENCES valid (id); > > ALTER TABLE link_relation ADD CONSTRAINT > FK_link_relation_source_object_id_id FOREIGN KEY (source_object_id) > REFERENCES link_object (id); > > ALTER TABLE link_relation ADD CONSTRAINT > FK_link_relation_target_object_id_id FOREIGN KEY (target_object_id) > REFERENCES link_object (id); > > ALTER TABLE link_relation ADD CONSTRAINT FK_link_relation_state_id_id > FOREIGN KEY (state_id) REFERENCES link_state (id); > > ALTER TABLE link_relation ADD CONSTRAINT FK_link_relation_type_id_id > FOREIGN KEY (type_id) REFERENCES link_type (id); > > ALTER TABLE link_relation ADD CONSTRAINT FK_link_relation_create_by_id > FOREIGN KEY (create_by) REFERENCES users (id); > > ALTER TABLE article_search ADD CONSTRAINT > FK_article_search_article_sender_type_id_id FOREIGN KEY > (article_sender_type_id) REFERENCES article_sender_type (id); > > ALTER TABLE article_search ADD CONSTRAINT > FK_article_search_article_type_id_id FOREIGN KEY (article_type_id) > REFERENCES article_type (id); > > ALTER TABLE article_search ADD CONSTRAINT FK_article_search_ticket_id_id > FOREIGN KEY (ticket_id) REFERENCES ticket (id); > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > > NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! > http://www.otrs.com/en/support/enterprise-subscription/ >
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
