<?xml version='1.0' encoding='UTF-8'?>
<rss version='2.0'>
	<channel>
		<title>cotonti.com : Bug in the search extension when selecting specific date</title>
		<link>https://www.cotonti.com</link>
		<description>Last topic posts</description>
		<generator>Cotonti</generator>
		<language>en</language>
		<pubDate>Sat, 11 Apr 2026 20:19:52 -0000</pubDate>

		<item>
			<title>foxhound</title>
			<description><![CDATA[<p>
	Sienna 0.9.11 - Search extension</p>
<p>
	When setting a specific time range to search within you recieve an SQL error:</p>
<pre class="brush:php;">
2012-09-16 18:09

SQL error 42000: Syntax error or access violation: 1064 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 'AND page_date &lt;= AND (page_title LIKE '%Cotonti%' OR page_desc LIKE '%Cotonti%'' at line 3

#0  cot_diefatal(SQL error 42000: Syntax error or access violation: 1064 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 'AND page_date &lt;=  AND (page_title LIKE '%Cotonti%' OR page_desc LIKE '%Cotonti%'' at line 3) called at [/xxxxxxxxxxxxxx/public_html/system/database.php:457]
#1  CotDB-&gt;query(SELECT SQL_CALC_FOUND_ROWS p.* 
			FROM cot_pages AS p 
			WHERE page_cat IN ('documentation','documentation_walkthrough','documentation_preview','documentation_review','documentation_cheats','links','events','news','files','files_mods','files_campaigns','files_islands','files_weapons','files_tools') AND page_state = '0' AND page_cat &lt;&gt; 'system' AND page_begin &lt;= 1347818955 AND (page_expire = 0 OR page_expire &gt; 1347818955) AND page_date &gt;=  AND page_date &lt;=  AND (page_title LIKE '%Cotonti%' OR page_desc LIKE '%Cotonti%' OR page_text LIKE '%Cotonti%')
			ORDER BY page_date ASC
			LIMIT 0, 50) called at [/xxxxxxxxxxxxxx/public_html/plugins/search/search.php:287]
#2  include(/xxxxxxxxxxxxxx/public_html/plugins/search/search.php) called at [/xxxxxxxxxxxxxx/public_html/system/plugin.php:99]
#3  require_once(/xxxxxxxxxxxxxx/public_html/system/plugin.php) called at [/xxxxxxxxxxxxxx/public_html/index.php:92]
</pre>
<p>
	 </p>
<p>
	Also I noticed in the configuration settings, wether you set "Type of forum post link to use:" to normal or single the output is always the same. It always outputs the text, never the link only.</p>
<p><strong>Added 6 days later:</strong></p><p>
	Seeing no response at all does that mean the reported error does not happen for anyone else? It happens for me, even with the default install.</p>
<p><strong>Added 4 days later:</strong></p><p>
	Ok, than it must be me. I will simply remove the "specific time range" selector so people can not see it.<br />
	Maybe it will get fixed, maybe not cause it does not need fixing at all.</p>
]]></description>
			<pubDate>Sun, 16 Sep 2012 18:12:01 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/forums?m=posts&q=7100&d=0#post35470]]></link>
		</item>
	</channel>
</rss>