0004929: DB Access Error while importing requirements from xml file

(0016431)
javydreamercsw (reporter)
2012-03-06 18:42

The issue was that I didn't have a requirement specification created and tried to do it from the Project node.

(0016432)
fman (administrator)
2012-03-06 19:54

OK.
we are going to try to improve file check before importing, giving some warning.
Till now we are going to give low priority

(0016433)
fman (administrator)
2012-03-06 19:56

Reminder sent to: kinow

@kinow
do you think you will be able to work on this ?
(on 1.9 and 2.0 ?)

(0016714)
kinow (reporter)
2012-05-19 16:13
edited on: 2012-05-19 16:14

I've committed code that must fix this issue. I've included a simple check for the scenario described in this issue: no requirement specification created/selected, and a XML with only requirements, hence leading to either ghost requirements in database or DB errors.

@javydreamercsw: could you give it a try, please? I've used your XML and other exported requirement/requirement specification entities for testing. I've uploaded reqImport.php here, copy it to $TESTLINK_HOME/lib/requirements/ (use a test Testlink instance, or back up your version first!).

Thank you!

(0023181)
Mr.Bricodage (updater)
2015-04-26 16:17

Waiting for user feedback since 2012

(0023230)
javydreamercsw (reporter)
2015-04-27 13:29

Never saw this request before. I no longer have the system setup as it don't work for me back then.

Is this in the current version?

I could set it up again and check, but not sure when I'll be able to provide feedback.

(0023252)
Mr.Bricodage (updater)
2015-04-28 18:21

kinow commit : https://github.com/TestLinkOpenSourceTRMS/testlink-code/commit/f43d3be75c8a7a952184dff08dd0a4f886553ba4 [^]

commited in 1.9.x branch.
Still present in 1.9.13 version (lib/requirements/reqImport.php)

Issue History
Date Modified	Username	Field	Change
2012-03-06 17:45	javydreamercsw	New Issue
2012-03-06 17:45	javydreamercsw	File Added: output100.xml
2012-03-06 18:42	javydreamercsw	Note Added: 0016431
2012-03-06 19:54	fman	Note Added: 0016432
2012-03-06 19:55	fman	Priority	high => low
2012-03-06 19:55	fman	Assigned To	=> kinow
2012-03-06 19:55	fman	Status	new => assigned
2012-03-06 19:56	fman	Note Added: 0016433
2012-05-19 13:58	kinow	Status	assigned => work in progress
2012-05-19 16:10	kinow	File Added: reqImport.php
2012-05-19 16:13	kinow	Note Added: 0016714
2012-05-19 16:14	kinow	Note Edited: 0016714	View Revisions
2012-05-19 16:14	kinow	Status	work in progress => feedback
2015-04-26 16:17	Mr.Bricodage	Note Added: 0023181
2015-04-26 16:17	Mr.Bricodage	Relationship added	child of 0007083
2015-04-27 13:29	javydreamercsw	Note Added: 0023230
2015-04-27 13:29	javydreamercsw	Status	feedback => assigned
2015-04-28 18:21	Mr.Bricodage	Note Added: 0023252
2015-04-28 18:21	Mr.Bricodage	Status	assigned => feedback
2019-01-19 15:08	fman	Status	feedback => resolved
2019-01-19 15:08	fman	Resolution	open => unable to reproduce

Notes
(0016431) javydreamercsw (reporter) 2012-03-06 18:42	The issue was that I didn't have a requirement specification created and tried to do it from the Project node.

(0016432) fman (administrator) 2012-03-06 19:54	OK. we are going to try to improve file check before importing, giving some warning. Till now we are going to give low priority

(0016433) fman (administrator) 2012-03-06 19:56	Reminder sent to: kinow @kinow do you think you will be able to work on this ? (on 1.9 and 2.0 ?)

(0016714) kinow (reporter) 2012-05-19 16:13 edited on: 2012-05-19 16:14	I've committed code that must fix this issue. I've included a simple check for the scenario described in this issue: no requirement specification created/selected, and a XML with only requirements, hence leading to either ghost requirements in database or DB errors. @javydreamercsw: could you give it a try, please? I've used your XML and other exported requirement/requirement specification entities for testing. I've uploaded reqImport.php here, copy it to $TESTLINK_HOME/lib/requirements/ (use a test Testlink instance, or back up your version first!). Thank you!

(0023181) Mr.Bricodage (updater) 2015-04-26 16:17	Waiting for user feedback since 2012

(0023230) javydreamercsw (reporter) 2015-04-27 13:29	Never saw this request before. I no longer have the system setup as it don't work for me back then. Is this in the current version? I could set it up again and check, but not sure when I'll be able to provide feedback.

(0023252) Mr.Bricodage (updater) 2015-04-28 18:21	kinow commit : https://github.com/TestLinkOpenSourceTRMS/testlink-code/commit/f43d3be75c8a7a952184dff08dd0a4f886553ba4 [^] commited in 1.9.x branch. Still present in 1.9.13 version (lib/requirements/reqImport.php)