Gossamer Forum
Home : Products : Gossamer Links : Discussions :

search is not finding my links...

Quote Reply
search is not finding my links...
Even when I rebuild my search, I have problems finding anything in my database.

Examples:

This does not find anything:
http://www.magicdirectory.com/...search.cgi?query=roy

But it is clear that I have a link in my db:
http://www.magicdirectory.com/...s/Siegfried_and_Roy/

Siegfreid:

http://www.magicdirectory.com/....cgi?query=Siegfreid

David Blaine works fine:
http://www.magicdirectory.com/...query=david%20blaine

don't know... please help,

Thanks,

- Jonathan
Quote Reply
Re: [jdgamble] search is not finding my links... In reply to
Are you using internal indexing? If yes, do you definitely have a value for the weight on the title field?
Quote Reply
Re: [afinlr] search is not finding my links... In reply to
I was using the MySQL indexing scheme. I changed my indexing to NONINDEXED and it now works! Why wouldn't MYSQL indexing not find my links? I have a mysql db. I really don't even know what indexing is. I figured if my site was indexed by a MySQL db (that I have), my search would be faster. Am I missing something?

Whats the difference b/t the indexing, and why would the MySQL not find my links?

Not to get too technical, but it seems self explanatory to me and its not.

???

Thanks and Please Reply,

-

- Jonathan
Quote Reply
Re: [jdgamble] search is not finding my links... In reply to
Hi,

There is an explanation in the manual about the different indexing schemes and the advantages and disadvantages of each one.

I definitely wouldn't recommend using Nonindexed - you will find that the search is much slower as your database grows and I don't think the results will be as good.

I'm not sure why the results aren't found using mysql indexing. I think you may still need to put weights on the fields that you want to be searchable. Try making sure that you have suitable weights and then changing back to mysql and see whether that fixes it.

Laura.
The UK High Street
Quote Reply
Re: [afinlr] search is not finding my links... In reply to
In Reply To:
There is an explanation in the manual about the different indexing schemes and the advantages and disadvantages of each one.[/quote]

I just read it over and tried each scheme manually. I found that internal and mysql schemes do not return any matches for "Roy". It may be faster when searching for something like "David Blaine", but if users can't find something that is actually in the db, it is NOT what I need.

In Reply To:

I definitely wouldn't recommend using Nonindexed - you will find that the search is much slower as your database grows and I don't think the results will be as good.[/quote]

After reading the manual and tweaking things, I found this to be true. It will not display the relevant searches, and it is a lot slower than any other scheme.

In Reply To:
I'm not sure why the results aren't found using mysql indexing. I think you may still need to put weights on the fields that you want to be searchable. Try making sure that you have suitable weights and then changing back to mysql and see whether that fixes it.[/quote]
I double checked it, and my weights were just the way they should be (title 3 etc).

The funny thing is, MSSQL seems to be my best bet. The results are quick, and it actually finds what I'm looking for. The funny thing is, I do not have MSSQL; I have MYSQL (my version is supported according to the manual). Why would this return results and be my best bet? It eludes me.

Anyway, thanks for the help. I solved my problem although I don't understand why the solution works. If you have any other ideas as to why, let me know.

- Jonathan
Quote Reply
Re: [jdgamble] search is not finding my links... In reply to
I didn't think it allowed you to select mssql if you have a mysql database Unsure

The reason you don't get any results for internal indexing will probably be that you need to reindex the database after you've changed the index to internal.

You may find that it is a problem with the database that is causing the change to mysql not to work - I've had this in the past. If you turn on debugging and run the index change from shell you should be able to see what is happening and if there are any problems.

Other than this, I'm not sure what to suggest. If it appears to be working maybe you should just leave it.
Quote Reply
Re: [afinlr] search is not finding my links... In reply to
In Reply To:
I didn't think it allowed you to select mssql if you have a mysql database Unsure[/quote]

Actually it doesn't. I went back to change my properties and it had selected non-indexed automatically. So one question answered...

In Reply To:
The reason you don't get any results for internal indexing will probably be that you need to reindex the database after you've changed the index to internal.[/quote]

Duhh!!! Good call. I just tested it after reindexing and it worked! Fewww...

In Reply To:
You may find that it is a problem with the database that is causing the change to mysql not to work - I've had this in the past. If you turn on debugging and run the index change from shell you should be able to see what is happening and if there are any problems.[/quote]

Yeah, that makes sense. My db isn't big enough and either is the problem for me to worry about debugging (although I may have to do that in the future). I don't know the details, but internal is working; this is good enough for me.

Thanks once again...

- Jonathan