Search database emptied after recent forum meerge?

Red Spire Press · 11th September 2005, 01:47 AM

My searches aren't returning any results. Thought I'd give you a heads up.

Also, I posted another thread in Meta yesterday asking for access to modify my products in the review database (as directed on the review page) and didn't receive a response.

Mark CMG · 11th September 2005, 01:51 AM

I gave it a try and it seemed to work fine. What did you search for? Maybe I should try searching for the same thing and see if the results are the same?

**IronWolf** · 11th September 2005, 01:51 AM

Quote:

Originally Posted by Red Spire Press

My searches aren't returning any results. Thought I'd give you a heads up.

I just did a couple of quick searches ('wizard' and 'rogue') and I received returns from my search. What were you searching on?

Mouseferatu · 11th September 2005, 01:54 AM

Actually, it's not just him. I'm getting search results from three years ago on some topics, but none more recent, even though I know they exist.

Michael Morris · 11th September 2005, 02:09 AM

I just tested search - searching for wizard then ISRP. No problems either way. I didn't dump the post index, though I did add too it as the new posts were made into the ISRP forums.

Red Spire Press · 11th September 2005, 02:16 AM

I do regular searches for "dark legacies" (quotes included) to find topics on our games. Up until the merge, I received pages of results. Now I get zero results.

Michael Morris · 11th September 2005, 02:24 AM

I got this thread as a result.

:shrug:

I dunno. Rebuilding a post index on a forum this size is a nightmarish proposition. It may need to be done though after an upgrade to MySQL allows true full text searching (which requires an rebuild).

But remember, last time I rebuilt the thing it took 3 weeks to complete the rebuild.

Red Spire Press · 11th September 2005, 02:28 AM

Well, not to sound antagonistic, but the reason many people purchased ENWorld community supporter accounts was for search access. I'd expect that if search was broken by a forum update, it would be repaired. Granted, new threads will likely be indexed as they are created, but that doesn't help when searching for archived material.

Michael Morris · 11th September 2005, 02:38 AM

I don't see how (or why) the merge would have affected the search feature other than to index additional posts.

Anyway, I'm not blowing up and reindexing the boards over the next month because a single search isn't working. Try using different search terms or searching for threads and posts which you made yourself.

Mouseferatu · 11th September 2005, 02:52 AM

Quote:

Originally Posted by Spoony Bard

I don't see how (or why) the merge would have affected the search feature other than to index additional posts.

Anyway, I'm not blowing up and reindexing the boards over the next month because a single search isn't working. Try using different search terms or searching for threads and posts which you made yourself.

Hate to tell you, Spoony, but it's not a single search. I've tried a couple of different terms, and it's not working.

For example, I did a search for "Regdar," and got nothing more recent than early 2003. I know he's been mentioned on the boards since then, since one such mention was in a thread two or three days ago, here: Dragon #336

That's just one example. I've seen the same with multiple other searches.

Red Spire Press · 11th September 2005, 03:12 AM

Quote:

Originally Posted by Spoony Bard

I don't see how (or why) the merge would have affected the search feature other than to index additional posts.

Anyway, I'm not blowing up and reindexing the boards over the next month because a single search isn't working. Try using different search terms or searching for threads and posts which you made yourself.

That's quite an unhelpful attitude. As a community supporter, regular poster, and donator to ENWorld, I would expect a lot more understanding. As Ari has mentioned twice now, this is not an isolated issue.

Michael Morris · 11th September 2005, 03:54 AM

Quote:

Originally Posted by Red Spire Press

That's quite an unhelpful attitude. As a community supporter, regular poster, and donator to ENWorld, I would expect a lot more understanding. As Ari has mentioned twice now, this is not an isolated issue.

So you're saying that you'd prefer to see search taken down entirely for a month while the server rebuilds the index with no guarantee that it will help? I can't do that. I have to rebuild the index anyway after the next upgrade to take advantage of some advanced features in the next version of MySQL and vbulletin. Exactly when that will be I don't know. I work on ENWorld in my spare time as an unpaid volunteer.

Red Spire Press · 11th September 2005, 04:00 AM

Quote:

Originally Posted by Spoony Bard

