Super Search DB error with Matrix fields

Question

I want to re-hash this issue: http://www.solspace.com/forums/viewthread/17419/

The error is:

Error Number: 1052

Column 'field_id_90' in field list is ambiguous 

It seems there was never a proper solution and I'm having the same issue. I can confirm (at least in my testing) that the issue is related to Matrix fields given a relevant value in Super Search.

I’m running EE 2.7.2, SS 2.1.3 and Matrix 2.5.8.

My two matrix fields are: services_about & ct_sub_sections

this works:

relevance=“title=1+services_tags=5+ct_tags=5+page_keywords=5+services_introduction=2+ct_about=1+body=1+count_words_within_words”

this doesn’t:

relevance=“title=1+services_tags=5+ct_tags=5+page_keywords=5+services_introduction=2+services_about =1+ct_about=1+ct_sub_sections=1+body=1+count_words_within_words”

Answer 1

I am experiencing the same problem where it seems to happen when "Is field searchable?" is enabled within the field settings containing the Matrix field-type (not sure why??!)...

I found a solution by changing line 7595 from

$select .= ', field_id_'.$fields[$key].' AS `'.$key.'`';

to

$select .= ', cd.field_id_'.$fields[$key].' AS `'.$key.'`';

Within mod.super_search.php. This seems to have fixed the problem where the table alias is added to the field.

Super Search V2.1.3