Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0005683TestLinkDatabase MySQLpublic2013-05-03 06:192013-05-22 20:57
Reportermknab 
Assigned Tofman 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Fixed in Version1.9.7 (2013 Q2 - bug fixing) 
Summary0005683: DB Access Error while creating a copy of a PRIVATE testplan
DescriptionIf you copy a testplan that was changed from public to private bevor and make a private copy of this testplan, you get a DB Access Error, but the testplan is created.

This is not reproducable with 1.9.6, only with TestLink Development Prague 1.9.7 (Q2 2013 Fixes). But if you access the same DB after the error message with a testlink 1.9.6 (from an other directory), the error is also reproducable. It seems to be not only a code-error, there should be a change in DB.

How can i correct the DB, to use it with 1.9.6 or a fixed 1.9.7 Dev?
Steps To Reproduce1) Install a new TestLink Development Prague 1.9.7 (Q2 2013 Fixes).
2) create the first testprojekt
3) create a testplan, active, public
4) create a copy of this testplan (default), active, private
5) result: no error message
6) you can retry this as much as possible, it's always ok

7) change the first testplan from public to private
8) create a copy of this testplan (default), active, private
9) result: DB Access Error - debug_print_backtrace() OUTPUT START, but the testplan is duplicated correct

Additional Information ==============================================================================

 DB Access Error - debug_print_backtrace() OUTPUT START

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

#0 database->exec_query() called at [/Applications/testlink-1.9.6-0/apps/testlink/htdocs/lib/functions/testplan.class.php:1495]
#1 testplan->copy_user_roles() called at [/Applications/testlink-1.9.6-0/apps/testlink/htdocs/lib/functions/testplan.class.php:1251]
0000002 testplan->copy_as() called at [/Applications/testlink-1.9.6-0/apps/testlink/htdocs/lib/plan/planEdit.php:187]

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


From Eventlog:
ERROR ON exec_query() - database.class.php
1062 - Duplicate entry '1-6' for key 'PRIMARY' - INSERT INTO user_testplan_roles (testplan_id,user_id,role_id) VALUES(6,1,8)
THE MESSAGE : INSERT INTO user_testplan_roles (testplan_id,user_id,role_id) VALUES(6,1,8) Query failed: errorcode[1062] errormsg:Duplicate entry '1-6' for key 'PRIMARY'

TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL
Browser
PHP Version
TestCaseID
QA Team - Task Workflow StatusREADY FOR TESTING
Attached Files

- Relationships

-  Notes
(0018857)
mknab (reporter)
2013-05-03 09:51

Don't be confused about /testlink-1.9.6-0/ in the logfile-path.
This was a test on mac with bitnami, chaning the htdocs-files with 1.9.7.
(0018863)
fman (administrator)
2013-05-03 18:47

there are missing information.
1. what about users with special role on plan ?
2. subject is incomplete . info about that this happens on PRIVATE TEST PLAN is critic , can not be only present on description and without been highlited
(0018865)
fman (administrator)
2013-05-03 19:35

http://gitorious.org/testlink-ga/testlink-code/commit/b77c00bed1044fffa0e0f1d44887b4a4344d9ce9 [^]

- Issue History
Date Modified Username Field Change
2013-05-03 06:19 mknab New Issue
2013-05-03 09:51 mknab Note Added: 0018857
2013-05-03 18:47 fman Note Added: 0018863
2013-05-03 18:47 fman Summary DB Access Error while creating a copy of a testplan => DB Access Error while creating a copy of a PRIVATE testplan
2013-05-03 18:54 fman Assigned To => fman
2013-05-03 18:54 fman Status new => assigned
2013-05-03 19:33 fman Steps to Reproduce Updated View Revisions
2013-05-03 19:35 fman QA Team - Task Workflow Status TBD => READY FOR TESTING
2013-05-03 19:35 fman Note Added: 0018865
2013-05-03 19:35 fman Status assigned => resolved
2013-05-03 19:35 fman Fixed in Version => 1.9.7 (2013 Q2 - bug fixing)
2013-05-03 19:35 fman Resolution open => fixed
2013-05-22 20:57 fman Status resolved => closed



Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker