MantisBT - TestLink
View Issue Details
0002347TestLinkDatabase MySQLpublic2009-04-07 22:032009-05-11 15:55
freeride65 
schlundus 
normalmajoralways
closedfixed 
1.8.1 
1.8.2 
ie7
5.2.9.1
0002347: Searching TestCase i got a mysql error
Where: Test Case Search Page
How: If i try to put a string like this TC- or -TC in the search input field
i got two different type of error:



FOR THE STRING TC- I GOT THIS:

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 - SELECT DISTINCT NH.parent_id AS tcase_id FROM tcversions TCV, nodes_hierarchy NH WHERE TCV.id = NH.id AND TCV.tc_external_id=

THE MESSAGE :: SQL [12] executed [took 0.0002 secs][all took 0.0128 secs]: SELECT DISTINCT NH.parent_id AS tcase_id FROM tcversions TCV, nodes_hierarchy NH WHERE TCV.id = NH.id AND TCV.tc_external_id= 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



FOR THE STRING -TC I GOT THIS:

ERROR ON exec_query() - database.class.php
1054 - Unknown column 'TC' in 'where clause' - SELECT DISTINCT NH.parent_id AS tcase_id FROM tcversions TCV, nodes_hierarchy NH WHERE TCV.id = NH.id AND TCV.tc_external_id=TC

THE MESSAGE :: SQL [12] executed [took 0.0002 secs][all took 0.0314 secs]: SELECT DISTINCT NH.parent_id AS tcase_id FROM tcversions TCV, nodes_hierarchy NH WHERE TCV.id = NH.id AND TCV.tc_external_id=TC Query failed: errorcode[1054] errormsg:Unknown column 'TC' in 'where clause'



No tags attached.
jpg errorTlink.jpg (265,132) 2009-04-07 22:03
http://mantis.testlink.org/file_download.php?file_id=942&type=bug
Issue History
2009-04-07 22:03freeride65New Issue
2009-04-07 22:03freeride65File Added: errorTlink.jpg
2009-04-07 22:03freeride65Browser => ie7
2009-04-07 22:03freeride65PHP Version => 5.2.9.1
2009-04-08 00:43schlundusStatusnew => assigned
2009-04-08 00:43schlundusAssigned To => schlundus
2009-04-08 01:09schlundusStatusassigned => confirmed
2009-04-10 03:59schlundusStatusconfirmed => resolved
2009-04-10 03:59schlundusFixed in Version => 1.8.2 (bug fixing)
2009-04-10 03:59schlundusResolutionopen => fixed
2009-04-10 03:59schlundusNote Added: 0006331
2009-05-11 15:55mhavlatStatusresolved => closed

Notes
(0006331)
schlundus   
2009-04-10 03:59   
Fixed in 1.8.2 and above