Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0001740TestLinkTest Specificationpublic2008-09-24 03:122008-12-08 20:03
Reporterschlundus 
Assigned Tofman 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version1.8 Beta 3 
Fixed in Version1.8 RC 1 
Summary0001740: If the TC-Prefix contains non_alphanumeric charactes SQL errors occurs in planUrgency.php
DescriptionIf the TC-Prefix contains non_alphanumeric charactes SQL errors occurs in planUrgency.php
Steps To ReproduceERROR 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 '\-' AS tcprefix, NHB.name, NHA.parent_id AS testcase_id, TCV.tc_external_i' at line 1 - SELECT DISTINCT '
T"P's\
-' AS tcprefix, NHB.name, NHA.parent_id AS testcase_id, TCV.tc_external_id, testplan_tcversions.urgency FROM nodes_hierarchy NHA JOIN nodes_hierarchy NHB ON NHA.parent_id = NHB.id JOIN testplan_tcversions ON testplan_tcversions.tcversion_id=NHA.id JOIN tcversions TCV ON TCV.id = testplan_tcversions.tcversion_id WHERE testplan_tcversions.testplan_id=19 AND NHB.parent_id=1 ORDER BY NHB.node_order

THE MESSAGE :: SQL [16] executed [took 0.0055 secs][all took 0.2343 secs]: SELECT DISTINCT '
T"P's\
-' AS tcprefix, NHB.name, NHA.parent_id AS testcase_id, TCV.tc_external_id, testplan_tcversions.urgency FROM nodes_hierarchy NHA JOIN nodes_hierarchy NHB ON NHA.parent_id = NHB.id JOIN testplan_tcversions ON testplan_tcversions.tcversion_id=NHA.id JOIN tcversions TCV ON TCV.id = testplan_tcversions.tcversion_id WHERE testplan_tcversions.testplan_id=19 AND NHB.parent_id=1 ORDER BY NHB.node_order 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 '\-' AS tcprefix, NHB.name, NHA.parent_id AS testcase_id, TCV.tc_external_i' at line 1
TP"d\$'
- Test urgency for the Test suite :
H"รถ'\g
TagsNo tags attached.
Database (MySQL,Postgres,etc)
Browser
PHP Version
TestCaseID
QA Team - Task Workflow Status
Attached Files

- Relationships

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2008-09-24 03:12 schlundus New Issue
2008-09-24 18:59 fman Status new => assigned
2008-09-24 18:59 fman Assigned To => fman
2008-09-24 23:33 schlundus Status assigned => resolved
2008-09-24 23:33 schlundus Fixed in Version => next development 1.8 RC 1
2008-09-24 23:33 schlundus Resolution open => fixed
2008-12-08 20:03 mhavlat Status resolved => closed



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker