I don't think you need to be worried: probably the alter table resetted the autoincrement value but the database is still preventing any collision, it's just filling the empty values (autoincrement normally doesn't fill all the values, sometimes there are gaps between IDs)

On 30. May 2018, at 09:41, JAOUEN Egareg <egareg.jaouen@elitt.com> wrote:

Hi,

After the upgrade from OTRS v5 to OTRS v6.0.7, I have noticed a change in the article view : new articles are shown after the oldest one. After a little investigation, new articles seem to have id with a lower value than older articles.
How is it possible ?

My older articles IDs start from value 327. And the newest articles IDs start from 1 to 32 (for the moment).
I am expecting some troubles when the article ID will reach the value 327…
How to fix that point ?

My highest value for article ID is 9973 and the change appears exactly when I migrated from v5.0.27 to v6.0.1.

Thanks,

Egareg JAOUEN
Ingénieur Recherche&Développement
Tel : +33 2 31 35 34 81 │egareg.jaouen@elitt.com
ELITT
8 rue Léopold Sédar-Senghor - 14460 Colombelles - France │www.elitt.com
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs