When setting a specific time range to search within you recieve an SQL error:
PHP
1
2
3
4
5
6
7
8
9
10
11
12
2012-09-16 18:09
SQL error 42000: Syntax error oraccess violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version forthe right syntax to usenear 'AND page_date <= AND (page_title LIKE '%Cotonti%' OR page_desc LIKE '%Cotonti%''at line 3
#0 cot_diefatal(SQL error 42000: Syntax error oraccess violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version forthe right syntax to usenear '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.
