For admin: search keeps pullng a database error

[earemike]

FYI I keep getting a database error trying to run a search, don't know if it's related to recent issues.

Cheers.

[flangeman_70]

Read the "Welcome back!" post pinned to the top of the forum list.
It clearly states there was/is an issue from the outset 

[Late to the party]

Read the "Welcome back!" post pinned to the top of the forum list.
It clearly states there was/is an issue from the outset 

So, we can assume the search function is still non-functional?

Lateness.

[rocker59]

Please read these posts from LUAP:

http://wildguzzi.com/forum/index.php?topic=76705.0

http://wildguzzi.com/forum/index.php?topic=76717.0

[dan_s]

Luap did write that. You can do a google search in the wildguzzi website if you need to by typing in the search field "site:wildguzzi.com" and after that your search words.

[Late to the party]

"Here's how you can do it:

Go to google and type your search query like this below (without the quotation marks";
"2000 Jackal final drive" site:wildguzzi.com/forum"

Read the first post from Luap. Missed the second one.

Now I got it.

Lateness.

[Luap McKeever]

I am still working on the search. I am configuring it to do an "index" search. This will be a separate Indexed file when a search string is entered.  This dramatically reduces server strain.

Even a simple search like "2001" would crash the server.  The way SQL works is that it would search all one million posts for that search string for the term 2001. Then, it would display the results for you.

An index search means that it would search only that index file (one file versus one million) and display the results for you.  Theoretically, this would reduce server strain by about 90%.  "Theoretically" being the key word there.

The downside to index only searches is that it wont be current until I create a new index.  It may be one of those things I only do about every 6 months or so.  I've been creating an index for 3 days now, and it is only 22% completed.

Google search is a great work around, and if this new search method that I'm working on doesn't bode well, google could just be the way we do it moving forward.  Time will tell.

Stay tuned, and patient.

[earemike]

Read the "Welcome back!" post pinned to the top of the forum list.
It clearly states there was/is an issue from the outset 

Yeah, I posted this *just* before the rebuild when the wheels fell off. I usually  wait but wondered what if everyone waits & no one says anything? Like that would happen in this crowd...

If I'd found the right feedback for admin thread I would have put it there.

For clarity: this post was pre-upgrade. Thanks again to the blokes sinking hours into upgrading this database.