Loading...
 
Skip to main content

Features / Usability


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 oneQuestion 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=20Question

but the secondQuestion...
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=20Question

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

Warning: mysql 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 '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 /var/www/html/18cvs/lib/tikidblib.php on line 125
Values:
Array ( 0 => 1 1 => s 2 => 0 )
$result is false
$result is empty

I got this by editing a thread starter. My understanding is that the module used to get there has no importance, but the type of forum post edited. When accessed "normally", the page just before the error has extra REQUEST parameters.