Test case Id lost when migrationg from 1.7.4 to 1.8 B3

[rinmar]

is there a possibility to fill the external_id via the migration process?
testcase id is filled, external id is 0.

[rinmar]

Solution see Mantis id 0002020

[fman]

utility page has been added on third_party folder of last CVS code

[unixadmin007]

After migration run this command, it will resume id's.

UPDATE tcversions a SET a.tc_external_id = (SELECT b.parent_id from nodes_hierarchy b where a.id = b.id);

[pantana]

Will these solutions work if a number of test cases have been added after the upgrade? What about their ids?

[fman]

prefix can not be disabled

[kevinlevy]

In response to pantana's question.

I was in the same boat - I upgraded an existing 1.7 database to 1.8. I followed the instructions on using a prefix and than altering my db so that the external ids matched up with internal ids.

However, when I created new test cases - the ids assigned seem to be low and were the same ids that had been used before.

I fixed this problem by altering the column testprojects.tc_counter for each of my projects. I set the counter to a high number so that I was sure this wasn't going to be used.

This seems to be a bug with the upgrader though - and this should be dealt with as part of the upgrade script.