Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007331TestLinkAssign Test Case Executionpublic2015-11-06 13:002016-02-26 19:05
Reporterregonzalom 
Assigned Tofman 
PriorityhighSeveritycrashReproducibilityalways
StatusclosedResolutionfixed 
PlatformAllOSUbuntuOS Version12.04.5
Product Version1.9.13 (2015 #1) 
Fixed in Version1.9.14 (2015 Q3) 
Summary0007331: I get a DB error when I run a test case.
DescriptionWhen I try to run a test case, I get the error:

 ==============================================================================
 DB Access Error - debug_print_backtrace() OUTPUT START
 ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200)
            Having this additional Information could be useful for reporting
            issue to development TEAM.
 ==============================================================================
 ==============================================================================
 ==============================================================================
 DB Access Error - debug_print_backtrace() OUTPUT START
 ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200)
            Having this additional Information could be useful for reporting
            issue to development TEAM.
 ==============================================================================
 ==============================================================================
Steps To ReproduceThere are two ways to reproduce this error.

First way:

1. "Execute Test".
2. Open Cases Tree.
3. Run a Test Case.

Second waw:

1. Go to "Test Cases Assigned to Me ".
2. Run a testCase
Additional Informationuserlog1.log:

[15/Nov/6 12:38:14][WARNING][cbuip5qj2669tdq0pc4ust53o6][GUI]
        E_NOTICE
Undefined index: testPlanId - in /opt/testlink/testlink-1.9.13/lib/execute/execSetResults.php - Line 352
    [15/Nov/6 12:38:14][ERROR][cbuip5qj2669tdq0pc4ust53o6][DATABASE]
        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 name ASC' at line 1 - /* Class:testplan - Method: get_builds_for_html_options */ SELECT id, name FROM builds WHERE testplan_id = ORDER BY name ASC
THE MESSAGE : /* Class:testplan - Method: get_builds_for_html_options */ SELECT id, name FROM builds WHERE testplan_id = ORDER BY name ASC
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 name ASC' at line 1
    [15/Nov/6 12:38:14][WARNING][cbuip5qj2669tdq0pc4ust53o6][GUI]
        E_NOTICE
Undefined property: stdClass::$can_delete_execution - in /opt/testlink/testlink-1.9.13/lib/execute/execSetResults.php - Line 822
    [15/Nov/6 12:38:14][WARNING][cbuip5qj2669tdq0pc4ust53o6][GUI]
        E_NOTICE
Undefined property: stdClass::$edit_notes - in /opt/testlink/testlink-1.9.13/lib/execute/execSetResults.php - Line 828
    [15/Nov/6 12:38:14][ERROR][cbuip5qj2669tdq0pc4ust53o6][DATABASE]
        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 - /* Class:tree - Method: _get_path */ SELECT id,name,parent_id,node_type_id,node_order FROM nodes_hierarchy WHERE id =
THE MESSAGE : /* Class:tree - Method: _get_path */ SELECT id,name,parent_id,node_type_id,node_order FROM nodes_hierarchy WHERE 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
[<<][563c9f3690867131083901][DEFAULT][/testlink/lib/execute/execSetResults.php][15/Nov/6 12:38:14][15/Nov/6 12:38:14][took 0.086752 secs]
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL 5.5.44
BrowserAll
PHP Version5.4.43-1
TestCaseID
QA Team - Task Workflow StatusREADY FOR TESTING
Attached Filespng file icon testlink_error.png [^] (125,308 bytes) 2015-11-06 13:01

- Relationships
related to 0007447new DB Error on Installation - Version 1.9.15 from GIT 

-  Notes
(0024208)
fman (administrator)
2015-11-06 13:39

upgrade to 1.9.14 and retest
(0024209)
regonzalom (reporter)
2015-11-06 14:53

I have found the origin of first error.

In testlink-1.9.13/lib/execute/execSetResults.php, line 352 there is a call to $_SESSION['testPlanId']. Despite the position exists, it have other kind of CamelCase; the right name is $_SESSION['testplanID'].

I will be working in the other error message.

Regards,
Gonzalo
(0024210)
regonzalom (reporter)
2015-11-06 15:38

I forgot clarify that I installed the fix to another problem that I found here:

http://mantis.testlink.org/view.php?id=2273 [^]

I am sure that this origin this sitiation.

Regards,

- Issue History
Date Modified Username Field Change
2015-11-06 13:00 regonzalom New Issue
2015-11-06 13:01 regonzalom File Added: testlink_error.png
2015-11-06 13:39 fman Note Added: 0024208
2015-11-06 13:39 fman Assigned To => fman
2015-11-06 13:39 fman Status new => feedback
2015-11-06 14:53 regonzalom Note Added: 0024209
2015-11-06 14:53 regonzalom Status feedback => assigned
2015-11-06 15:38 regonzalom Note Added: 0024210
2015-11-06 18:09 fman QA Team - Task Workflow Status => READY FOR TESTING
2015-11-06 18:09 fman Status assigned => closed
2015-11-06 18:09 fman Resolution open => fixed
2015-11-06 18:09 fman Fixed in Version => 1.9.14 (2015 Q3)
2016-02-26 19:05 fman Relationship added related to 0007447



Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker