Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008943TestLinkTest Specification Exportpublic2020-06-23 09:382020-07-04 08:11
Reporterimash 
Assigned Tofman 
PriorityurgentSeverityblockReproducibilityalways
StatusresolvedResolutionunable to reproduce 
Platformdcker container OSUbuntuOS Version16.04.3
Product Version1.9.19 (2019 Q1) 
Fixed in Version 
Summary0008943: Test Suite Document (HTML) on New Window and Download Test Suite Document (Pseudo word) functions are not working
DescriptionTest 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 ReproduceSteps 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)
Additional Information ==============================================================================

 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
TagsNo tags attached.
Database (MySQL,Postgres,etc)chrome
Browsermariadb
PHP VersionPHP 7.3.13
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Filespng file icon image-2020-06-19-14-46-48-942.png [^] (23,686 bytes) 2020-06-23 09:38

- Relationships

-  Notes
(0029769)
imash (reporter)
2020-06-23 09:47

category should be change to "Test Spec / Test Suite Pseudo Word Report"
(0029776)
fman (administrator)
2020-06-24 10:24

please do a fresh install of branch testlink_1_9_20_fixed
re-test and provide feedback
(0029786)
imash (reporter)
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 (administrator)
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 (administrator)
2020-06-25 15:33

waiting for user feedback after development recommendation will be applied
(0029817)
fman (administrator)
2020-07-04 08:11

no more user feedback

- Issue History
Date Modified Username Field Change
2020-06-23 09:38 imash New Issue
2020-06-23 09:38 imash File Added: image-2020-06-19-14-46-48-942.png
2020-06-23 09:47 imash Note Added: 0029769
2020-06-24 10:24 fman Note Added: 0029776
2020-06-24 10:24 fman Status new => feedback
2020-06-25 10:46 imash Note Added: 0029786
2020-06-25 10:46 imash Status feedback => new
2020-06-25 10:47 imash Note Edited: 0029786 View Revisions
2020-06-25 15:33 fman Note Added: 0029791
2020-06-25 15:33 fman Note Added: 0029792
2020-06-25 15:33 fman Assigned To => fman
2020-06-25 15:33 fman Status new => feedback
2020-07-04 08:11 fman QA Team - Task Workflow Status => TBD
2020-07-04 08:11 fman Note Added: 0029817
2020-07-04 08:11 fman Status feedback => resolved
2020-07-04 08:11 fman Resolution open => unable to reproduce



Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker