cotonti.com : Search in forums only bug? https://www.cotonti.com Laatste forum onderwerpen Cotonti en Fri, 17 Apr 2026 15:53:45 -0000 Kort Za, 01 Mei 2010 02:58:21 -0000 foxhound 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.]]> Ma, 26 Apr 2010 00:13:47 -0000