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:\www\peps_dev_web\model\persistence\SqlElement.php:1452]
2014-11-05 23:09:12 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [D:\www\peps_dev_web\model\Link.php:104]
2014-11-05 23:09:12 ***** ERROR ***** #2 Link->getLinksForObject called at [D:\www\peps_dev_web\model\persistence\SqlElement.php:1716]
2014-11-05 23:09:12 ***** ERROR ***** #3 SqlElement->getSqlElement called at [D:\www\peps_dev_web\model\persistence\SqlElement.php:352]
2014-11-05 23:09:12 ***** ERROR ***** #4 SqlElement->__construct called at [D:\www\peps_dev_web\model\ActionMain.php:85]
2014-11-05 23:09:12 ***** ERROR ***** #5 ActionMain->__construct called at [D:\www\peps_dev_web\model\Action.php:14]
2014-11-05 23:09:12 ***** ERROR ***** #6 Action->__construct called at [D:\www\peps_dev_web\view\objectDetail.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.
Support us on Capterra
