error search include collections

20 views
Skip to first unread message

adam jawamann

unread,
Aug 17, 2016, 6:13:57 AM8/17/16
to ResourceSpace
hi, 

if i set this value to true 

$search_includes_user_collections=false;

it shows error for regular user when searching

(database) line N/A: Unknown column 'score' in 'order clause'<br/><br/>select distinct c.* from collection c join resource r left outer join resource_custom_access rca2 on r.ref=rca2.resource and rca2.user='13' and (rca2.user_expires is null or rca2.user_expires>now()) and rca2.access<>2 left outer join resource_custom_access rca on r.ref=rca.resource and rca.usergroup='63' and rca.access<>2 join resource_keyword filter0 on r.ref=filter0.resource and filter0.resource_type_field in ('86','102','103') and ((filter0.keyword in ('130','4259','1165')) or ((rca.access is not null and rca.access<>2) or (rca2.access is not null and rca2.access<>2))) join resource_data dfilter0 on r.ref=dfilter0.resource and dfilter0.resource_type_field in ('86','102','103') and (find_in_set('Janda Petr', dfilter0.value) or find_in_set('INFoI', dfilter0.value) or find_in_set('INF', dfilter0.value)) join collection_resource cr on cr.resource=r.ref and cr.collection=c.ref where (r.access<>'2' or (r.access=2 and ((rca.access is not null and rca.access<>2) or (rca2.access is not null and rca2.access<>2)))) and archive = '0' and (r.archive<>-2 or r.created_by='13') and (r.archive<>-1 or r.created_by='13') and (archive not in ('-1','1','2','3') or created_by='13') and r.ref>0 and not(rca.resource is null and r.access=3) and ( (c.public=0 and c.user='13')) group by c.ref order by score DESC, user_rating DESC, hit_count DESC, field12 DESC,r.ref DESC 


and for superamin it shows error 

(database) line N/A: Unknown column 'score' in 'order clause'<br/><br/>select distinct c.* from collection c join resource r join collection_resource cr on cr.resource=r.ref and cr.collection=c.ref where archive = '0' and r.ref>0 and ( (c.public=0 and c.user='1')) group by c.ref order by score DESC, user_rating DESC, hit_count DESC, field12 DESC,r.ref DESC



if i left to true the only option

$search_includes_resources=true;

everything seems to work ok!


can somebody help me?thx


Reply all
Reply to author
Forward
0 new messages