Error in Exporting Test suites

1.8 related questions and discussions.
Please upgrade to LATEST 1.9.x.
No more fixes for 1.8.

Moderators: Amaradana, TurboPT, TL Developers

Locked
sss
Advanced user
Posts: 17
Joined: Fri Feb 26, 2010 9:48 am

Error in Exporting Test suites

Post by sss »

Hi,

I am new to Testlink and we are trying to use TestLink 1.8.3 version. We are facing some issue , when we are trying to export the test suites. The error displayed is


ERROR ON exec_query() - database.class.php
0 - - SELECT U.login AS updater_login,users.login as author_login, NHB.name,NHB.node_order,NHA.parent_id AS testcase_id, tcversions.*, users.first AS author_first_name, users.last AS author_last_name, U.first AS updater_first_name, U.last AS updater_last_name FROM nodes_hierarchy NHA JOIN nodes_hierarchy NHB ON NHA.parent_id = NHB.id JOIN tcversions ON NHA.id = tcversions.id LEFT OUTER JOIN users ON tcversions.author_id = users.id LEFT OUTER JOIN users U ON tcversions.updater_id = U.id WHERE NHA.parent_id = 5660 ORDER BY tcversions.version DESC

THE MESSAGE :: SQL [94] executed [took 0.0620 secs][all took 5.35 secs]: SELECT U.login AS updater_login,users.login as author_login, NHB.name,NHB.node_order,NHA.parent_id AS testcase_id, tcversions.*, users.first AS author_first_name, users.last AS author_last_name, U.first AS updater_first_name, U.last AS updater_last_name FROM nodes_hierarchy NHA JOIN nodes_hierarchy NHB ON NHA.parent_id = NHB.id JOIN tcversions ON NHA.id = tcversions.id LEFT OUTER JOIN users ON tcversions.author_id = users.id LEFT OUTER JOIN users U ON tcversions.updater_id = U.id WHERE NHA.parent_id = 5660 ORDER BY tcversions.version DESC Query failed: errorcode[0] errormsg:
ERROR ON exec_query() - database.class.php
1 - Can't create/write to file 'C:\xampp\tmp\#sql_494_0.MYI' (Errcode: 17) - SELECT U.login AS updater_login,users.login as author_login, NHB.name,NHB.node_order,NHA.parent_id AS testcase_id, tcversions.*, users.first AS author_first_name, users.last AS author_last_name, U.first AS updater_first_name, U.last AS updater_last_name FROM nodes_hierarchy NHA JOIN nodes_hierarchy NHB ON NHA.parent_id = NHB.id JOIN tcversions ON NHA.id = tcversions.id LEFT OUTER JOIN users ON tcversions.author_id = users.id LEFT OUTER JOIN users U ON tcversions.updater_id = U.id WHERE NHA.parent_id = 5658 ORDER BY tcversions.version DESC


I have created the test project->test suite which has few child test suites. The child test suites has the test cases in it. If i export individual test cases it is working fine, but exporting whole test suites i am getting this error. The user has admin permission.

Browser version used is Firefox 3.0.17. Any help is appreciated.

Thanks
sss
Advanced user
Posts: 17
Joined: Fri Feb 26, 2010 9:48 am

Post by sss »

Just now we have upgraded the version to 1.8.5 and its giving error as

Fatal error: Call to undefined function reportfatal() in C:\xampp\htdocs\testlink\lib\functions\database.class.php on line 193
sss
Advanced user
Posts: 17
Joined: Fri Feb 26, 2010 9:48 am

Post by sss »

Looks like the exported file has some limit , if i am exporting upto 26 test cases which amount to 20.7 KB ( As i m seeing in download rate) it is working fine. But above if i add, even one test case it is resulting in the above mentioned error.

Please help me in analysing and solving the problem. Is something to do with database, do we have to configure somewhere the limit?

Thanks
sss
Advanced user
Posts: 17
Joined: Fri Feb 26, 2010 9:48 am

Post by sss »

In config.in.php i could find limit on importing file sizes

$tlCfg->import_max_size = '409600'; // in bytes

/** Maximum line size of the imported file */
$tlCfg->import_max_row = '10000'; // in chars

but no reference to exporting file size.
Locked