1.10: TRACKERFILTER not working for me (Unknown column 'Array' in 'where clause')
- Status
- Closed
- Subject
- 1.10: TRACKERFILTER not working for me (Unknown column 'Array' in 'where clause')
- Version
- 2.x
- Category
- Error
- Feature
- Trackers
Wiki Plugin (extends basic syntax) - Submitted by
- Xavier de Pedro
- Rating
- Description
1.10 (using cvs from Sept 9th, 2007): TRACKERFILTER not working for me (Unknown column 'Array' in 'where clause')
To reproduce, try selecting any field for the tracker filter here:
http://www.moviments.net/intercanvisarxius/tiki-index.php?page=cercador+ofertesIt produces:
Copy to clipboardAn error occured in a database query! Context: File tiki-index.php Url tiki-index.php?page=cercador+ofertes Query: ^ SELECT tti.*, ttif.`value`, ttf.`type`, tti.`lastModif` 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`) INNER JOIN `tiki_objects` tob13 ON (tob13.`itemId` = tti.`itemId`) INNER JOIN `tiki_category_objects` tco13 ON (tob13.`objectId` = tco13.`catObjectId`) WHERE tti.`trackerId` = ? and (`status`=? or `status`=? or `status`=?) AND ttif0.`fieldId`=? AND tob13.`type` = 'tracker 2' AND tco13.`categId` IN ( 0 ,? ) GROUP BY tti.`itemId` ORDER BY `sortvalue` desc ^ Values: 0 2 1 o 2 p 3 c 4 13 5 Message: Unknown column 'Array' in 'where clause' Builded query was probably: ^ SELECT tti.*, ttif.`value`, ttf.`type`, tti.`lastModif` 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`) INNER JOIN `tiki_objects` tob13 ON (tob13.`itemId` = tti.`itemId`) INNER JOIN `tiki_category_objects` tco13 ON (tob13.`objectId` = tco13.`catObjectId`) WHERE tti.`trackerId` = '2' and (`status`='o' or `status`='p' or `status`='c') AND ttif0.`fieldId`='13' AND tob13.`type` = 'tracker 2' AND tco13.`categId` IN ( 0 ,'Array' ) GROUP BY tti.`itemId` ORDER BY `sortvalue` desc ^
It was happening like that with code from months ago, and that's why I've tried today with updated code from cvs HEAD, plus upgrading db using tiki_1.9to1.10.sql script.
Fixed the 10/9/07
- Importance
- 6
- Priority
- 30
- 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
- 1349
- Created
- Sunday 09 September, 2007 13:39:57 UTC
by Unknown - LastModif
- Tuesday 09 October, 2007 13:06:21 UTC