MantisBT - TestLink
View Issue Details
0008943TestLinkTest Specification Exportpublic2020-06-23 09:382020-07-04 08:11
imash 
fman 
urgentblockalways
resolvedunable to reproduce 
dcker container Ubuntu16.04.3
1.9.19 (2019 Q1) 
 
chrome
mariadb
PHP 7.3.13
TBD
0008943: Test Suite Document (HTML) on New Window and Download Test Suite Document (Pseudo word) functions are not working
Test Suite Document (HTML) on New Window and Download Test Suite Document (Pseudo word) functions are not working.

AS attached in the image, we are getting this error once click on either of button.
Steps to Recreate:
01 - Access TestLink
02 - Goto Test Specification >> Select a test suite
03 - Click on Actions
04 - Click on Test Suite Document (HTML) on New Window
05 - Click on Download Test Suite Document (Pseudo word)
 ==============================================================================

 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( /* Class:requirement_mgr - Method: getActiveForTCVersion */ SELECT REQ.id,REQ.id AS req_id,REQ.req_doc_id,NHREQ.name AS title, RCOV.is_active, NHRS.name AS req_spec_title,RCOV.testcase_id, REQV.id AS req_version_id, REQV.version FROM requirements REQ JOIN req_specs RSPEC ON REQ.srs_id = RSPEC.id JOIN req_coverage RCOV ON RCOV.req_id = REQ.id JOIN nodes_hierarchy NHRS ON NHRS.id=RSPEC.id JOIN nodes_hierarchy NHREQ ON NHREQ.id=REQ.id JOIN req_versions REQV ON RCOV.req_version_id=REQV.id WHERE RCOV.tcversion_id IN () AND RCOV.is_active=1 , -1, -1) called at [/opt/bitnami/testlink/lib/functions/database.class.php:759]
