bug on how to edit forum post
Last Forum Topics -> tiki-view_forum_thread.php -> edit -> tiki-view_forum_thread.php -> ok
Last Forum Post -> tiki-view_forum_thread.php -> edit -> tiki-view_forum.php -> SQL error
first one
calls...
http://evilbk.sourceforge.net/tiki/tiki-view_forum_thread.php?topics_offset=&topics_sort_mode=&topics_threshold=&topics_find=&comments_parentId=25&openpost=1&comments_threadId=26&forumId=8&comments_threshold=0&comments_offset=0&comments_sort_mode=commentDate_asc&comments_maxComments=20
but the second
...
http://evilbk.sourceforge.net/tiki/tiki-view_forum.php?comments_offset=&comments_sort_mode=&comments_threshold=&comments_find=&comments_threadId=26&openpost=1&forumId=8&comments_maxComments=20
producing...
Warning: mysql error: You have an error in your SQL syntax near 'threadId` LIMIT ,20' at line 10 in query:
select a.`threadId`,a.`object`,a.`objectType`,a.`parentId`, a.`userName`,a.`commentDate`,a.`hits`,a.`type`,a.`points`, a.`votes`,a.`average`,a.`title`,a.`data`,a.`hash`,a.`user_ip`, a.`summary`,a.`smiley`,a.`message_id`,a.`in_reply_to`,a.`comment_rating`, IFNULL(max(b.`commentDate`), a.`commentDate`) as `lastPost`, count(b.`threadId`) as `replies` from `tiki_comments` a left join `tiki_comments` b on b.`parentId`=a.`threadId` where a.`object`=? and a.`type` = ? and a.`objectType` = 'forum' and a.`parentId` = ? group by a.`threadId`,a.`object`,a.`objectType`,a.`parentId`,a.`userName`,a.`commentDate`,a.`hits`,a.`type`,a.`points`,a.`votes`,a.`average`,a.`title`,a.`data`,a.`hash`,a.`user_ip`,a.`summary`,a.`smiley`,a.`message_id`,a.`in_reply_to`,a.`comment_rating` order by `, `threadId`
in /home/groups/e/ev/evilbk/htdocs/tiki/lib/tikidblib.php on line 129
Values:
Array ( [0] => 8 [1] => s [2] => 0 )
$result is false
$result is empty