tiki-tracker_view_history.php throwing SQL errors
- Status
- Open
- Subject
- tiki-tracker_view_history.php throwing SQL errors
- Version
- 18.x
- Category
- Error
- Dogfood on a *.tiki.org site
- Feature
- History (wiki, tracker item, sheet...)
- Resolution status
- New
- Submitted by
- drsassafras
- Lastmod by
- drsassafras
- Rating
- Description
tiki-tracker_view_history.php throws some SQL erorrs.
eg.
https://doc.tiki.org/tiki-tracker_view_history.php?itemId=5310
https://doc.tiki.org/tiki-tracker_view_history.php?itemId=6291
--SYSTEM ERROR
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 '' at line 1
The query was:select ttifl.*, ttf.* from `tiki_tracker_item_fields` ttifl left join `tiki_tracker_fields` ttf on (ttf.`fieldId`=ttifl.`fieldId`) where
The built query was likely:select ttifl.*, ttf.* from `tiki_tracker_item_fields` ttifl left join `tiki_tracker_fields` ttf on (ttf.`fieldId`=ttifl.`fieldId`) where
--- 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
- 6568
- Created
- Saturday 10 February, 2018 05:02:07 UTC
by drsassafras - LastModif
- Saturday 10 February, 2018 05:02:07 UTC