Limpieza de tickets

[jano]

Buenas a tod@s,

Tras unos meses desconectado de otrs he instalado la última versión para intentar migrar las modificaciones que tengo hechas en la vieja. El caso es que una vez testeados algunos cambios, al ir a limpiar los tickets de prueba desde MariaDB (= que MySQL) empleando los siguientes comandos:

Code: Select all

delete from ticket_history;
delete from article;
delete from article_attachment;
delete from article_plain;
delete from time_accounting;
delete from ticket;

No me limpia los tickets :S (En la versión que tengo en producción si que me funciona y deja otrs limpito limpito).

Estos son los errores:

Code: Select all

MariaDB [otrs]> delete from ticket_history;
Query OK, 49 rows affected (0.04 sec)

MariaDB [otrs]> delete from article;
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`otrs`.`article_flag`, CONSTRAINT `FK_article_flag_article_id_id` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`))
MariaDB [otrs]> delete from article_attachment;
Query OK, 14 rows affected (0.27 sec)

MariaDB [otrs]> delete from article_plain;
Query OK, 14 rows affected (0.07 sec)

MariaDB [otrs]> delete from time_accounting;
Query OK, 0 rows affected (0.00 sec)

MariaDB [otrs]> delete from ticket;
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`otrs`.`article`, CONSTRAINT `FK_article_ticket_id_id` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`))
MariaDB [otrs]>

¿Alguna idea?

Muchas gracias por vuestro tiempo