deselect topic title and you will get an error
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%') AND p.fp_topicid=t.ft_id AND p.fp_sectionid=s.fs_id 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] Cotonti 2010-04-25 09:11 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-" />
Відредаговано: foxhound (01.05.2010 02:46, 13 років тому)
The Search plugin will be modified heavily for Siena - the problem is likely to be fixed also.
Seditio.by - создание сайтов, разработка плагинов и тем для Котонти