Error in SQL request submitted by the "search" button in menu od dev.tikiwiki - Same error as item : 3104
- Status
- Closed
- Subject
- Error in SQL request submitted by the "search" button in menu od dev.tikiwiki - Same error as item : 3104
- Category
- Error
- Dogfood on a *.tiki.org site
- Feature
- All / Undefined
Search - Resolution status
- Out of Date
- Submitted by
- Bernard TREMBLAY
- Lastmod by
- Ushindi Gedeon
- Rating
- Description
Hello,
I just submit a new search, the SQL request crashes with "system error" as reported in item 3104.
This seems to be solved a few days ago, but it was not a full solution.
Here beyond the beginning of the request :SELECT tti.*, ttif.`value`, ttf.`type`, sttif.`value` 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`) LEFT JOIN (`tiki_tracker_item_fields` sttif) ON (tti.`itemId` = sttif.`itemId` AND sttif.`fieldId` = 41) INNER JOIN `tiki_tracker_item_fields` ttif0 ON (ttif0.`itemId` = ttif.`itemId`) INNER JOIN `tiki_objects` tob43 ON (tob43.`itemId` = tti.`itemId`) INNER JOIN `tiki_category_objects` tco43 ON (tob43.`objectId` = tco43.`catObjectId`) INNER JOIN `tiki_tracker_item_fields` ttif1 ON (ttif1.`itemId` = ttif0.`itemId`) INNER JOIN `tiki_objects` tob47 ON (tob47.`itemId` = tti.`itemId`) INNER JOIN `tiki_category_objects` tco47 ON (tob47.`objectId` = tco47.`catObjectId`) WHERE tti.`trackerId` = ? and (`status`=? or `status`=?) AND ttif0.`fieldId`=? AND tob43.`type` = 'trackeritem' AND tco43.`categId` IN ( ) AND ttif1.`fieldId`=? AND tob47.`type` = 'trackeritem' AND tco47.`categId` IN ( ) GROUP BY tti.`itemId` ORDER BY `sortvalue` desc...
You can notice that the syntax uses in "IN ()" clause which is not accepted by MYSQL.
Solution, first steps
Check all SQL queries for "IN()" clause and find a bypass anywhere in tikiwiki.
Trebly
- Solution
- Workaround
- Priority
- 25
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 3127
- Created
- Saturday 17 April, 2010 01:45:01 UTC
by Bernard TREMBLAY - LastModif
- Tuesday 02 June, 2026 08:01:14 UTC