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 ? When I ran a SQL query about it, I can see the result below (SELECT * FROM article) : ID TICKET_ID ARTICLE_SENDER_TYPE_ID COMMUNICATION_CHANNEL_ID IS_VISIBLE_FOR_CUSTOMER SEARCH_INDEX_NEEDS_REBUILD INSERT_FINGERPRINT CREATE_TIME CREATE_BY CHANGE_TIME CHANGE_BY 1 235 1 1 1 0 15165-oE7fivzjkn1S57A8MZ2o9QfFsHXLZnHK 2018-05-25 18:11:30 3 2018-05-25 18:11:30 3 2 235 1 1 1 0 15147-LaE2kJ2uQoRK1vcL6ZHirYOYLWRUFnyU 2018-05-25 18:11:45 3 2018-05-25 18:11:45 3 3 235 1 1 1 0 1654-mEmoCnIgHweBLCSzJVdMBGMEHXyCA4Vl 2018-05-25 18:22:10 3 2018-05-25 18:22:10 3 … … … … … … … … … … … 31 1537 3 1 1 0 30105-qXC8qf4D9JOtxu5kSP1u6zrhJdG6wfKv 2018-05-28 14:40:15 1 2018-05-28 14:40:15 1 32 1862 1 1 1 0 28719-2qM68hcyIBkmBOBgGPXO5MR7fYKZL9nJ 2018-05-28 15:00:46 3 2018-05-28 15:00:46 3 327 194 1 1 1 0 NULL 2015-02-19 15:04:53 5 2015-02-19 15:04:53 5 328 195 1 1 1 0 NULL 2015-02-19 15:10:49 5 2015-02-19 15:10:49 5 329 196 1 1 1 0 NULL 2015-02-19 15:21:44 4 2015-02-19 15:21:44 4 330 197 1 1 1 0 NULL 2015-02-19 15:30:46 4 2015-02-19 15:30:46 4 … … … … … … … … … … … 9973 235 1 1 1 0 NULL 2018-05-25 16:34:04 3 2018-05-25 16:34:04 3 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.jao...@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