Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007822TestLinkCustom fieldspublic2017-01-25 10:392017-02-15 12:38
ReporterabIng 
Assigned To 
PrioritynormalSeverityblockReproducibilityalways
StatusnewResolutionopen 
PlatformOSwindowsOS Version
Product Version1.9.16 (2016 Q4) 
Fixed in Version 
Summary0007822: Crash while creating radio custom field
DescriptionI create a custom field of type radio - see attached screenshot.
It is the exact copy of custom field that I used with 1.9.14.

The error message on the screen is:
 ==============================================================================
 DB Access Error - debug_print_backtrace() OUTPUT START
 ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200)
            Having this additional Information could be useful for reporting
            issue to development TEAM.
 ==============================================================================
#0 database->exec_query(/* Class:cfield_mgr - Method: create */ INSERT INTO cfield_node_types (field_id,node_type_id) VALUES(,3) ) called at [D:\Web\testlink-1.9.16\lib\functions\cfield_mgr.class.php:1313]
#1 cfield_mgr->create(Array ([name] => Kind Of Test,[label] => Kind Of Test,[node_type_id] => 3,[type] => 9,[possible_values] => Functionnal|Technical,[enable_on] => design,[show_on_execution] => 0,[show_on_design] => 1,[enable_on_design] => 1,[enable_on_execution] => 0,[show_on_testplan_design] => 0,[enable_on_testplan_design] => 0)) called at [D:\Web\testlink-1.9.16\lib\cfields\cfieldsEdit.php:301]
0000002 doCreate(Array ([CSRFName] => CSRFGuard_882150350,[CSRFToken] => 9929de108cafd294065428379d0fbad127ce26a0b36ed148fbcf2c26546aafbba9cd05a044824ee133b0d9b21207bebdf4be5ae755ea9648b205bae8da4498b6,[cfield_id] => 0,[cf_name] => Kind Of Test,[cf_label] => Kind Of Test,[cf_node_type_id] => 3,[cf_type] => 9,[cf_possible_values] => Functionnal|Technical,[cf_enable_on] => design,[cf_show_on_execution] => 0,[do_action] => do_add_and_assign,[do_add_and_assign] => Add and assign (to current test project)), cfield_mgr Object ([db] => database Object ([db] => ADODB_mssqlnative Object ([databaseType] => mssqlnative,[dataProvider] => mssqlnative,[replaceQuote] => '',[fmtDate] => 'Y-m-d',[fmtTimeStamp] => 'Y-m-d\TH:i:s',[hasInsertID] => 1,[substr] => substring,[length] => len,[hasAffectedRows] => 1,[poorAffectedRows] => ,[metaDatabasesSQL] => select name from sys.sysdatabases where name <> 'master',[metaTablesSQL] => select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE','dtproperties')),[metaColumnsSQL] => select c.name,
        t.name as type,
        c.length,
        c.xprec as precision,
        c.xscale as scale,
        c.isnullable as nullable,
        c.cdefault as default_value,
        c.xtype,
        t.length as type_length,
        sc.is_identity
        from syscolumns c
        join systypes t on t.xusertype=c.xusertype
        join sysobjects o on o.id=c.id
        join sys.tables st on st.name=o.name
        join sys.columns sc on sc.object_id = st.object_id and sc.name=c.name
        where o.name='%s',[hasTop] => top,[hasGenID] => 1,[sysDate] => convert(datetime,convert(char,GetDate(),102),102),[sysTimeStamp] => GetDate(),[maxParameterLen] => 4000,[arrayClass] => ADORecordSet_array_mssqlnative,[uniqueSort] => 1,[leftOuter] => *=,[rightOuter] => =*,[ansiOuter] => 1,[identitySQL] => select SCOPE_IDENTITY(),[uniqueOrderBy] => 1,[_bindInputArray] => 1,[_dropSeqSQL] => drop table %s,[connectionInfo] => Array (),[cachedSchemaFlush] => ,[sequences] => ,[mssql_version] => ,[database] => CODBTLK_16,[host] => COQLSQLIN4\COQLSQLIN4,[user] => couatlk,[password] => not stored,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[random] => rand(),[upperCase] => upper,[true] => 1,[false] => 0,[nameQuote] => ",[charSet] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasLimit] => ,[readOnly] => ,[hasMoveFirst] => ,[hasTransactions] => 1,[genID] => 0,[raiseErrorFn] => ,[isoDates] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 3,[null2null] => null,[bulkBind] => ,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id 0000058,[_errorMsg] => ,[_errorCode] => ,[_queryID] => Resource id #77,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[] => Array ()),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 0,[overallDuration] => 0,[dbType] => mssql,[] => 0,[] => 0),[tree_manager] => tree Object ([node_types] => Array ([1] => testproject,[2] => testsuite,[3] => testcase,[4] => tcversion,[5] => testplan,[6] => requirement_spec,[7] => requirement,[8] => req_version,[9] => testcase_step,[10] => req_revision,[11] => requirement_spec_revision,[12] => build),[class_name] => Array ([1] => testproject,[2] => testsuite,[3] => testcase,[4] => ,[5] => testplan,[6] => requirement_spec_mgr,[7] => requirement_mgr,[8] => ,[9] => ,[10] => ,[11] => ,[12] => ),[nodeWithoutClass] => Array ([11] => deleted when reqspec is deleted),[node_descr_id] => Array ([testproject] => 1,[testsuite] => 2,[testcase] => 3,[tcversion] => 4,[testplan] => 5,[requirement_spec] => 6,[requirement] => 7,[req_version] => 8,[testcase_step] => 9,[req_revision] => 10,[requirement_spec_revision] => 11,[build] => 12),[node_tables_by] => Array ([id] => Array ([1] => testprojects,[2] => testsuites,[5] => testplans,[3] => testcases,[4] => tcversions,[6] => req_specs,[7] => requirements,[8] => req_versions,[10] => req_versions,[11] => req_specs_revisions),[name] => Array ([testproject] => testprojects,[testsuite] => testsuites,[testplan] => testplans,[testcase] => testcases,[tcversion] => tcversions,[requirement_spec] => req_specs,[requirement] => requirements,[req_version] => req_versions,[req_revision] => req_versions,[requirement_spec_revision] => req_specs_revisions)),[node_tables] => Array ([testproject] => testprojects,[testsuite] => testsuites,[testplan] => testplans,[testcase] => testcases,[tcversion] => tcversions,[requirement_spec] => req_specs,[requirement] => requirements,[req_version] => req_versions,[req_revision] => req_versions,[requirement_spec_revision] => req_specs_revisions),[ROOT_NODE_TYPE_ID] => 1,[ROOT_NODE_PARENT_ID] => ,[db] => database Object ([db] => ADODB_mssqlnative Object ([databaseType] => mssqlnative,[dataProvider] => mssqlnative,[replaceQuote] => '',[fmtDate] => 'Y-m-d',[fmtTimeStamp] => 'Y-m-d\TH:i:s',[hasInsertID] => 1,[substr] => substring,[length] => len,[hasAffectedRows] => 1,[poorAffectedRows] => ,[metaDatabasesSQL] => select name from sys.sysdatabases where name <> 'master',[metaTablesSQL] => select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE','dtproperties')),[metaColumnsSQL] => select c.name,
        t.name as type,
        c.length,
        c.xprec as precision,
        c.xscale as scale,
        c.isnullable as nullable,
        c.cdefault as default_value,
        c.xtype,
        t.length as type_length,
        sc.is_identity
        from syscolumns c
        join systypes t on t.xusertype=c.xusertype
        join sysobjects o on o.id=c.id
        join sys.tables st on st.name=o.name
        join sys.columns sc on sc.object_id = st.object_id and sc.name=c.name
        where o.name='%s',[hasTop] => top,[hasGenID] => 1,[sysDate] => convert(datetime,convert(char,GetDate(),102),102),[sysTimeStamp] => GetDate(),[maxParameterLen] => 4000,[arrayClass] => ADORecordSet_array_mssqlnative,[uniqueSort] => 1,[leftOuter] => *=,[rightOuter] => =*,[ansiOuter] => 1,[identitySQL] => select SCOPE_IDENTITY(),[uniqueOrderBy] => 1,[_bindInputArray] => 1,[_dropSeqSQL] => drop table %s,[connectionInfo] => Array (),[cachedSchemaFlush] => ,[sequences] => ,[mssql_version] => ,[database] => CODBTLK_16,[host] => COQLSQLIN4\COQLSQLIN4,[user] => couatlk,[password] => not stored,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[random] => rand(),[upperCase] => upper,[true] => 1,[false] => 0,[nameQuote] => ",[charSet] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasLimit] => ,[readOnly] => ,[hasMoveFirst] => ,[hasTransactions] => 1,[genID] => 0,[raiseErrorFn] => ,[isoDates] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 3,[null2null] => null,[bulkBind] => ,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id 0000058,[_errorMsg] => ,[_errorCode] => ,[_queryID] => Resource id #77,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[] => Array ()),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 0,[overallDuration] => 0,[dbType] => mssql,[] => 0,[] => 0),[] => 58887ea24f008441968666,[] => ,[] => ,[] => ,[] => Array ([assignment_status] => assignment_status,[assignment_types] => assignment_types,[attachments] => attachments,[builds] => builds,[cfield_build_design_values] => cfield_build_design_values,[cfield_design_values] => cfield_design_values,[cfield_execution_values] => cfield_execution_values,[cfield_node_types] => cfield_node_types,[cfield_testplan_design_values] => cfield_testplan_design_values,[cfield_testprojects] => cfield_testprojects,[custom_fields] => custom_fields,[db_version] => db_version,[events] => events,[execution_bugs] => execution_bugs,[execution_tcsteps] => execution_tcsteps,[executions] => executions,[inventory] => inventory,[issuetrackers] => issuetrackers,[testproject_issuetracker] => testproject_issuetracker,[keywords] => keywords,[milestones] => milestones,[node_types] => node_types,[nodes_hierarchy] => nodes_hierarchy,[object_keywords] => object_keywords,[platforms] => platforms,[plugins] => plugins,[plugins_configuration] => plugins_configuration,[req_coverage] => req_coverage,[req_relations] => req_relations,[req_specs] => req_specs,[req_specs_revisions] => req_specs_revisions,[reqmgrsystems] => reqmgrsystems,[testproject_reqmgrsystem] => testproject_reqmgrsystem,[requirements] => requirements,[req_versions] => req_versions,[req_revisions] => req_revisions,[req_notify_assignments] => req_notify_assignments,[req_monitor] => req_monitor,[rights] => rights,[risk_assignments] => risk_assignments,[role_rights] => role_rights,[roles] => roles,[testcase_relations] => testcase_relations,[tcversions] => tcversions,[tcsteps] => tcsteps,[testcase_keywords] => testcase_keywords,[testplan_platforms] => testplan_platforms,[testplan_tcversions] => testplan_tcversions,[testplans] => testplans,[testprojects] => testprojects,[testsuites] => testsuites,[text_templates] => text_templates,[transactions] => transactions,[user_assignments] => user_assignments,[user_group] => user_group,[user_group_assign] => user_group_assign,[user_testplan_roles] => user_testplan_roles,[user_testproject_roles] => user_testproject_roles,[users] => users),[] => Array ([tcversions_last_active] => tcversions_last_active,[last_executions] => last_executions,[last_executions_by_platforms] => last_executions_by_platforms),[] => stdClass Object ([eventSource] => GUI,[logEnabled] => 1),[object_table] => nodes_hierarchy),[application_areas] => Array ([0] => execution,[1] => design,[2] => testplan_design),[custom_field_types] => Array ([0] => string,[1] => numeric,[2] => float,[4] => email,[5] => checkbox,[6] => list,[7] => multiselection list,[8] => date,[9] => radio,[10] => datetime,[20] => text area,[500] => script,[501] => server),[possible_values_cfg] => Array ([string] => 0,[numeric] => 0,[float] => 0,[email] => 0,[checkbox] => 1,[list] => 1,[multiselection list] => 1,[date] => 0,[radio] => 1,[datetime] => 0,[text area] => 0,[script] => 0,[server] => 0),[node_types] => Array ([0] => build,[1] => testsuite,[2] => testplan,[3] => testcase,[4] => requirement_spec,[5] => requirement),[locations] => Array ([testcase] => Array ([1] => standard_location,[2] => before_steps_results)),[enable_on_cfg] => Array ([execution] => Array ([build] => 0,[testsuite] => 0,[testplan] => 0,[testcase] => 1,[requirement_spec] => 0,[requirement] => 0),[design] => Array ([build] => 0,[testsuite] => 0,[testplan] => 0,[testcase] => 1,[requirement_spec] => 0,[requirement] => 0),[testplan_design] => Array ([build] => 0,[testsuite] => 0,[testplan] => 0,[testcase] => 1,[requirement_spec] => 0,[requirement] => 0)),[show_on_cfg] => Array ([execution] => Array ([testsuite] => 1,[testplan] => 1,[testcase] => 1,[build] => 1,[requirement_spec] => 0,[requirement] => 0),[design] => Array ([testsuite] => 1,[testplan] => 1,[testcase] => 1,[build] => 0,[requirement_spec] => 0,[requirement] => 0),[testplan_design] => Array ([testsuite] => 1,[testplan] => 1,[testcase] => 1,[build] => 0,[requirement_spec] => 0,[requirement] => 0)),[name_prefix] => custom_field_,[sizes] => Array ([string] => 100,[numeric] => 10,[float] => 10,[email] => 100,[list] => 1,[multiselection list] => 5,[text area] => Array ([rows] => 6,[cols] => 80),[script] => 100,[server] => 100),[max_length_value] => 255,[max_length_possible_values] => 255,[decode] => Array ([nodes] => Array ([testproject] => 1,[testsuite] => 2,[testcase] => 3,[testcase_version] => 4,[testplan] => 5,[requirement_spec] => 6,[requirement] => 7,[requirement_version] => 8,[testcase_step] => 9,[requirement_revision] => 10,[requirement_spec_revision] => 11,[build] => 12,[platform] => 13,[user] => 14)),[html_date_input_suffix] => Array ([input] => 1,[hour] => 1,[minute] => 1,[second] => 1),[] => 58887ea24f008883260439,[] => ,[] => ,[] => ,[] => Array ([assignment_status] => assignment_status,[assignment_types] => assignment_types,[attachments] => attachments,[builds] => builds,[cfield_build_design_values] => cfield_build_design_values,[cfield_design_values] => cfield_design_values,[cfield_execution_values] => cfield_execution_values,[cfield_node_types] => cfield_node_types,[cfield_testplan_design_values] => cfield_testplan_design_values,[cfield_testprojects] => cfield_testprojects,[custom_fields] => custom_fields,[db_version] => db_version,[events] => events,[execution_bugs] => execution_bugs,[execution_tcsteps] => execution_tcsteps,[executions] => executions,[inventory] => inventory,[issuetrackers] => issuetrackers,[testproject_issuetracker] => testproject_issuetracker,[keywords] => keywords,[milestones] => milestones,[node_types] => node_types,[nodes_hierarchy] => nodes_hierarchy,[object_keywords] => object_keywords,[platforms] => platforms,[plugins] => plugins,[plugins_configuration] => plugins_configuration,[req_coverage] => req_coverage,[req_relations] => req_relations,[req_specs] => req_specs,[req_specs_revisions] => req_specs_revisions,[reqmgrsystems] => reqmgrsystems,[testproject_reqmgrsystem] => testproject_reqmgrsystem,[requirements] => requirements,[req_versions] => req_versions,[req_revisions] => req_revisions,[req_notify_assignments] => req_notify_assignments,[req_monitor] => req_monitor,[rights] => rights,[risk_assignments] => risk_assignments,[role_rights] => role_rights,[roles] => roles,[testcase_relations] => testcase_relations,[tcversions] => tcversions,[tcsteps] => tcsteps,[testcase_keywords] => testcase_keywords,[testplan_platforms] => testplan_platforms,[testplan_tcversions] => testplan_tcversions,[testplans] => testplans,[testprojects] => testprojects,[testsuites] => testsuites,[text_templates] => text_templates,[transactions] => transactions,[user_assignments] => user_assignments,[user_group] => user_group,[user_group_assign] => user_group_assign,[user_testplan_roles] => user_testplan_roles,[user_testproject_roles] => user_testproject_roles,[users] => users),[] => Array ([tcversions_last_active] => tcversions_last_active,[last_executions] => last_executions,[last_executions_by_platforms] => last_executions_by_platforms),[] => stdClass Object ([eventSource] => GUI,[logEnabled] => 1),[object_table] => custom_fields), stdClass Object ([do_action] => do_add_and_assign,[cfield_id] => 0,[cf_name] => Kind Of Test,[tproject_id] => 1)) called at [D:\Web\testlink-1.9.16\lib\cfields\cfieldsEdit.php:61]

The log contains:
[>>][58887ea24f008473315755][DEFAULT][/testlink-1.9.16/lib/cfields/cfieldsEdit.php][17/Jan/25 10:32:02]
    [17/Jan/25 10:32:02][WARNING][9u03puhst3fu4a88de72dlk7q1][GUI]
        E_NOTICE
Undefined property: ADODB_mssqlnative::$lastInsertID - in D:\Web\testlink-1.9.16\third_party\adodb\drivers\adodb-mssqlnative.inc.php - Line 197
    [17/Jan/25 10:32:02][WARNING][9u03puhst3fu4a88de72dlk7q1][GUI]
        E_NOTICE
Undefined property: ADODB_mssqlnative::$lastInsertID - in D:\Web\testlink-1.9.16\third_party\adodb\drivers\adodb-mssqlnative.inc.php - Line 197
    [17/Jan/25 10:32:02][ERROR][9u03puhst3fu4a88de72dlk7q1][DATABASE]
        ERROR ON exec_query() - database.class.php
102 - SQLState: 42000
Error Code: 102
Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near ','.
SQLState: 42000
Error Code: 102
Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near ','.
 - /* Class:cfield_mgr - Method: create */ INSERT INTO cfield_node_types (field_id,node_type_id) VALUES(,3)
THE MESSAGE : /* Class:cfield_mgr - Method: create */ INSERT INTO cfield_node_types (field_id,node_type_id) VALUES(,3)
Query failed: errorcode[102]
    errormsg:SQLState: 42000
Error Code: 102
Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near ','.
 
[<<][58887ea24f008473315755][DEFAULT][/testlink-1.9.16/lib/cfields/cfieldsEdit.php][17/Jan/25 10:32:02][17/Jan/25 10:32:02][took 0.0156 secs]
TagsNo tags attached.
Database (MySQL,Postgres,etc)MS SQL
Browser
PHP Version
TestCaseID
QA Team - Task Workflow Status
Attached Filespng file icon testlink-define-custom-field-kind-of-test.PNG [^] (34,125 bytes) 2017-01-25 10:41

- Relationships

-  Notes
(0025995)
abIng (reporter)
2017-02-15 12:38

The problem comes from third_party\adodb\drivers\adodb-mssqlnative.inc.php
I replaced the directory third_party\adodb by the same directory from 1.9.14, and after this it works properly.
I am not sure that it is the best solution, but it works.

- Issue History
Date Modified Username Field Change
2017-01-25 10:39 abIng New Issue
2017-01-25 10:41 abIng File Added: testlink-define-custom-field-kind-of-test.PNG
2017-02-15 12:38 abIng Note Added: 0025995



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker