Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007356TestLinkDatabase Generalpublic2015-11-24 16:142016-09-08 15:13
ReporterabIng 
Assigned Tofman 
PrioritynormalSeveritytrivialReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version1.9.13 (2015 #1) 
Fixed in Version1.9.14 (2015 Q3) 
Summary0007356: Invalid SQL SELECT request in delete_execution function
DescriptionIn the file exic.inc.php, function delete_execution contains the lines:

  $dummy = " SELECT id FROM {$tables['execution_tcsteps']} " .
           " WHERE execution_id = {$sid}";

However, there is no field in the table execution_tcsteps.
The code should be:

  $dummy = " SELECT tcstep_id AS id FROM {$tables['execution_tcsteps']} " .
           " WHERE execution_id = {$sid}";
Steps To ReproduceGo to 'Execute Tests'
Select any test with the status 'Passed'
Choose Result 'Failed'
Save Execution
In the list of exécutions remove the previous (Passed) execution

The operation fails with the error message in the log:

[>>][565346abc5ec2665433739][DEFAULT][/lib/execute/execSetResults.php][15/Nov/23 17:02:35]
    [15/Nov/23 17:02:37][ERROR][v69rqdrmclh7t0cobgfptps0r6][DATABASE]
        ERROR ON exec_query() - database.class.php
207 - SQLState: 42S22
Error Code: 207
Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'id'.
SQLState: 42S22
Error Code: 207
Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'id'.
 - SELECT id FROM execution_tcsteps WHERE execution_id = 113609
THE MESSAGE : SELECT id FROM execution_tcsteps WHERE execution_id = 113609
Query failed: errorcode[207]
    errormsg:SQLState: 42S22
Error Code: 207
Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'id'.
TagsNo tags attached.
Database (MySQL,Postgres,etc)MS SQL
BrowserFirefox
PHP Version5.3
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Files

- Relationships

-  Notes
(0025304)
fman (administrator)
2016-09-08 15:13

1.9.15 Released - 2016-09-08

- Issue History
Date Modified Username Field Change
2015-11-24 16:14 abIng New Issue
2015-11-24 19:41 fman QA Team - Task Workflow Status => TBD
2015-11-24 19:41 fman Status new => resolved
2015-11-24 19:41 fman Fixed in Version => 1.9.14 (2015 Q3)
2015-11-24 19:41 fman Resolution open => fixed
2015-11-24 19:41 fman Assigned To => fman
2016-09-08 15:13 fman Note Added: 0025304
2016-09-08 15:13 fman Status resolved => closed



Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker