Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Bug in link.php
 
Notifications
Clear all

Bug in link.php

2 Posts
2 Users
0 Reactions
4,680 Views
 BEAU
(@mamath)
Posts: 24
Active Member
Topic starter
 
[#2068]

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.


 
Posted : 06 Nov 2014 1H23
(@babynus)
Posts: 14952
Member Admin
 

Hi,

Thanls for reporting the issue and providing the fix in the same time.

Will be included in next version.


 
Posted : 06 Nov 2014 2H15
Share:

Scroll to Top