Wildguzzi.com

General Category => General Discussion => Topic started by: earemike on May 26, 2015, 08:58:58 PM

Title: For admin: search keeps pullng a database error
Post by: earemike on May 26, 2015, 08:58:58 PM

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

Cheers.

Title: Re: For admin: search keeps pullng a database error
Post by: flangeman_70 on June 03, 2015, 03:40:38 AM

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

Title: Re: For admin: search keeps pullng a database error
Post by: Late to the party on June 03, 2015, 10:54:59 AM

Quote from: Flangeman on June 03, 2015, 03:40:38 AM

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

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

Lateness.

Title: Re: For admin: search keeps pullng a database error
Post by: rocker59 on June 03, 2015, 11:00:48 AM

Please read these posts from LUAP:

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

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

Title: Re: For admin: search keeps pullng a database error
Post by: dan_s on June 03, 2015, 11:07:14 AM

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.

Title: Re: For admin: search keeps pullng a database error
Post by: Late to the party on June 03, 2015, 11:30:58 AM

"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.

Title: Re: For admin: search keeps pullng a database error
Post by: Luap McKeever on June 03, 2015, 12:20:10 PM

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.

Title: Re: For admin: search keeps pullng a database error
Post by: earemike on June 03, 2015, 06:35:59 PM

Quote from: Flangeman on June 03, 2015, 03:40:38 AM

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

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. :bow: