MantisBT - TestLink
View Issue Details
0008531TestLinkTest Spec. - Test Case relationspublic2019-01-09 18:032019-01-10 07:30
noliveira 
 
normalmajoralways
newopen 
1.9.18 (2018 Q3) 
 
MySQL
Chrome
5.6.38
0008531: Error while add a relation with another test case
Error while add a relation with another test case
1. Open a test case
2. Insert an ID of another test case and click add
3. Show this error:

#0 database->exec_query( / Class:testcase - Method: addRelation / INSERT INTO testcase_relations (source_id, destination_id, relation_type, author_id, creation_ts) values (1495541,1460168, 3, 53, '2019-01-09 14:55:35')) called at [/var/www/testlink/lib/functions/testcase.class.php:6257]
#1 testcase->addRelation(1495540, 1460167, 3, 53) called at [/var/www/testlink/lib/testcases/testcaseCommands.class.php:1124]
No tags attached.
Issue History
2019-01-09 18:03noliveiraNew Issue
2019-01-09 19:27fmanNote Added: 0028413
2019-01-09 19:27fmanStatusnew => feedback
2019-01-09 21:43noliveiraNote Added: 0028415
2019-01-09 21:43noliveiraStatusfeedback => new
2019-01-10 07:30fmanNote Added: 0028416

Notes
(0028413)
fman   
2019-01-09 19:27   
1. DBMS type & version are needed
2. Please try the sql on a sql client to get more info
3. Please get latest code from github, do fresh install, retest & provide feedback
(0028415)
noliveira   
2019-01-09 21:43   
I receive an error at the sql client:

mysql> INSERT INTO testcase_relations (source_id, destination_id, relation_type, author_id, creation_ts) values (1495541,1460168, 3, 53, '2019-01-09 14:55:35');
ERROR 1364 (HY000): Field 'tcase_source_id' doesn't have a default value

Can you help with this error?
(0028416)
fman   
2019-01-10 07:30   
Hi
please

1. DBMS type & version are needed
3. Please get latest code from github, do fresh install, retest & provide feedback

this seems a bad migration