Search Error

[engpro]

An Error Occured
--------------------------------------------------------------------------------
phpBB was unable to query the forums database
The table 'SQL1da57f0_0' is full
SELECT u.user_id,f.forum_id, p.topic_id, u.username, p.post_time,t.topic_title,f.forum_name FROM posts p, posts_text pt, users u, forums f,topics t WHERE ( (t.topic_title LIKE '%pull%' OR t.topic_title LIKE '%down%' OR t.topic_title LIKE '%lists%') OR (pt.post_text LIKE '%pull%' OR pt.post_text LIKE '%down%' OR pt.post_text LIKE '%lists%') ) AND p.post_id = pt.post_id AND p.topic_id = t.topic_id AND p.forum_id = f.forum_id AND p.poster_id = u.user_id AND f.forum_type != 1 ORDER BY p.post_time desc LIMIT 200

 

[Mark O'Brien]

Yup, I've had that. (Usually when I put in more than one search word.) I don't know why it happens.

 

[Von Pookie]

Hi engpro! (edited to add: Hi Mark! )

This is actually quite a common occurance around here. Nothing you did, and not quite anything wrong with the search function, either.

Basically, you entered a search term that wasn't specific enough for the search engine, and it brought back too many results. I believe the search page will only show you the first 100(?).

Try just being a little more specific with your search terms. For example, instead of just looking up "formatting," try looking up the specific thing you want like "cell formatting" or "conditional formatting."

Hope this helps!

_________________<font color=red>~*</font><font color=blue>Kristy</font><font color=red>*~</font>

"Catapultam habeo. Nisi pecuniam omnem mihi dabis, ad caput tuum saxum immane mittam."

</img>
This message was edited by Von Pookie on 2002-06-14 11:53

 

[engpro]

So I should only search one word?

Or, is a fix on the way?

 

[engpro]

Kristy,

You answered my questions before I asked them!

Thanks!

Shannon