Mantis Bugtracker 

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008978TestLinkTest Executepublic2020-08-10 14:532020-08-11 12:22
Assigned Tofman 
PlatformLinuxOSUbuntuOS Version18.04
Product Version1.9.20 
Fixed in Version 
Summary0008978: DB access error for Test execution
DescriptionUsing 1.9.20 DEV (upgraded from 1.9.19) and can't proceed with test execution, still getting this error page in left frame:


 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.


#0 database->exec_query() called at [/var/www/html/lib/functions/database.class.php:641]
#1 database->fetchRowsIntoMap() called at [/var/www/html/lib/functions/]
0000002 execTree() called at [/var/www/html/lib/functions/tlTestCaseFilterControl.class.php:1084]
0000003 tlTestCaseFilterControl->build_tree_menu() called at [/var/www/html/lib/execute/execNavigator.php:35]

Unfortunately as there are no DB queries listed I can't investigate further :(
Neither Apache nor Testlink log files shows any problem.
Steps To Reproduce

Steps are simple: 1) Created a test plan, 2) Created a build 3) added a test case to the plan 4) Clicked to Test execution button.
TagsNo tags attached.
Database (MySQL,Postgres,etc)Mysql 5.7.30-0ubuntu0.18.04.1
PHP Version 7.2.24
QA Team - Task Workflow Status
Attached Filestxt file icon db_output.txt [^] (52,709 bytes) 2020-08-11 11:38 [Show Content]

- Relationships

-  Notes
fman (administrator)
2020-08-10 17:10

1. use code from github branch testlink_1_9_20_fixed
2. give a look to -> [^]
texis (reporter)
2020-08-11 08:41

Updated with suggested branch code. Still the same.
Reviewed 8956 ticket and found only one SQL query which works on my installation without an issue.

Any idea how to get more debug information in my case to see where might by that DB Access problem?

Thanks a lot.
fman (administrator)
2020-08-11 09:27

you need to edit database.class.php and change the debug stacktrace to display more info
texis (reporter)
2020-08-11 12:03

Hi, I managed to increase a debug info and figured out there are missing tables - the first SQL from the attached info failed on missing lates_exec_by_tesplan table - I can confirm that those are being created in db_schema_update.sql for 1.9.20 but not sure if it's some later update? Because I did this update when movig from 1.9.19 to .20 - I see that some ALTER tables or CREATE table from this file I've already applied. But not all of them.
texis (reporter)
2020-08-11 12:07
edited on: 2020-08-11 12:22

One more note: CREATE TABLE /*prefix*/baseline_l1l2_context within db_schema_update.sql complains about INVALID DEFAULT VALUE for timestamp field end_exec_ts

But now it seems to be working fine - please close this tictket

- Issue History
Date Modified Username Field Change
2020-08-10 14:53 texis New Issue
2020-08-10 17:10 fman Note Added: 0029877
2020-08-10 17:10 fman Assigned To => fman
2020-08-10 17:10 fman Status new => feedback
2020-08-11 08:41 texis Note Added: 0029879
2020-08-11 08:41 texis Status feedback => assigned
2020-08-11 09:27 fman Note Added: 0029881
2020-08-11 11:38 texis File Added: db_output.txt
2020-08-11 12:03 texis Note Added: 0029882
2020-08-11 12:07 texis Note Added: 0029883
2020-08-11 12:22 texis Note Edited: 0029883 View Revisions

Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker