[V1.9.16] Hudge tc_external_id

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

[V1.9.16] Hudge tc_external_id

Postby noircc » Tue Jun 06, 2017 1:53 pm

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.


Image

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 :
Image


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

Thanks. Cordially
noircc
TestLink user
 
Posts: 1
Joined: Sun May 21, 2017 9:42 am

Return to Installation and configuration



Who is online

Users browsing this forum: No registered users and 6 guests