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.
Check all SQL queries for "IN()" clause and find a bypass anywhere in tikiwiki.
Trebly
The URL for the show2.tiki.org instance that demonstrates this bug is at: http://trebly-10588-3127.show2.tiki.org. Note that if you get a popup asking for a username/password, please just enter "show" and "show". This is different from the initial login and password for a new Tiki which is "admin" and "admin".
For the install log, see http://trebly-10588-3127.show2.tiki.org/info.txt
Note that if you see PHP errors or a Tiki claiming to be missing third party software, the instance creation is probably not finished. Please wait a couple minutes and reload.
Snapshots are database dumps of the configuration that developers can download for debugging. Once you have reproduced your bug on the show2.tiki.org instance, create a snapshot that can then be downloaded by developers for further investigation.
Snapshots can be accessed at: http://trebly-10588-3127.show2.tiki.org/snapshots/. Note that if you get a popup asking for a username/password, please just enter "show" and "show".
Create new snapshotTo help developers solve the bug, we kindly request that you demonstrate your bug on a show.tikiwiki.org instance. To start, simply select a version and click on "Create show.tikiwiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show.tikiwiki.org.
filename | created | hits | comment | version | filetype | ||
---|---|---|---|---|---|---|---|
No attachments for this item |