Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008628TestLinkUsabilitypublic2019-04-10 06:032019-04-19 18:39
Reporterkarollipnicki 
Assigned Tofman 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformLINUXOSCentosOS Version7.5
Product Version1.9.19 (2019 Q1) 
Fixed in Version 
Summary0008628: Cannot create related issue
DescriptionI can't create relation beetwen issues because of errors:

 ==============================================================================

 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:testcase - Method: addRelation */ INSERT INTO testcase_relations (source_id, destination_id, relation_type, author_id, creation_ts) values (1445308,1444857, 3, 406, '2019-04-10 05:59:13')) called at [/testlink/web/testlink.app/lib/functions/testcase.class.php:7593]
#1 testcase->addRelation(1445307, 1444856, 3, 406) called at [/testlink/web/testlink.app/lib/testcases/testcaseCommands.class.php:1122]
0000002 testcaseCommands->doAddRelation(stdClass Object ([assigned_keywords_list] => ,[container_id] => 0,[file_id] => 0,[tcase_id] => 1445307,[tcversion_id] => 0,[name] => ,[summary] => ,[preconditions] => ,[steps] => ,[expected_results] => ,[new_container_id] => 0,[old_container_id] => 0,[has_been_executed] => 0,[exec_type] => 1,[importance] => 2,

Steps To Reproduce1. Select project and expand test cases tree.
2. Select not executed test case
3. In frame relations write ID of some other test case, click Add
4. Error appears.
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL
BrowserFirefox, Chrome, IE
PHP Version7.2
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Files

- Relationships

-  Notes
(0028693)
fman (administrator)
2019-04-10 09:17
edited on: 2019-04-10 09:19

1) relation between issues? impossible Testlink does not manage relation between issues.

2) have you tried the sql query detailed on error msg in a sql client to get more info?
INSERT INTO testcase_relations (source_id, destination_id, relation_type, author_id, creation_ts) values (1445308,1444857, 3, 406, '2019-04-10 05:59:13'

3) give a look to http://mantis.testlink.org/view.php?id=7042 [^] , to provide detailed information

(0028696)
karollipnicki (reporter)
2019-04-10 10:27

> 1) relation between issues? impossible Testlink does not manage relation between issues.

My fault - It concerns about creating relationship beetwen test cases.

I've tried to execute query with result:

MariaDB [testlink_migrated]> INSERT INTO testcase_relations (source_id, destination_id, relation_type, author_id, creation_ts) values (1445308,1444857, 3, 406, '2019-04-10 05:59:13');
ERROR 1364 (HY000): Field 'tcase_source_id' doesn't have a default value
MariaDB [testlink_migrated]>
(0028704)
fman (administrator)
2019-04-11 21:06

Your migration has gone bad at structure level, testcase_relations table has to be

CREATE TABLE /*prefix*/testcase_relations (
  `id` int(10) unsigned NOT NULL auto_increment,
  `source_id` int(10) unsigned NOT NULL,
  `destination_id` int(10) unsigned NOT NULL,
  `link_status` tinyint(1) NOT NULL default '1',
  `relation_type` smallint(5) unsigned NOT NULL default '1',
  `author_id` int(10) unsigned default NULL,
  `creation_ts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;


remove the additional columns and thing will be ok
(0028717)
karollipnicki (reporter)
2019-04-15 07:05

My testcase_relations table has columns:

+----------------------+----------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+----------------------+------+-----+---------------------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| source_id | int(10) unsigned | NO | | NULL | |
| destination_id | int(10) unsigned | NO | | NULL | |
| relation_type | smallint(5) unsigned | NO | | 1 | |
| link_status | tinyint(1) | NO | | 1 | |
| author_id | int(10) unsigned | YES | | NULL | |
| creation_ts | timestamp | NO | | current_timestamp() | |
| tcase_source_id | int(10) unsigned | NO | | NULL | |
| tcase_destination_id | int(10) unsigned | NO | | NULL | |
+----------------------+----------------------+------+-----+---------------------+----------------+


Should I remove columns described below?

| tcase_source_id | int(10) unsigned | NO | | NULL | |
| tcase_destination_id | int(10) unsigned | NO | | NULL | |
(0028718)
fman (administrator)
2019-04-15 08:09

yes, remove

| tcase_source_id | int(10) unsigned | NO | | NULL | |
| tcase_destination_id | int(10) unsigned | NO | | NULL | |
(0028740)
fman (administrator)
2019-04-19 18:39

no more user feedback

- Issue History
Date Modified Username Field Change
2019-04-10 06:03 karollipnicki New Issue
2019-04-10 09:17 fman Note Added: 0028693
2019-04-10 09:18 fman Note Edited: 0028693 View Revisions
2019-04-10 09:19 fman Note Edited: 0028693 View Revisions
2019-04-10 10:27 karollipnicki Note Added: 0028696
2019-04-11 21:02 fman QA Team - Task Workflow Status => TBD
2019-04-11 21:02 fman Description Updated View Revisions
2019-04-11 21:06 fman Note Added: 0028704
2019-04-11 21:06 fman Assigned To => fman
2019-04-11 21:06 fman Status new => feedback
2019-04-15 07:05 karollipnicki Note Added: 0028717
2019-04-15 07:05 karollipnicki Status feedback => assigned
2019-04-15 08:09 fman Note Added: 0028718
2019-04-19 18:39 fman Note Added: 0028740
2019-04-19 18:39 fman Status assigned => closed
2019-04-19 18:39 fman Resolution open => fixed



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker