Newly created test case not viewable (sql server 2008)

[oileanach]

Hi All.

I set up TestLink 1.9 RC1 using XAMPP (php and apache) and a SQL server 2008 database. I had a previous installation of testlink using a MYSQL database that worked a treat but due to company rules i had to migrate to SQL Server 2008.

I did a full export from mySQL db. I inserted each of the mySQL insert statements individually until the SQL DB was a carbon copy of the mysql one i migrated from. Everything seemed to be OK including existing test specifications and executions.

When i went to create a new test case. The test case was created but when i clicked on it to open the test case to edit it i got a 'Your search delivered no results!' error in the test case view screen.

Any help would be appreciated.

Thanks,

Oileanach

[oileanach]

Just an update to this. When i created a test case in previous environment the test case would be created with a number after it. 'SQL-1', 'SQL-2', 'SQL-3'... and so on. When i create the test cases in the new environment, the test case is just created as 'SQL-' without a number. So all new test cases are being created with no unique identifier. Where is this set and why would this not be being set now?

[Amaradana]

Still thinking about your problem. there is string in config.inc.php, i dont remember it exactly. which is used to hide the tree numbers i guess, check it once. and second, wdi dyou try reoridering cases, did that diplay there?

[oileanach]

This is what is in the config.inc.php

/* [GUI: TREE] */

/** Default ordering value for new Test Suites and Test Cases to separate them */
$tlCfg->treemenu_default_testsuite_order = 1;
$tlCfg->treemenu_default_testcase_order = 100;

/** show/hide testcase id on tree menu */
$tlCfg->treemenu_show_testcase_id = TRUE;

/** Reorder test cases based on TC Name or External ID in tree on
* test suite level using reorder button
*/
// 'EXTERNAL_ID' -> Sort on Test Case External ID field displayed on tree.(Default)
// 'NAME' -> Sort on Test Case Name field

$tlCfg->testcase_reorder_by = 'EXTERNAL_ID';
// $tlCfg->testcase_reorder_by = 'NAME';


In test specification, yeah it is possible to reorder the test cases. They still appear in the for 'SQL-:this is a test case' instead of 'SQL-1:This is a test case'. After reordering them and clicking on the test case i still get the 'Your search delivered no results!' error

[Amaradana]

better log a defect in tracker to dig more into this

[oileanach]

http://mantis.testlink.org/view.php?id=3974

[oileanach]

This bug has been closed with the following note 'Not a TL problem, TC was added without following standard procedures -> system NEEDS external TC ID number to do searchs '

I still dont know how to fix this issue? Any help would be appreciated?