http://forum.lowyat.net/index.php?act=Sear...lite=ridiculous

Was searching and came across this error.

This post has been edited by wodenus: Apr 18 2009, 04:52 PM

Attached thumbnail(s)

Can you tell me all the search parameters?

This can happen because our search index is updated offline, so it isn't in perfect sync with the database.

Okay screenshot attached.

mySQL query error: SELECT SQL_NO_CACHE t.*, t.posts as topic_posts, t.title as topic_title, p.pid, p.author_id, p.author_name, p.post_date, p.post, m.*, me.*
FROM ibf_topics t
LEFT JOIN ibf_posts p ON (t.tid=p.topic_id AND p.new_topic=1)
LEFT JOIN ibf_members m ON (m.id=p.author_id)
LEFT JOIN ibf_member_extra me ON (me.id=p.author_id)
WHERE t.tid IN()
ORDER BY p.pid DESC
LIMIT 0,25

mySQL 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 ')
ORDER BY p.pid DESC
LIMIT 0,25' at line 6
mySQL error code:
Date: Saturday 18th 2009f April 2009 05:12:10 PM

Checked and found some code that didn't check for the case where there aren't results with that particular combo of options. Fixed, thanks.

Oh hummm.. it's not actually fixed yet Right now if you use "search in titles" and "view results by posts", it actually searches within posts. I'll fix that.. one day. Lemme put this in the accepted feature requests.

wK, it appears as well that new topic would not be "searchable"