Hi,
I have uncomment links between risk/action and issue, and all is working fine, but i have an error message in log file :
2014-11-05 23:09:12 ** ERROR ** Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 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
2014-11-05 23:09:12 ** ERROR ** For query : select * from l_link where ref1Type='Action' and ref1Id=44 and ref2Type=Issue'
2014-11-05 23:09:12 ** ERROR ** Strack trace :
2014-11-05 23:09:12 ** ERROR ** #0 Sql->query called at [D:wwwpeps_dev_webmodelpersistenceSqlElement.php:1452]
2014-11-05 23:09:12 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [D:wwwpeps_dev_webmodelLink.php:104]
2014-11-05 23:09:12 ** ERROR ** #2 Link->getLinksForObject called at [D:wwwpeps_dev_webmodelpersistenceSqlElement.php:1716]
2014-11-05 23:09:12 ** ERROR ** #3 SqlElement->getSqlElement called at [D:wwwpeps_dev_webmodelpersistenceSqlElement.php:352]
2014-11-05 23:09:12 ** ERROR ** #4 SqlElement->__construct called at [D:wwwpeps_dev_webmodelActionMain.php:85]
2014-11-05 23:09:12 ** ERROR ** #5 ActionMain->__construct called at [D:wwwpeps_dev_webmodelAction.php:14]
2014-11-05 23:09:12 ** ERROR ** #6 Action->__construct called at [D:wwwpeps_dev_webviewobjectDetail.php:2695]
After investigation the bug is because a missing quote in function "getLinksForObject" of link.php
you can solve it by changing line 95 from :
$where=" ref1Type='" . $class . "' and ref1Id=" . Sql::fmtId($obj->id) . " and ref2Type=" . $classLink . "' ";
to
$where=" ref1Type='" . $class . "' and ref1Id=" . Sql::fmtId($obj->id) . " and ref2Type='" . $classLink . "' ";
ProjeQtOr is an exceptionnal tools for managing project; thanks for your work.
Regards.
Hi,
Thanls for reporting the issue and providing the fix in the same time.
Will be included in next version.