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.
Migration database error from 5.1SP3 to 6.0
jbarba · 6 nov 2015, 15:25 · 8 mensajes · 92 visitas
- Inicio del debate
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.
OS: Debian 8 (Debian 3.16.7-ckt11-1+deb8u5) Install with apt, from sources: deb http://ftp.us.debian.org/debian/ jessie main non-free deb http://www.artica.es/debian/squeeze / Installation without problems. Only when run the script for upgrade the database in mysql, according to instructions: http://wiki.pandorafms.com/index.php?title=Pandora:Actualizacion\_Pandora Regards, Javi
Hello jbarba, Try the sql that I'm attaching to the document and lemme' know the output. Everything should work fine ;) Regards, Emilio.
Hello Emilio, What attach or document?
Hello jbarba, My bad, I forgot to attach it... There you go! Regards, Emilio.
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 !!!!! ;)
Hello jbarba, I'm glad everything is working! Lemme' know if some other problem comes up ;) Regards, Emilio.
Entra en tu cuenta para publicar.