So you're saying that you'd prefer to see search taken down entirely for a month while the server rebuilds the index with no guarantee that it will help? I can't do that. I have to rebuild the index anyway after the next upgrade to take advantage of some advanced features in the next version of MySQL and vbulletin. Exactly when that will be I don't know. I work on ENWorld in my spare time as an unpaid volunteer.

No that's not what I'm saying. All I ask is that I not be dismissed out of hand as I was being, and that perhaps someone look into why it happened. Maybe it's reversible.

Michael Morris · 11th September 2005, 04:10 AM

The only solution to fix a bad post index is to rebuild the thing, a process that took 3 weeks to do the last time it was done -- and not something I want to do unless it becomes absolutely necessary.

**Kid Charlemagne** · 11th September 2005, 04:18 AM

Quote:

Originally Posted by Spoony Bard

I don't see how (or why) the merge would have affected the search feature other than to index additional posts.

Anyway, I'm not blowing up and reindexing the boards over the next month because a single search isn't working. Try using different search terms or searching for threads and posts which you made yourself.

Hate to break it to ya, Spoony, but the only thign older than today seems to be ISRP stuff. Which didn't exist on these boards before today.

I did a search for "Dungeon" and found nothing other than ISRP posts since 01-02-03. I did a search for "Dragon" and got the same date.

Search is fu-bar'ed. Completely.

Mouseferatu · 11th September 2005, 04:22 AM

Quote:

Originally Posted by Spoony Bard

The only solution to fix a bad post index is to rebuild the thing, a process that took 3 weeks to do the last time it was done -- and not something I want to do unless it becomes absolutely necessary.

That's perfectly fair, and understandable. And I think if your first reply had been "Man, I'm sorry you're having problems. I'll try to look into why, but I really don't think I can fix it until the next upgrade," then I imagine tha Red Spire would have been fine with it. I know I would have.

My problem--and I believe his, too--is that your first replies were very dismissive, bordering on hostile. Being told "There shouldn't be a problem, go try something else" is neither helpful nor particularly polite.

Michael Morris · 11th September 2005, 04:25 AM

Quote:

Originally Posted by Kid Charlemagne

Hate to break it to ya, Spoony, but the only thign older than today seems to be ISRP stuff. Which didn't exist on these boards before today.

I did a search for "Dungeon" and found nothing other than ISRP posts since 01-02-03. I did a search for "Dragon" and got the same date.

Search is fu-bar'ed. Completely.

I just ran the same searches and experienced no such problem. Check your settings.

Mouseferatu · 11th September 2005, 04:32 AM

Quote:

Originally Posted by Spoony Bard

I just ran the same searches and experienced no such problem. Check your settings.

Tell me which settings should impact which entries Search finds and which it doesn't, and I'll be happy to check them.

I do know that I haven't changed any of my settings in months, and the problem only cropped up today.

Ankh-Morpork Guard · 11th September 2005, 04:51 AM

Quote:

Originally Posted by Kid Charlemagne

I did a search for "Dungeon" and found nothing other than ISRP posts since 01-02-03. I did a search for "Dragon" and got the same date.

I just did both of those searches and found huge amounts of hits...so many that I didn't feel like scrolling to find old ones.

Michael Morris · 11th September 2005, 04:52 AM

Quote:

Originally Posted by Mouseferatu

That's perfectly fair, and understandable. And I think if your first reply had been "Man, I'm sorry you're having problems. I'll try to look into why, but I really don't think I can fix it until the next upgrade," then I imagine tha Red Spire would have been fine with it. I know I would have.

My problem--and I believe his, too--is that your first replies were very dismissive, bordering on hostile. Being told "There shouldn't be a problem, go try something else" is neither helpful nor particularly polite.

If you want to read things into my responses that aren't there, go right ahead. It's really not my problem. After over 3000 posts I would hope you would have learned that messageboards and email do not and cannot convey tone of voice, but if you haven't and would prefer to view the world as somehow out to get you, that again isn't my problem.

I will look into this and try to figure out what is going on. If I can, that's great. If not, I'll see if it corrects after rebuilding this index after the next upgrade.

Now since this thread has devolved into a bash the tech admin thread, I'm closing it.