#1 database->get_recordset( /* Class:requirement_mgr - Method: getActiveForTCVersion */ SELECT REQ.id,REQ.id AS req_id,REQ.req_doc_id,NHREQ.name AS title, RCOV.is_active, NHRS.name AS req_spec_title,RCOV.testcase_id, REQV.id AS req_version_id, REQV.version FROM requirements REQ JOIN req_specs RSPEC ON REQ.srs_id = RSPEC.id JOIN req_coverage RCOV ON RCOV.req_id = REQ.id JOIN nodes_hierarchy NHRS ON NHRS.id=RSPEC.id JOIN nodes_hierarchy NHREQ ON NHREQ.id=REQ.id JOIN req_versions REQV ON RCOV.req_version_id=REQV.id WHERE RCOV.tcversion_id IN () AND RCOV.is_active=1 ) called at [/opt/bitnami/testlink/lib/functions/requirement_mgr.class.php:4604]
0000002 requirement_mgr->getActiveForTCVersion() called at [/opt/bitnami/testlink/lib/functions/print.inc.php:1444]
0000003 renderTestCaseForPrinting(database Object ([db] => ADODB_mysqli Object ([databaseType] => mysqli,[dataProvider] => mysql,[hasInsertID] => 1,[hasAffectedRows] => 1,[metaTablesSQL] => SELECT
            TABLE_NAME,
            CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
        FROM INFORMATION_SCHEMA.TABLES
        WHERE TABLE_SCHEMA=,[metaColumnsSQL] => SHOW COLUMNS FROM `%s`,[fmtTimeStamp] => 'Y-m-d H:i:s',[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => 1,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[port] => 3306,[socket] => ,[_bindInputArray] => ,[nameQuote] => `,[optionFlags] => Array ([0] => Array ([0] => 5,[1] => 0)),[arrayClass] => ADORecordSet_array_mysqli,[multiQuery] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table if not exists %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table if exists %s,[database] => bitnami_testlink,[host] => mariadb,[user] => bn_testlink,[password] => ,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => 'Y-m-d',[true] => 1,[false] => 0,[replaceQuote] => \',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[ansiOuter] => ,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[bulkBind] => ,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => mysqli Object ([affected_rows] => ,[client_info] => ,[client_version] => ,[connect_errno] => ,[connect_error] => ,[errno] => ,[error] => ,[error_list] => ,[field_count] => ,[host_info] => ,[info] => ,[insert_id] => ,[server_info] => ,[server_version] => ,[stat] => ,[sqlstate] => ,[protocol_version] => ,[thread_id] => ,[warning_count] => ),[_errorMsg] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND RCOV.is_active=1' at line 1,[_errorCode] => ,[_queryID] => 1,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[*connectionParameters] => Array (),[databaseName] => bitnami_testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 0,[overallDuration] => 0,[dbType] => mysqli,[databaselogEnabled] => 0,[databaselogQueries] => 0), Array ([parent_id] => 2678558,[id] => 2678559,[name] => CRM Search (RES & Customer Profile)- Filters, (First Name, Loyalty No, Email..etc) [H2H calls],[childNodes] => ,[node_table] => testcases,[node_type_id] => 3,[node_order] => 0), Array ([toc] => 1,[headerNumbering] => 1,[header] => 1,[summary] => 1,[body] => 1,[author] => 1,[keyword] => 1,[cfields] => 1,[requirement] => 1,[req_spec_scope] => 1,[req_spec_author] => 1,[req_spec_overwritten_count_reqs] => 1,[req_spec_type] => 1,[req_spec_cf] => 1,[req_scope] => 1,[req_author] => 1,[req_status] => 1,[req_type] => 1,[req_cf] => 1,[req_relations] => 1,[req_linked_tcs] => 1,[req_coverage] => 1,[displayVersion] => 1,[execResultsByCFOnExecCombination] => 1,[notes] => 1,[step_exec_notes] => ,[passfail] => ,[step_exec_status] => ,[build_cfields] => 1,[metrics] => 1,[docType] => testspec,[tocCode] =>
Table Of Contents
No tags attached.
png image-2020-06-19-14-46-48-942.png (23,686) 2020-06-23 09:38
http://mantis.testlink.org/file_download.php?file_id=5362&type=bug
png
Issue History
2020-06-23 09:38imashNew Issue
2020-06-23 09:38imashFile Added: image-2020-06-19-14-46-48-942.png
2020-06-23 09:47imashNote Added: 0029769
2020-06-24 10:24fmanNote Added: 0029776
2020-06-24 10:24fmanStatusnew => feedback
2020-06-25 10:46imashNote Added: 0029786
2020-06-25 10:46imashStatusfeedback => new
2020-06-25 10:47imashNote Edited: 0029786bug_revision_view_page.php?bugnote_id=29786#r6083
2020-06-25 15:33fmanNote Added: 0029791
2020-06-25 15:33fmanNote Added: 0029792
2020-06-25 15:33fmanAssigned To => fman
2020-06-25 15:33fmanStatusnew => feedback
2020-07-04 08:11fmanQA Team - Task Workflow Status => TBD
2020-07-04 08:11fmanNote Added: 0029817
2020-07-04 08:11fmanStatusfeedback => resolved
2020-07-04 08:11fmanResolutionopen => unable to reproduce

Notes
(0029769)
imash   
2020-06-23 09:47   
category should be change to "Test Spec / Test Suite Pseudo Word Report"
(0029776)
fman   
2020-06-24 10:24   
please do a fresh install of branch testlink_1_9_20_fixed
re-test and provide feedback
(0029786)
imash   
2020-06-25 10:46   
(edited on: 2020-06-25 10:47)
We installed this using docker image.

version: '2'

services:
  mariadb:
    image: 'docker.io/bitnami/mariadb:10.3-debian-10'
    environment:
      - MARIADB_USER=bn_testlink
      - MARIADB_DATABASE=bitnami_testlink
      - ALLOW_EMPTY_PASSWORD=yes
    ports:
      - '3306:3306'
    volumes:
      - 'mariadb_data_19:/bitnami'
  testlink:
    image: 'docker.io/bitnami/testlink:1.9.19-r294'
    environment:
      - MARIADB_HOST=mariadb
      - MARIADB_PORT_NUMBER=3306
      - TESTLINK_DATABASE_USER=bn_testlink
      - TESTLINK_DATABASE_NAME=bitnami_testlink
      - ALLOW_EMPTY_PASSWORD=yes
      - SMTP_ENABLE=true
      - SMTP_HOST=smtp.gmail.com
      - SMTP_PORT=587
      - SMTP_USER=#####@gmail.com
      - SMTP_PASSWORD=####0000003
      - SMTP_CONNECTION_MODE=tls
    ports:
      - '8081:80'
        #- '443:443'
    volumes:
      - 'testlink_data_19:/bitnami'
    depends_on:
      - mariadb

volumes:
  mariadb_data_19:
    driver: local
  testlink_data_19:
    driver: local




This is the configuration file. could you please provide correct docker image that solve all these issues.

(0029791)
fman   
2020-06-25 15:33   
I'm sorry but I've not created the docker file.
You need to be able to upgrade the code in the docker asking to the people that have created the docker
(0029792)
fman   
2020-06-25 15:33   
waiting for user feedback after development recommendation will be applied
(0029817)
fman   
2020-07-04 08:11   
no more user feedback