Oct 8, 2018
It came back Tuesday morning after the report, but, yes, it is down again. Grrrr
Some function in the server is off...I reboot it and it works for a few hours.
Search remains kaput.
Still down as of Jan 17 at 1016 EST.
Trying to search for posted/started threads doesn't work...assume this is related to this issue.
Ok, I have rebooted the server, that got the search function working. I then repaired the tables, checked and analyzed the tables...so far so good. At this point, the fun begins...raw numbers...the database has 223 tables, and is 1.8GiB in size. THIS IS A BIG DATABASE. When I attempted to optimize the database, phpmyadmin spun and loaded a 500 Internal Server Error, an error that the server and browser does not know what happened. My best guess is that it timed out. I then tried to optimize just the posts table, which is 80.5MiB by itself. This made MySQL crash. After restarting MySQL again, the site is upand the search is working again...for now.
And it is down again
Found a php memory error in logs....increased php memory limit
Search is up
If the problem is tied to the immense size of the database, is there a way to have the search function ignore a portion of the oldest posts? I'm thinking that I'd rather be able to search for newer posts only than not be able to search at all. (I don't know anything about databases! )
It might be a software problem, or the size of the DB....the problem with a table as large as the posts is that you have to query it for every post. In all honesty, I am surprised that the site loads as fast as it does. Also, there's no way to limit the search to a timeframe.
10:16 Mountain Time and the search works....I made no changes...
02:07 MST search bar working here too.
Just used it. Worked fine.
And it failed at 8:34 AM MST
This is beginning to remind me about a glitch we had, with the old software.
Just used it to find a topic from last summer. Worked just fine for me.