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
Error in Exporting Test suites
Moderators: Amaradana, TurboPT, TL Developers
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
Please help me in analysing and solving the problem. Is something to do with database, do we have to configure somewhere the limit?
Thanks