Error message with default tracker status in non admin view
Hi,
Just to notify that when other than "open" is selected in "Default status displayed in list mode" at the edit tracker level, anonymous and non admin users with view_tracker permission assigned at the tracker level -group tracker permission assigned to admins only- get error data base query message when trying to view the tracker. See below.
Is this something that has been fixed in a version later than 1.9?
Thanks
Hélène
Message:
An error occured in a database query!
Context:
File /tiki-view_tracker.php
Url /tiki-view_tracker.php?trackerId=3
Query:
select tti.*, ttif.`value`,ttf.`type` from `tiki_tracker_items` tti, `tiki_tracker_item_fields` ttif, `tiki_tracker_fields` ttf where tti.`trackerId`=? and (=?) and tti.`itemId`=ttif.`itemId` and ttf.`fieldId`=ttif.`fieldId` and ttif.`fieldId`=? order by ttif.`value` asc
Values:
0 3
1 19
Message:
Error Message 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 '='19') and tti.`itemId`=ttif.`itemId` and ttf.`fieldId`=ttif.`
Text displayed in the header:
Input Array does not match ?: select tti.*, ttif.`value`,ttf.`type` from `tiki_tracker_items` tti, `tiki_tracker_item_fields` ttif, `tiki_tracker_fields` ttf where tti.`trackerId`=3 and (='19') and tti.`itemId`=ttif.`itemId` and ttf.`fieldId`=ttif.`fieldId` and ttif.`fieldId`=