a bug
Posted: Wed Nov 10, 2010 12:38 pm
can someone please help me and explain me what the problem here:
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 [C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\tl\lib\functions\database.class.php:597]
#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 [C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\tl\lib\functions\cfield_mgr.class.php:572]
#2 cfield_mgr->get_linked_cfields_at_design(, 1, , requirement, ) called at [C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\tl\lib\functions\requirement_mgr.class.php:1429]
#3 requirement_mgr->get_linked_cfields(53, , ) called at [C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\tl\lib\functions\requirement_mgr.class.php:1510]
#4 requirement_mgr->html_table_of_custom_field_values(53, , 42) called at [C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\tl\lib\requirements\reqView.php:99]
#5 initialize_gui(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] => root,[password] => rel123,[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 #49,[_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 'AND CFTP.active=1 AND CF.show_on_design=1 AND CF.enable_on_desig' at line 1,[_errorCode] => ,[_queryID] => Resource id #70,[_isPersistentConnection] => ,[_bindInputArray] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 15,[overallDuration] => 0.2108,[] => 0,[] => 0), stdClass Object ([requirement_id] => 53,[showReqSpecTitle] => ,[relation_add_result_msg] => ,[req_id] => 53,[tproject_id] => 42,[tproject_name] => LPS,[userID] => 1)) called at [C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\tl\lib\requirements\reqView.php:31]
thank you!
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 [C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\tl\lib\functions\database.class.php:597]
#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 [C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\tl\lib\functions\cfield_mgr.class.php:572]
#2 cfield_mgr->get_linked_cfields_at_design(, 1, , requirement, ) called at [C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\tl\lib\functions\requirement_mgr.class.php:1429]
#3 requirement_mgr->get_linked_cfields(53, , ) called at [C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\tl\lib\functions\requirement_mgr.class.php:1510]
#4 requirement_mgr->html_table_of_custom_field_values(53, , 42) called at [C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\tl\lib\requirements\reqView.php:99]
#5 initialize_gui(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] => root,[password] => rel123,[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 #49,[_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 'AND CFTP.active=1 AND CF.show_on_design=1 AND CF.enable_on_desig' at line 1,[_errorCode] => ,[_queryID] => Resource id #70,[_isPersistentConnection] => ,[_bindInputArray] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 15,[overallDuration] => 0.2108,[] => 0,[] => 0), stdClass Object ([requirement_id] => 53,[showReqSpecTitle] => ,[relation_add_result_msg] => ,[req_id] => 53,[tproject_id] => 42,[tproject_name] => LPS,[userID] => 1)) called at [C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\tl\lib\requirements\reqView.php:31]
thank you!