[V1.9.16] Hudge tc_external_id

[noircc]

Hi,

On one “Test Project” we have huge "tc_external_id" when we create a “Test Case”. Huge is for exemple “1000431” (xxxxxx-1000431:test)
On our other “Test Project”, we don’t have this issue. "tc_external_id" have 5 numbers top.

I’ve directly changed, in the database, the "tc_external_id" column in the "tcversions" table, to recalculate the “test case” number (export to *.xml with phpmyadmin, change value with powershell and import new *.xml).

• xxxxxx-500:case1
  xxxxxx-501:case2
  xxxxxx-502:case3
  …

But when we create a “Test Case” in the bugge “Test Project”, the new "tc_external_id" is still huge.




Third line (id 159129): “Test Project” who bug, when I’ve change "tc_external_id".
Second line (id 159131): “Test Project” who bug, after created a “test case”, after I’ve change "tc_external_id".
First line (id 159133): “test case” created on other “Test Project”, after I’ve change "tc_external_id".


With :

Code: Select all

SELECT max(id) FROM tcversions 

I have :

159151

I’ve try this :

Code: Select all

 ALTER TABLE tcversions AUTO_INCREMENT=13511

But same issue.


With :

Code: Select all

 SELECT * FROM  INFORMATION_SCHEMA.TABLES

I have :



Would there be someone who would know what I need to change so that "tc_external_id" come back to correct numbering ?

Thanks. Cordially