FORUM ISSUES LATELY ! ! !

[johnoly99]

Hey guys,

John here. I've been playing IT/Systems admin on the forum for a while. Can you all tell It's not my strong suit? Well, I think I've managed to bugger it up pretty good, and find ways to bring it back to life now.


As of this morning, looks like the search function is back up and working better than ever! If you could let me know what you guys see on your end, that would be great.

The posting issues with error screens seem to be taken care of now too, it was a botched update from an older phpBB install to the newest version, my bad!


If you notice anything else, post here and let me know

Thanks guys
John Oly

[JohnStack]

Congrats on sniffing out and finding the problem!

[Jimustanguitar]

Yay! You can search for anything now without having the search keyword ignored and having to use google to find it for you!

[kbob]

Thank you!

[626Pilot]

I used to do this stuff for a living (still do sometimes.) If you post the table definitions (maybe put it in a text file, it will be large) I can recommend some indexes to add to your tables, if they aren't already there. Indexes can make querying information out of the database run dozens to hundreds of times faster in some scenarios. Also, if you haven't converted your tables to InnoDB that's worth looking into as well. By default this forum is probably running on MyISAM tables, which are slow.

With a well-tuned database server, you should be able to set the fulltext minimum word length to 2 characters and remove all the stuff from the list of words it won't search for.