I postherebecause theURIis too long to"ShareWithSupportBug Report"
When I am inEnglish on the websiteandI'm doing researchona breed of dogin English,for exampleNormanartesianbasset,I have thismessage and Ihavea runtime errorthat you will seeif youthisresearch.
So nowI doan advanced searchon: Finditemswhere ... andtitleinEnglishcontaintNorman Ithenget72 pagesofresults
Edit: Noticed the separate title in english field and I see 1000 results when I search Norman there (but still no error message). Does just using the regular title search work for all languages the way you expect, though? If so, best to remove the other language search fields and assume people are searching in their current language.
Iattachedtwoscreenshotsand a text filewiththe error code(becausethe URI istoo long)the simple search. So,the English nameappearsin the listofavailableraces,but returnswhat isin the attached file.
For Advanced Research,the visitormustknowthe name of theracefortheFrenchracein Englishas a search result,it is notalways the casebecausesome breedshavevery differentnames in thetwolanguages.
Unknown column 'fullenglishtitle' in 'where clause'
This indicates that a field fullenglishtitle which no longer exists is still selected as a searchable field for the simple search. There must've been a fullenglish language at one point replaced with english. I resubmitted the Settings -> Searches page so that only existing fields are selected now. That removed the error. Looking into the rest.
Consider whether you should make only title and description be simple-searchable. Including text as you are may make for a ton of irrelevant matches just because long articles happen to contain the word being searched for somewhere even though they're not about that. But it's up to you to see which works best. Excluding the text fields would also make the simple search much much faster.
milouchouchou wrote: For Advanced Research, the visitor must know the name of the race for the French race in English as a search result, it is not always the case because some breeds have very different names in the two languages.
I've rewritten the search code so that multilingual searches now automatically search in the translated field. Although, this means that if there's no translation present in the selected language they don't get a match even if the sheer luck of the french word being similar would've otherwise given a match.
Are you referring to the simple search in all these cases? The simple search will give the same results in every language because all of the language fields are selected as simple searchable. As I explained above, it's slow because of all those huge article texts which may be making the results less accurate anyway so I recommended making them not simple-searchable at Admin -> Settings -> Search.
Ideally, the simple searchable fields list should exclude all the translated fields so that you can't select them and then make its own selection based on the current language. I'll write that when I get a chance. That'll make it much faster also since it'll be searching 1/4 as many fields.
I see the simple searchable field translation was already there and working, so all I needed to do was hide the multilingual versions from the selector. Done.
Comments on Errors research
Forum Regular
Usergroup: Customer
Joined: Nov 05, 2006
Location: Borlo Belgique
Total Topics: 27
Total Comments: 121
Posted Oct 07, 2013 - 2:38 PM:
Hello Paul
I post here because the URI is too long to "Share With Support Bug Report"
When I am in English on the website and I'm doing research on a breed of dog in English, for example Norman artesian basset, I have this message and I have a runtime error that you will see if you this research.
So now I do an advanced search on:
Find items where ...
and title in English containt Norman
I then get 72 pages of results
Can you see if everything is okay in my searches?
In advance thank you.
Cordially.
Francis
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
I went to http://www.milouchouchou.com/articles/search.php in english and searched for listing titles containing Norman. Saw one result and no error messages. Not sure what you mean?
Edit: Noticed the separate title in english field and I see 1000 results when I search Norman there (but still no error message). Does just using the regular title search work for all languages the way you expect, though? If so, best to remove the other language search fields and assume people are searching in their current language.
Forum Regular
Usergroup: Customer
Joined: Nov 05, 2006
Location: Borlo Belgique
Total Topics: 27
Total Comments: 121
Hello Paul
I attached two screenshots and a text file with the error code (because the URI is too long) the simple search.
So, the English name appears in the list of available races, but returns what is in the attached file.
For Advanced Research, the visitor must know the name of the race for the French race in English as a search result, it is not always the case because some breeds have very different names in the two languages.
Good day.
Cordially.
Francis
Attached Files:
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
Unknown column 'fullenglishtitle' in 'where clause'
This indicates that a field fullenglishtitle which no longer exists is still selected as a searchable field for the simple search. There must've been a fullenglish language at one point replaced with english. I resubmitted the Settings -> Searches page so that only existing fields are selected now. That removed the error. Looking into the rest.
Consider whether you should make only title and description be simple-searchable. Including text as you are may make for a ton of irrelevant matches just because long articles happen to contain the word being searched for somewhere even though they're not about that. But it's up to you to see which works best. Excluding the text fields would also make the simple search much much faster.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
For Advanced Research, the visitor must know the name of the race for the French race in English as a search result, it is not always the case because some breeds have very different names in the two languages.
I've rewritten the search code so that multilingual searches now automatically search in the translated field. Although, this means that if there's no translation present in the selected language they don't get a match even if the sheer luck of the french word being similar would've otherwise given a match.
Forum Regular
Usergroup: Customer
Joined: Nov 05, 2006
Location: Borlo Belgique
Total Topics: 27
Total Comments: 121
Hello Paul
Everything seems to work perfectly, a big thank you for your work.
As I understand it, I can remove these custom fields search:
and title in English
and description in English
and text in English
and title in German
and description in German
and text in German
and title in Dutch
and description in Dutch
and text in Dutch
and title in Spanish
and description in Spanish
and text in Spanish
Good day.
Cordially.
Francis
Forum Regular
Usergroup: Customer
Joined: Nov 05, 2006
Location: Borlo Belgique
Total Topics: 27
Total Comments: 121
Hello Paul
Sorry to come back, but there is a small problem in the search.
In French, a search on "Welsh Terrier" take me 17.26 seconds and return a list of 4 results, then there is only one race of that name.
In 4 other languages, the result is the page of "Welsh Terrier" in the language of research.
Could you check what is causing this little problem.
In advance thank you.
Cordially.
Francis
Forum Regular
Usergroup: Customer
Joined: Nov 05, 2006
Location: Borlo Belgique
Total Topics: 27
Total Comments: 121
Hello Paul
Search for "Petit brabançon" gives me 3 races as a result:
Petit brabançon
Griffon bruxellois
Griffon belge
and this in 13.97 seconds
Can you look at what is wrong, the result is the same in 5 languages.
Thank you.
Cordially.
Francis
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
Are you referring to the simple search in all these cases? The simple search will give the same results in every language because all of the language fields are selected as simple searchable. As I explained above, it's slow because of all those huge article texts which may be making the results less accurate anyway so I recommended making them not simple-searchable at Admin -> Settings -> Search.
Ideally, the simple searchable fields list should exclude all the translated fields so that you can't select them and then make its own selection based on the current language. I'll write that when I get a chance. That'll make it much faster also since it'll be searching 1/4 as many fields.
Forum Regular
Usergroup: Customer
Joined: Nov 05, 2006
Location: Borlo Belgique
Total Topics: 27
Total Comments: 121
Yes, I am referring to a simple search.
I just go in search preferences in the admin, and I disabled the search in the description, just do a search in the title and it now works normally.
Sorry but there are so many settings and sometimes I do not think to go everywhere.
Although I use these scripts for a few years, I often find the settings I do not know.
Good Sunday and again thank you.
Cordially.
Francis
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
Searching descriptions should be ok I'd think, just don't search the text fields.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
I see the simple searchable field translation was already there and working, so all I needed to do was hide the multilingual versions from the selector. Done.
Forum Regular
Usergroup: Customer
Joined: Nov 05, 2006
Location: Borlo Belgique
Total Topics: 27
Total Comments: 121
Thank you Paul, everything works fine.
Good day.
Cordially.
Francis