I just found this here on this site. I was looking for some info and decided I did not want to search topic titles and only wanted to search the topics.
So, try for yourself:
Search query: comment
Deselect topic titles, search only in posts.
You will get more than 30 matches, pagination is active but no topics show. If you than click to go to page 2 and click to go a page back this error comes up:
#0 sed_diefatal(SQL 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 'LIMIT 0, 30' at line 9) called at [/htdocs/system/database.mysql.php:219]
#1 sed_sql_query(SELECT SQL_CALC_FOUND_ROWS p.fp_id, p.fp_text, t.ft_firstposterid,
t.ft_firstpostername, t.ft_title, t.ft_id, t.ft_updated, s.fs_id, s.fs_title, s.fs_category
FROM sed_forum_posts p, sed_forum_topics t, sed_forum_sections s
WHERE 1 AND (p.fp_text LIKE '%comments%'
OR t.ft_title LIKE '%comments%')
GROUP BY t.ft_id ORDER BY
LIMIT 0, 30) called at [/htdocs/plugins/search/search.php:305]
#2 include_once(/htdocs/plugins/search/search.php) called at [/htdocs/system/core/plug/plug.inc.php:110]
#3 require_once(/htdocs/system/core/plug/plug.inc.php) called at [/htdocs/plug.php:31]
Fatal error : SQL 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 'LIMIT 0, 30' at line 9
If you search all and only deselect "topic titles" it will work.
Thought I should share this bug.Added 5 days later:
I guess this is an IP related bug? Nobody else experiences this? Ah well, I wont bother anymore.
<img src="http://www.armaholic.com/datas/thumbs/green-sea-battalion-uniforms-version-03-preview_4.jpg" alt="green-sea-battalion-uniforms-version-03-" />