2006-09-22, 07:13 PM
Hi,
if I do a simple search for "test" (just an example) and narrow the the timeframe to e.g. the last 2 weeks I get an error because there is an AND missing in the query - at least I guess so:
I just can't find the part in search.php where this AND should be set. Strange enogh - here it does work. I just set 1.2 up...
if I do a simple search for "test" (just an example) and narrow the the timeframe to e.g. the last 2 weeks I get an error because there is an AND missing in the query - at least I guess so:
SELECT t.tid, t.firstpost FROM mybb_threads t WHERE 1=1 A-N-D t.dateline >='-604800' AND t.visible>0 AND t.closed NOT LIKE 'moved|%' AND LOWER(t.subject) LIKE '%test%'
I just can't find the part in search.php where this AND should be set. Strange enogh - here it does work. I just set 1.2 up...