Re: [otrs] OTRS6 - Upgrade from v5 to v6. article ID has changed

2018-05-30 Thread Juan Manuel Clavero Almirón 
Hi Jaouen,

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)

Worry if you get an actual duplicate ID

Juan Clavero | Perl Developer

> On 30. May 2018, at 09:41, JAOUEN Egareg  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é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 
> 
-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

[otrs] OTRS6 - Upgrade from v5 to v6. article ID has changed

2018-05-30 Thread JAOUEN Egareg 
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é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