Test Case ID changed after migrating from 1.7.4 to 1.8

greaze · Post by **greaze** » Tue Apr 28, 2009 11:13 am

Hi, Please help me on this one.

we use 1.7.4. Recently we upgraded to 1.8 and found that all the test case IDs have been changed.

For Example, in 1.7.4, one of my test cases has ID 20885.
The same test cases on 1.8 has ID changed to Logon (ID=20)-2057

How can I revert this back to the same IDs that we had on 1.7.4?

Thanks in advance.

greaze · Post by **greaze** » Tue Apr 28, 2009 2:47 pm

More details:

I have queried the both the databases using:
SELECT * FROM nodes_hierarchy where id = 22577;

The data in the table in both the databases is identical. So the database has not changed I think, its only the way its displayed in 1.8

Please suggest what I need to change to ensure that the test cases id remains the same after migrating to 1.8 from 1.7.4

tlinkjira · Post by **tlinkjira** » Tue Apr 28, 2009 5:08 pm

Did you ever hear back about your question? I'm having the same problem. I can live with new test case ID but really want to get rid of ID=109 or what ever the number is showing up?
For example, 8.1.7 (ID=109)-37:Verify that you can arrange the Sent Items box in any order.
I want to get rid of (ID=109) part. Do you know how?

greaze · Post by **greaze** » Tue Apr 28, 2009 6:20 pm

Further info:

The prefixed value for the test case id is coming from 'prefix' column in testprojects table. First five characters are your project name truncated and then the ID of the project within columns.

I will read the docs to find a solution but any help in the meantime is appreciated.

greaze · Post by **greaze** » Tue Apr 28, 2009 9:30 pm

I now understand that this is a feature in 1.8.
Section 3.2 of the user guide.

I do not wish to use this feature. How can I revert the test case IDs back to what they were on 1.7.4?

davila · Post by **davila** » Wed Apr 29, 2009 2:12 pm

Upgraded from 1.7.4 to 1.8.0.

We have the same issue. The old IDs are in the DB; how can we display them again? All our TC's have an ID of "0". We are in need of the original TC IDs. Thx.

davila · Post by **davila** » Wed Apr 29, 2009 4:09 pm

Found this in the forum and it worked great:

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

Post by **fman** » Wed Apr 29, 2009 5:18 pm

Dev Team have added an script that you can found on your installation under third_party\user_con* that will do some magic on Tc id

greaze · Post by **greaze** » Fri May 15, 2009 5:04 pm

we get the following error messages when we run the script.

Any suggestions?

[root@doccontrol ~]# ./reassign_tc_id.php
./reassign_tc_id.php: line 1: ?php: No such file or directory
./reassign_tc_id.php: line 2: /backups: is a directory
./reassign_tc_id.php: line 3: 1.8.0: command not found
./reassign_tc_id.php: line 4: 1.8.0: command not found
./reassign_tc_id.php: line 5: 1.8.0: command not found
./reassign_tc_id.php: line 6: 1.8.0: command not found
./reassign_tc_id.php: line 7: 1.8.0: command not found
./reassign_tc_id.php: line 8: 1.8.0: command not found
./reassign_tc_id.php: line 9: 1.8.0: command not found
./reassign_tc_id.php: line 10: 1.8.0: command not found
./reassign_tc_id.php: line 11: 1.8.0/: is a directory
./reassign_tc_id.php: line 13: syntax error near unexpected token `"../../config.inc.php"'
./reassign_tc_id.php: line 13: `require_once("../../config.inc.php");'

Post by **havlatm** » Sun May 17, 2009 2:28 am

Use:

Code: Select all

# php reassign_tc_id.php

Post by **havlatm** » Sun May 17, 2009 2:31 am

Use:

Code: Select all

# php reassign_tc_id.php

greaze · Post by **greaze** » Tue May 26, 2009 11:04 am

Logged in as Admin and ran the script from the application.

Works beautifully

Well done.