Webmastersite.net
Register Log In

Errors research

Comments on Errors research

milouchouchou
Forum Regular

Usergroup: Customer
Joined: Nov 05, 2006
Location: Borlo Belgique

Total Topics: 27
Total Comments: 121
Errors research
Posted Oct 07, 2013 - 3: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

Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Oct 07, 2013 - 6:43 PM:

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.
milouchouchou
Forum Regular

Usergroup: Customer
Joined: Nov 05, 2006
Location: Borlo Belgique

Total Topics: 27
Total Comments: 121
Posted Oct 08, 2013 - 2:21 AM:

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:
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Oct 09, 2013 - 1:32 AM:

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.

Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Oct 09, 2013 - 4:40 AM:

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.
milouchouchou
Forum Regular

Usergroup: Customer
Joined: Nov 05, 2006
Location: Borlo Belgique

Total Topics: 27
Total Comments: 121
Posted Oct 09, 2013 - 5:49 AM:

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

milouchouchou
Forum Regular

Usergroup: Customer
Joined: Nov 05, 2006
Location: Borlo Belgique

Total Topics: 27
Total Comments: 121
Posted Oct 09, 2013 - 3:34 PM:

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

milouchouchou
Forum Regular

Usergroup: Customer
Joined: Nov 05, 2006
Location: Borlo Belgique

Total Topics: 27
Total Comments: 121
Posted Oct 12, 2013 - 3:12 PM:

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

Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Oct 13, 2013 - 6:48 AM:

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.
milouchouchou
Forum Regular

Usergroup: Customer
Joined: Nov 05, 2006
Location: Borlo Belgique

Total Topics: 27
Total Comments: 121
#10 - Quote - Permalink
Posted Oct 13, 2013 - 7:34 AM:

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

Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
#11 - Quote - Permalink
Posted Oct 14, 2013 - 3:54 AM:

Searching descriptions should be ok I'd think, just don't search the text fields.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
#12 - Quote - Permalink
Posted Oct 16, 2013 - 2:31 AM:

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.
milouchouchou
Forum Regular

Usergroup: Customer
Joined: Nov 05, 2006
Location: Borlo Belgique

Total Topics: 27
Total Comments: 121
#13 - Quote - Permalink
Posted Oct 16, 2013 - 7:55 AM:

Thank you Paul, everything works fine.

Good day.
Cordially.
Francis

Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.