Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0002032TestLinkTest Specificationpublic2009-01-29 11:592009-02-06 06:49
Reporterkalafut 
Assigned Toschlundus 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version1.8 RC 3 
Fixed in Version1.8 RC 4 
Summary0002032: Move/Copy Test cases from Suite selection doesn't work
Description1. Select a Test Suite
2. Select Move/Copy Test Cases
3. Choose some cases
4. Either Move or Copy will fail with errors

Errors when choosing Move:

ERROR ON exec_query() - database.class.php
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 - UPDATE nodes_hierarchy SET parent_id = 2 WHERE id IN ()

THE MESSAGE :: SQL [10] executed [took 0.0002 secs][all took 0.0052 secs]: UPDATE nodes_hierarchy SET parent_id = 2 WHERE id IN () Query failed: errorcode[1064] errormsg:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1


Errors when choosing Copy:
ERROR ON exec_query() - database.class.php
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY tcversions.version DESC' at line 14 - 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 = ORDER BY tcversions.version DESC

THE MESSAGE :: SQL [10] executed [took 0.0003 secs][all took 0.0057 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 = ORDER BY tcversions.version DESC Query failed: errorcode[1064] errormsg:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY tcversions.version DESC' at line 14

TagsNo tags attached.
Database (MySQL,Postgres,etc)
BrowserSafari
PHP Version5.2.0
TestCaseID
QA Team - Task Workflow Status
Attached Files

- Relationships

-  Notes
(0005173)
fman (administrator)
2009-01-30 17:31

Ok, what is the solution ?
(0005176)
schlundus (reporter)
2009-01-30 18:15
edited on: 2009-01-30 18:16

I changed the aliasnames within SQL to lowercase

(0005177)
fman (administrator)
2009-01-30 18:24

thanks

- Issue History
Date Modified Username Field Change
2009-01-29 11:59 kalafut New Issue
2009-01-29 11:59 kalafut Browser => Safari
2009-01-29 11:59 kalafut PHP Version => 5.2.0
2009-01-29 16:41 mhavlat Priority normal => high
2009-01-30 03:17 schlundus Status new => assigned
2009-01-30 03:17 schlundus Assigned To => schlundus
2009-01-30 05:20 schlundus Status assigned => resolved
2009-01-30 05:20 schlundus Fixed in Version => next DEV - 1.8 RC 4
2009-01-30 05:20 schlundus Resolution open => fixed
2009-01-30 17:31 fman Note Added: 0005173
2009-01-30 18:15 schlundus Note Added: 0005176
2009-01-30 18:16 schlundus Note Edited: 0005176
2009-01-30 18:24 fman Note Added: 0005177
2009-02-06 06:49 mhavlat Status resolved => closed



Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker