Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0005117TestLinkRequirement Managementpublic2012-07-31 12:222012-09-01 19:59
Reporterkroop 
Assigned Tofman 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformChromeOSUbuntu 12.04 - LTS 64 bitOS Version3.2.0-27-generic
Product Version1.9.3 (2011 Q3 - bug fixing) 
Fixed in Version1.9.4 (2012 Q3 - bug fixing) 
Summary0005117: After deleting a requirement with a relation there is still a empty dead requirement object
DescriptionAfter deleting a requirement with a relation to an other requirement there is still an empty dead requirement object. It could also be that the Problem is caused by some custom fields.
thanks in advance

google helped to translate ;)
Steps To Reproduce1. creat a new requirement
2. creat an other new requirement
3. relate them with "depends on" relation
4. delete first of the created reqirements
5. it should be deleted but it is not...
Additional InformationError after step 4 after deleting:
 
 ==============================================================================
 DB Access Error - debug_print_backtrace() OUTPUT START
 ==============================================================================
#0 database->exec_query(DELETE FROM requirements WHERE id = 86) called at [/var/www/testlink/lib/functions/requirement_mgr.class.php:633]
#1 requirement_mgr->delete(86) called at [/var/www/testlink/lib/requirements/reqCommands.class.php:384]
0000002 reqCommands->doDelete(stdClass Object ([requirement_id] => 86,[req_spec_id] => ,[containerID] => ,[reqDocId] => ,[req_title] => ,[scope] => ,[reqStatus] => ,[reqType] => ,[countReq] => ,[expected_coverage] => 0,[doAction] => doDelete,[req_id_cbox] => ,[itemSet] => ,[testcase_count] => ,[req_version_id] => ,[copy_testcase_assignment] => ,[relation_id] => ,[relation_source_req_id] => ,[relation_type] => ,[relation_destination_req_doc_id] => ,[relation_destination_testproject_id] => ,[save_rev] => ,[do_save] => ,[log_message] => ,[req_id] => 86,[title] => ,[arrReqIds] => ,[basehref] => http://prueflab/testlink/,[tproject_id] [^] => 25,[tproject_name] => HydraIP,[user_id] => 7,[refreshTree] => 1,[stay_here] => 0), Array ([doAction] => doDelete,[requirement_id] => 86)) called at [/var/www/testlink/lib/requirements/reqEdit.php:57]
 ==============================================================================
 ==============================================================================
 DB Access Error - debug_print_backtrace() OUTPUT START
 ==============================================================================
#0 database->exec_query(DELETE FROM nodes_hierarchy WHERE id = 86) called at [/var/www/testlink/lib/functions/requirement_mgr.class.php:636]
#1 requirement_mgr->delete(86) called at [/var/www/testlink/lib/requirements/reqCommands.class.php:384]
0000002 reqCommands->doDelete(stdClass Object ([requirement_id] => 86,[req_spec_id] => ,[containerID] => ,[reqDocId] => ,[req_title] => ,[scope] => ,[reqStatus] => ,[reqType] => ,[countReq] => ,[expected_coverage] => 0,[doAction] => doDelete,[req_id_cbox] => ,[itemSet] => ,[testcase_count] => ,[req_version_id] => ,[copy_testcase_assignment] => ,[relation_id] => ,[relation_source_req_id] => ,[relation_type] => ,[relation_destination_req_doc_id] => ,[relation_destination_testproject_id] => ,[save_rev] => ,[do_save] => ,[log_message] => ,[req_id] => 86,[title] => ,[arrReqIds] => ,[basehref] => http://prueflab/testlink/,[tproject_id] [^] => 25,[tproject_name] => HydraIP,[user_id] => 7,[refreshTree] => 1,[stay_here] => 0), Array ([doAction] => doDelete,[requirement_id] => 86)) called at [/var/www/testlink/lib/requirements/reqEdit.php:57]
 ==============================================================================
 

Error after clicking on not deleted requirement:

 ==============================================================================
 DB Access Error - debug_print_backtrace() OUTPUT START
 ==============================================================================
#0 database->exec_query(/* Class:cfield_mgr - Method: get_linked_cfields_at_design */ SELECT CF.*,CFTP.display_order,CFTP.location FROM custom_fields CF JOIN cfield_testprojects CFTP ON CFTP.field_id=CF.id JOIN cfield_node_types CFNT ON CFNT.field_id=CF.id AND CFNT.node_type_id=7 WHERE CFTP.testproject_id= AND CFTP.active=1 AND CF.show_on_design=1 AND CF.enable_on_design=1 ORDER BY display_order,CF.id , -1) called at [/var/www/testlink/lib/functions/database.class.php:603]
#1 database->fetchRowsIntoMap(/* Class:cfield_mgr - Method: get_linked_cfields_at_design */ SELECT CF.*,CFTP.display_order,CFTP.location FROM custom_fields CF JOIN cfield_testprojects CFTP ON CFTP.field_id=CF.id JOIN cfield_node_types CFNT ON CFNT.field_id=CF.id AND CFNT.node_type_id=7 WHERE CFTP.testproject_id= AND CFTP.active=1 AND CF.show_on_design=1 AND CF.enable_on_design=1 ORDER BY display_order,CF.id , id) called at [/var/www/testlink/lib/functions/cfield_mgr.class.php:586]
0000002 cfield_mgr->get_linked_cfields_at_design(, 1, , requirement, ) called at [/var/www/testlink/lib/functions/requirement_mgr.class.php:1623]
0000003 requirement_mgr->get_linked_cfields(78, , ) called at [/var/www/testlink/lib/functions/requirement_mgr.class.php:1689]
0000004 requirement_mgr->html_table_of_custom_field_values(78, , 25) called at [/var/www/testlink/lib/requirements/reqView.php:115]
0000005 initialize_gui(database Object ([db] => ADODB_postgres7 Object ([databaseType] => postgres7,[hasLimit] => 1,[ansiOuter] => 1,[charSet] => 1,[dataProvider] => postgres,[hasInsertID] => 1,[_resultid] => Resource id 0000073,[concat_operator] => ||,[metaDatabasesSQL] => select datname from pg_database where datname not in ('template0','template1') order by 1,[metaTablesSQL] => select tablename,'T' from pg_tables where tablename not like 'pg\_%'
    and tablename not in ('sql_features', 'sql_implementation_info', 'sql_languages',
     'sql_packages', 'sql_sizing', 'sql_sizing_profiles')
    union
        select viewname,'V' from pg_views where viewname not like 'pg\_%',[isoDates] => 1,[sysDate] => CURRENT_DATE,[sysTimeStamp] => CURRENT_TIMESTAMP,[blobEncodeType] => C,[metaColumnsSQL] => SELECT a.attname,t.typname,a.attlen,a.atttypmod,a.attnotnull,a.atthasdef,a.attnum
        FROM pg_class c, pg_attribute a,pg_type t
        WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s')) and a.attname not like '....%%'
AND a.attnum > 0 AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum,[metaColumnsSQL1] => SELECT a.attname, t.typname, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, a.attnum
FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n
WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s'))
 and c.relnamespace=n.oid and n.nspname='%s'
    and a.attname not like '....%%' AND a.attnum > 0
    AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum,[metaKeySQL] => SELECT ic.relname AS index_name, a.attname AS column_name,i.indisunique AS unique_key, i.indisprimary AS primary_key
    FROM pg_class bc, pg_class ic, pg_index i, pg_attribute a WHERE bc.oid = i.indrelid AND ic.oid = i.indexrelid AND (i.indkey[0] = a.attnum OR i.indkey[1] = a.attnum OR i.indkey[2] = a.attnum OR i.indkey[3] = a.attnum OR i.indkey[4] = a.attnum OR i.indkey[5] = a.attnum OR i.indkey[6] = a.attnum OR i.indkey[7] = a.attnum) AND a.attrelid = bc.oid AND bc.relname = '%s',[hasAffectedRows] => 1,[true] => TRUE,[false] => FALSE,[fmtDate] => 'Y-m-d',[fmtTimeStamp] => 'Y-m-d H:i:s',[hasMoveFirst] => 1,[hasGenID] => 1,[_genIDSQL] => SELECT NEXTVAL('%s'),[_genSeqSQL] => CREATE SEQUENCE %s START %s,[_dropSeqSQL] => DROP SEQUENCE %s,[metaDefaultsSQL] => SELECT d.adnum as num, d.adsrc as def from pg_attrdef d, pg_class c where d.adrelid=c.oid and c.relname='%s' order by d.adnum,[random] => random(),[autoRollback] => 1,[uniqueIisR] => 1,[_bindInputArray] => 1,[disableBlobs] => ,[database] => testlink,[host] => localhost,[user] => testlink,[password] => berlin,[debug] => ,[maxblobsize] => 262144,[substr] => substr,[length] => length,[upperCase] => upper,[replaceQuote] => \',[nameQuote] => ",[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[hasTransactions] => 1,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[poorAffectedRows] => ,[fnExecute] => ,[fnCacheExecute] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id 0000041,[_errorMsg] => ,[_errorCode] => ,[_queryID] => Resource id 0000074,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[version] => Array ([description] => PostgreSQL 9.1.4 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit,[version] => 9.1.4),[pgVersion] => 9.1,[_nestedSQL] => 1),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 20,[overallDuration] => 0.342,[dbType] => postgres,[] => 0,[] => 0), stdClass Object ([requirement_id] => 78,[req_version_id] => ,[showReqSpecTitle] => ,[refreshTree] => 0,[relation_add_result_msg] => ,[req_id] => 78,[tproject_id] => 25,[tproject_name] => HydraIP,[userID] => 7)) called at [/var/www/testlink/lib/requirements/reqView.php:33]
 ==============================================================================
TagsNo tags attached.
Database (MySQL,Postgres,etc)Postgres
BrowserChrome
PHP VersionPHP Version 5.3.10-1ubuntu3.2
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Files

- Relationships

-  Notes
(0017032)
fman (administrator)
2012-07-31 15:08

>> It could also be that the Problem is caused by some custom fields.
Custom fieds used where ?
your steps to reproduce do not include any mention to custom fields
(0017033)
kroop (reporter)
2012-07-31 15:56

Hi fman,
I tryed to reproduce the Error without any custom fields and it still happend. So it is not caused by the custom fields.
(0017306)
fman (administrator)
2012-09-01 19:59

1.9.4 released

- Issue History
Date Modified Username Field Change
2012-07-31 12:22 kroop New Issue
2012-07-31 15:08 fman Note Added: 0017032
2012-07-31 15:08 fman Assigned To => fman
2012-07-31 15:08 fman Status new => feedback
2012-07-31 15:56 kroop Note Added: 0017033
2012-07-31 15:56 kroop Status feedback => assigned
2012-07-31 17:38 fman Status assigned => resolved
2012-07-31 17:38 fman Fixed in Version => 1.9.4 (2012 Q3 - bug fixing)
2012-07-31 17:38 fman Resolution open => fixed
2012-09-01 19:59 fman Note Added: 0017306
2012-09-01 19:59 fman Status resolved => closed



Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker