I get this error DB Access Error when I click on the tab for Assign Test Plan Role from User Management. I was working using an administrative account. Please see below (The error below was clipped because of this "Your message contains 1079337 characters. The maximum number of allowed characters is 60000." So I had to trim it down, please let me know if I need to send the whole thing).
The project I am working on has no Test Plan set, yet.
I believe testlink was not able to handle this error in a nicer way.
Is there a way to work on this out?
Please advice.
Thanks,
Eljun
DB Access Error - debug_print_backtrace() OUTPUT START
==============================================================================
#0 database->exec_query(/* Class:testplan - Method: get_by_id */ SELECT testplans.*,NH.name,NH.parent_id FROM TLtestplans testplans, TLnodes_hierarchy NH WHERE testplans.id = NH.id AND testplans.id = , -1) called at [C:\wamp\www\ESSQA\lib\functions\database.class.php:711]
#1 database->get_recordset(/* Class:testplan - Method: get_by_id */ SELECT testplans.*,NH.name,NH.parent_id FROM TLtestplans testplans, TLnodes_hierarchy NH WHERE testplans.id = NH.id AND testplans.id = ) called at [C:\wamp\www\ESSQA\lib\functions\testplan.class.php:352]
#2 testplan->get_by_id() called at [C:\wamp\www\ESSQA\lib\functions\roles.inc.php:310]
#3 get_tplan_effective_role(database Object ([db] => ADODB_mysql Object ([databaseType] => mysql,[dataProvider] => mysql,[hasInsertID] => 1,[hasAffectedRows] => 1,[metaTablesSQL] => SHOW TABLES,[metaColumnsSQL] => SHOW COLUMNS FROM `%s`,[fmtTimeStamp] => 'Y-m-d H:i:s',[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => ,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[nameQuote] => `,[compat323] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table %s,[database] => testlink,[host] => localhost,[user] => testlink,[password] => testlink,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => 'Y-m-d',[true] => 1,[false] => 0,[replaceQuote] => \',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[ansiOuter] => ,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #41,[_errorMsg] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1,[_errorCode] => ,[_queryID] => Resource id #130,[_isPersistentConnection] => ,[_bindInputArray] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 79,[overallDuration] => 0.045,[] => 0,[] => 0), , Array ([id] => 23,[notes] =>
,[color] => ,[active] => 1,[option_reqs] => 0,[option_priority] => 0,[option_automation] => 0,[options] => O:8:"stdClass":4:{s:19:"requirementsEnabled";i:1;s:19:"testPriorityEnabled";i:1;s:17:"automationEnabled";i:1;s:16:"inventoryEnabled";i:1;},[prefix] => RM,[tc_counter] => 0,[is_public] => 0,[name] => Requirements Management Engineering,[opt] => stdClass Object ([requirementsEnabled] => 1,[testPriorityEnabled] => 1,[automationEnabled] => 1,[inventoryEnabled] => 1)), , Array ([1] => tlUser Object ([] => TLusers,[firstName] => Testlink,[lastName] => Administrator,[emailAddress] =>
==============================================================================