MantisBT - TestLink
View Issue Details
0008531TestLinkTest Spec. - Test Case relationspublic2019-01-09 18:032019-02-04 16:37
noliveira 
fman 
normalmajoralways
closedfixed 
1.9.18 (2018 Q3) 
 
MySQL
Chrome
5.6.38
TBD
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
2019-01-19 15:04fmanQA Team - Task Workflow Status => TBD
2019-01-19 15:04fmanNote Added: 0028443
2019-01-19 15:04fmanStatusnew => resolved
2019-01-19 15:04fmanResolutionopen => unable to reproduce
2019-01-19 15:04fmanAssigned To => fman
2019-02-04 13:09noliveiraNote Added: 0028504
2019-02-04 15:14noliveiraNote Added: 0028506
2019-02-04 15:14noliveiraStatusresolved => assigned
2019-02-04 15:14noliveiraResolutionunable to reproduce => reopened
2019-02-04 15:17fmanNote Added: 0028507
2019-02-04 15:17fmanStatusassigned => feedback
2019-02-04 15:20noliveiraNote Added: 0028508
2019-02-04 15:20noliveiraStatusfeedback => assigned
2019-02-04 16:37fmanNote Added: 0028509
2019-02-04 16:37fmanStatusassigned => closed
2019-02-04 16:37fmanResolutionreopened => fixed

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
(0028443)
fman   
2019-01-19 15:04   
no more user feedback
(0028504)
noliveira   
2019-02-04 13:09   
Hello, sorry for the delay in my response.

1. DBMS is MySQL 5.6.41
3. This will not solve our problem. The migration was made by Testlink scripts, like I said in previous issues

Are you saying to fresh install and import our DB?
(0028506)
noliveira   
2019-02-04 15:14   
I did a fresh install with 1.9.20. Execute the migration script from 1.9.18 to 1.9.19

The issue stills present
(0028507)
fman   
2019-02-04 15:17   
go to the db and remove the offending column from testcase_relations table.
(0028508)
noliveira   
2019-02-04 15:20   
Ok. Now I receive another error:

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_destination_id' doesn't have a default value
(0028509)
fman   
2019-02-04 16:37   
You have to give a look to this table structure with a FRESH installation and remove additonal columns.

closing