Pandora FMS Community

Migration database error from 5.1SP3 to 6.0

jbarba · 6 nov 2015, 15:25 · 8 mensajes · 92 visitas

  1. Inicio del debate

    When you run: cat /var/www/html/pandora_console/extras/pandoradb_migrate_5.1.x_to_6.0.mysql.sql | mysql -uroot -ppandora -D pandora in the sequence: ALTER TABLE `tmodule_relationship` ADD FOREIGN KEY (`id_rt`) REFERENCES trecon_task(`id_rt`) ON DELETE CASCADE; ALTER TABLE tmodule_relationship MODIFY `id_rt` int(10) unsigned NULL default NULL; i get an error: ALTER TABLE `tmodule_relationship` ADD FOREIGN KEY (`id_rt`) REFERENCES trecon_task(`id_rt`) ON DELETE CASCADE Error #1072 - Key column 'id_rt' doesn't exist in table How I can solve it? Thank you.

  2. Hello jbarba, I didn't get that error, so maybe that's a problem from the method that you used for the installation (maybe the installation files that you used are not working properly). So, tell me, how did you install it? What  OS are you working with (CentOS, Ubuntu...)? So I can use the same method and replicate it ;) Regards, Emilio.

  3. Hello jbarba, Try the sql that I'm attaching to the document and lemme' know the output. Everything should work fine ;) Regards, Emilio.

  4. Hello Emilio, What attach or document?

  5. Hello jbarba, My bad, I forgot to attach it... There you go! Regards, Emilio.

    migrate_done.sql

  6. Hi, Emilio: Fields in tables "tagente_modulo" "I tagente_estado", "tgraph_source" and "tevent_filter" already existed, so giving a "duplicate column". I have checked each of these fields of these tables, and they were created equal. After executing your SQL statements, and yes I could successfully run the two sentences before giving error. Thank you !!!!! ;)

  7. Hello jbarba, I'm glad everything is working! Lemme' know if some other problem comes up ;) Regards, Emilio.

Entra en tu cuenta para publicar.