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.jaouen@elitt.com
ELITT
8 rue Léopold Sédar-Senghor - 14460 Colombelles - France │www.elitt.com