Foren / Cotonti / Bugs / Reports / Search in forums only bug?

deselect topic title and you will get an error

foxhound
#1 26. April 2010, 00:13
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
Forums only
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-" />

Dieser Beitrag wurde von foxhound (am 1. Mai 2010, 02:46, vor 13 Jahre) bearbeitet
Kort
#2 1. Mai 2010, 02:58
The Search plugin will be modified heavily for Siena - the problem is likely to be fixed also.
SED.by - создание сайтов, разработка плагинов и тем для Котонти