Search box - alfresco-community-tomcat-2.0.0 and MySQL

[sylvain78]

Cannot understand why…

I installed alfresco-community-tomcat-2.0.0 on XP following the Readme and the Readme_mysql file to use MySQL.

Seems to be working fine. Now when I simply search "home" (without the quotes), I don't get any results.

I created a "Actors" space and search (All items) for "Actors" (forget all the quotes!) and still no results.  It works for "guest" though.

I know that "home" should at least return "Company Home" and "Guest Home" because it works on another installation I have of alfresco (.war built from SVN sources, mid-february).  Now I cannot reproduce a "working" installation of alfresco.

The problem is the same if I call the repositoryService using the query method.

What am I doing wrong (I have spent way too much time on this now!).

Thanks for your input!

[sylvain78]

The first time I installed it my jvm locale was French(Canada) and the search feature was not working as I was logging in in english.

I changed my jvm locale to English(Canada), rebuild the index (FULL) and tried logging in in english.  Search was working for file and space names but not for content.

I reinstalled alfresco (having my locale still to English), logged in in english and everything works.

It looks like (it may be obvious to you!…) some information in the database forced me to reinitialize the database as well as the index.  Rebuilding the index was not enough to make search content working.

Does that make sense?

[andy]

Hi

Content data is stored with its locale in the DB. On reindex it will be the same. If not set, the locale will default to the locale in which the content was loaded. For content loaded at bootstrap time - this will be the server locale (as it is not set). If you load stuff up as a user - the locale will be what you selected at login time (unless you have extended the UI and it allows you to select the locale).

Does this explain your behaviour?

It is only possible to search reliable if the tokenisation method matches that used at index time.

By default tokens will try and match across languages.

French is stemming and English is not - so the tokens will be very different.

BUT you can check this.

Login with French selected and search for home. Login with English selected and search for home. Create documents in each language containing the word home and then repeat the two searches.

I hope this clears up what is going on!

Andy