View Full Version : Unable to Search
12three45
07-23-2006, 06:16 PM
Trevor, I have been trying to search for things the past few days after the migration and I can't seem to get anything. Did something happen to the database for searches? For example I search for PCV and I get nothing.
Andy
FastCougar
07-23-2006, 10:37 PM
ugg ... I was afraid of this ... FULL-TEXT searching is limited by the database setup and the minimum word length is 4. So, PCV and IAC and all 3 letter acronyms will not return any results. I think I'm going to delete the Full-Text indicies and rebuild the word tables. However, this process is VERY server intensive and pretty much shuts down the boards and will take probably 8+ hours.
scrupul0us
07-24-2006, 11:39 AM
so jsut tack that on to tonights CRON job for after the backup... i think we can all live with the boards being down until lunch tomorrow
FastCougar
07-24-2006, 12:23 PM
Not that simple ... building the new word indexes is done by the forum software and is a URL call from an admin login. This function must be called manually as far as I know.
12three45
07-25-2006, 06:28 PM
Wow, I didn't it was that intensive. Thanks for doing it.
Andy