Forums / Cotonti / Bugs / Bug in the search extension when selecting specific date

Sienna 0.9.11 - Search extension

When setting a specific time range to search within you recieve an SQL error:

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 <= 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 <=  AND (page_title LIKE '%Cotonti%' OR page_desc LIKE '%Cotonti%'' at line 3) called at [/xxxxxxxxxxxxxx/public_html/system/database.php:457]
#1  CotDB->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 <> 'system' AND page_begin <= 1347818955 AND (page_expire = 0 OR page_expire > 1347818955) AND page_date >=  AND page_date <=  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]

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.

Added 6 days later:

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.

Added 4 days later:

Ok, than it must be me. I will simply remove the "specific time range" selector so people can not see it.
Maybe it will get fixed, maybe not cause it does not need fixing at all.