You should truncate the table before doing the insert, using:
TRUNCATE TABLE ticket_history_type table;
(check the docs - I am going from memory and might be off).
that should delete all the records in the table and reset the IDs back
to zero. If you then insert the records back in the correct order,
then you should get everything to line up.
Tony
On Tue, May 6, 2008 at 8:11 AM, Régis OBERLE
Hello,
Can anybody help ?
Thanks,
Regis
-----Message d'origine----- De : otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] De la part de Régis OBERLE Envoyé : vendredi 2 mai 2008 08:22 À : User questions and discussions about OTRS.org Objet : [otrs] Restore ticket_history_type table
Hello everybody,
I've accidentally deleted the content of the ticket_history_table. I've reloaded the data from the otrs-initial_insert.mysql.sql script but since the "id" field is an auto-increment, values are starting now from 40 instead of 1. I had a look at the ticket_history.type_id values and I only have: 1,2 and 5.
What can be the consequences of this error ? How can I correct the ticket_history_type table ?
Thank you for your help.
Regards,
Régis _______________________________________________ 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 Support or consulting for your OTRS system? http://www.otrs.com/ _______________________________________________ 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 Support or consulting for your OTRS system?