Loading...
 
Skip to main content

error in db query with some param in trackerlist plugin (Tiki 3.3)

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
error in db query with some param in trackerlist plugin (Tiki 3.3)
Version
3.x
Category
  • Error
Feature
Trackers
Wiki Plugin (extends basic syntax)
Resolution status
Fixed or Solved
Submitted by
Ushindi Gedeon
Lastmod by
Ushindi Gedeon
Rating
(0)
Description

I've just created a new page on a tiki 3.3 site with this content:

Copy to clipboard
{TRACKERLIST(trackerId="3",fields="41:42",sort="y",popup="43",stickypopup="n",showtitle="n",showlinks="y",showdesc="n",shownbitems="n",showinitials="n",showstatus="n",showcreated="n",showlastmodif="n",showfieldname="n",status="op",sort_mode="asc",max="15",more="n",moreurl="n",view="user",compute="42/sum:43/avg")}{TRACKERLIST}


That tracker exists, as well as fieldId's 41, 42 and 43.
And it produced this error:

Copy to clipboard
An error occured in a database query!

Context:
File	tiki-index.php
Url	tiki-index.php?page=Gradebook
Query:
SELECT tti.*, ttif.`value`, ttf.`type`, tti.`asc` as `sortvalue` FROM ( `tiki_tracker_items` tti INNER JOIN `tiki_tracker_item_fields` ttif ON tti.`itemId` = ttif.`itemId` INNER JOIN `tiki_tracker_fields` ttf ON ttf.`fieldId` = ttif.`fieldId`) INNER JOIN `tiki_tracker_item_fields` ttif0 ON (ttif0.`itemId` = ttif.`itemId`) WHERE tti.`trackerId` = ? and (`status`=? or `status`=?) AND ttif0.`fieldId`=? AND ttif0.`value`=? GROUP BY tti.`itemId` ORDER BY `sortvalue` asc
Values:
0	3
1	o
2	p
3	41
4	Xavi
Message:
Built query was probably:
SELECT tti.*, ttif.`value`, ttf.`type`, tti.`asc` as `sortvalue` FROM ( `tiki_tracker_items` tti INNER JOIN `tiki_tracker_item_fields` ttif ON tti.`itemId` = ttif.`itemId` INNER JOIN `tiki_tracker_fields` ttf ON ttf.`fieldId` = ttif.`fieldId`) INNER JOIN `tiki_tracker_item_fields` ttif0 ON (ttif0.`itemId` = ttif.`itemId`) WHERE tti.`trackerId` = '3' and (`status`='o' or `status`='p') AND ttif0.`fieldId`='41' AND ttif0.`value`='Xavi' GROUP BY tti.`itemId` ORDER BY `sortvalue` asc



Sorry, just testing once more the issue related to normal users loosing the ability edit their own items

Solution
add help on sort mode values on the helper, and avoid showing that scary db error is some dump user like me writes wrong syntax as sort mode 😎
Workaround
The problem seems to be that I added sort="y", and since the sort_mode was not shown by the helper, then I wrote "asc".
Priority
25
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
2885
Created
Saturday 21 November, 2009 18:05:06 UTC
by Xavier de Pedro
LastModif
Monday 01 June, 2026 17:17:17 UTC


Show PHP error messages