Unknown column 'keyword_3_found' in 'field list' SVN 5382

[TimC]

Anyone any thoughts on why I'm getting these errors generated from time to time? Also getting various other keyword numbers 4,6 etc. I have no idea what action is being performed to cause them they are just being emailed as errors.

(database) line N/A: Unknown column 'keyword_3_found' in 'field list'

select distinct h.score score, r.ref, r.resource_type, r.has_image, r.is_transcoding, r.hit_count, r.creation_date, r.rating, r.user_rating, r.user_rating_count, r.user_rating_total, r.file_extension, r.preview_extension, r.image_red, r.image_green, r.image_blue, r.thumb_width, r.thumb_height, r.archive, r.access, r.colour_key, r.created_by, r.file_modified, r.file_checksum, r.request_count, r.new_hit_count, r.expiry_notification_sent, r.preview_tweaks, r.file_path ,r.annotation_count ,null group_access, null user_access ,r.field12 ,r.field8 ,r.field3 ,r.field78 ,r.field51 ,r.field18 from resource r join resource_keyword k1 on k1.resource=r.ref and k1.resource_type_field='77' and (k1.keyword='2386' ) join resource_keyword k2 on k2.resource=r.ref and k2.resource_type_field='77' and (k2.keyword='2389' ) join ( select resource,sum(score) as score, bit_or(keyword_3_found) as keyword_3_found from (select resource,false as keyword_1_found,false as keyword_2_found,hit_count as score from resource_keyword k3 where (k3.keyword='775' or k3.keyword in ('775')) and k3.resource_type_field='74') as hits group by resource) as h on h.resource=r.ref where resource_type in ('1') and resource_type not in (4) and archive = '0' and r.ref>0 and h.keyword_3_found group by r.ref order by score DESC, user_rating DESC, hit_count DESC, field12 DESC,r.ref DESC limit 48 

Thanks.

[TimC]

Further to my previous post I have now been able to reproduce this error and the circumstances under which it occurs. 

We have a Category Tree field in Simple Search and the error happens if you check more than one tree node at the same time as selecting other search criteria such as a dropdown from Simple search also.

Behind the scenes the Category Tree is creating a comma delimited list in a hidden input field as the tree is is stored in the db as a comma delimited list. I suspect this is causing problems with the $keywords array and embedding a comma list within a comma list because the count of values in this array is getting screwed up.

I've done quite a lot of investigating the code and trying to fix but nothing has worked so far. Some help with this would be appreciated.

Thank you.

[TimC]

Found the cause now and submitted bug report and possible fix code to Issue Tracker.