search function

[DesmoBob]

i think the search function has gone kaput. it gives me this error (search object='poop'):

mySQL query error: SELECT t.tid
* * * FROM forumtopics t
* * * WHERE t.last_post > 1056524257 AND t.forum_id IN (1,2,21,4,5,6,8,32,10,9,11,12,15,13,16,14,18,17,19 ,31,20,22,23,24,25,26,27,28,29,30)
* * * * AND t.approved=1 AND MATCH(title) AGAINST ('poop')

mySQL error: Can't find FULLTEXT index matching the column list
mySQL error code: 1191
Date: Thursday 24th of July 2003 11:57:37 PM

[Ski]

I'll look into it..

[GreenDragon]

HA! Desmo was searching for poop but couldn't find sh*t!! :

[DesmoBob]

[2.link]

I typed poo and it searched but then I typed poop and it didn't work.

<edit>

nvm poo is too short of a word and it doesnt search it...

[Ski]

This was do because of loss of bmw-forums data base when site was down..server upgraded security features before putting up back up file that they had..

As an extra security measure, I continue to update my own personal back up file daily do to any unforeseen circumstances that this ever happens again, which I have been re-assured that it won't, but I will not take any chances this time around..

I however, will try to see if there is a fix to this 'search' problem as I am one stubborn mofo..

[DesmoBob]

[Ski]

This should be fixed in a couple days for those of you having a problem w/ the search feature..

[DesmoBob]

been wondering about that but i came to believe i was the only one with the problem.

[Ski]

Originally posted by DesmoBob@Sep 3 2003, 01:23 AM
been wondering about that but i came to believe i was the only one with the problem.

Nope it's the forum's problem..I've found the root of it and am waiting to hear back from our server via email to re-install some files that are needed..