View Issue Details

IDProjectCategoryView StatusLast Update
0003250Composrcataloguespublic2017-04-25 12:38
ReporterAdam EdingtonAssigned ToChris Graham 
SeverityMinor-bug 
Status resolvedResolutionfixed 
Product Version 
Fixed in Version 
Summary0003250: Error with custom search options
DescriptionUnfortunately a query has failed [SELECT r.*,r.id AS id,r.cc_id AS r_cc_id,b.cv_value AS b_cv_value FROM cms_catalogue_fields f LEFT JOIN cms_catalogue_entries r ON (r.c_name=f.c_name) LEFT JOIN cms_catalogue_efv_short_trans a ON (r.id=a.ce_id AND f.id=a.cf_id) LEFT JOIN cms_catalogue_efv_long_trans b ON (r.id=b.ce_id AND f.id=b.cf_id) LEFT JOIN cms_catalogue_efv_long d ON (r.id=d.ce_id AND f.id=d.cf_id) LEFT JOIN cms_catalogue_efv_short c ON (r.id=c.ce_id AND f.id=c.cf_id) JOIN cms_seo_meta_keywords m ON (m.meta_for_type='catalogue_entry' AND m.meta_for_id=r.id) JOIN cms_translate tm ON tm.id=m.meta_keyword AND tm.language='EN' WHERE tm.text_original='sentinel' AND r.c_name NOT LIKE '\_%' ORDER BY cv_value DESC/* 81c4f779da207 */ LIMIT 10] [Column 'cv_value' in order clause is ambiguous] (version: 10.0, PHP version: 5.6.30, URL: /composr/V10/site/index.php?page=search&type=results&all_defaults=0&content=sentinel&author=&days=-1&sort=title&direction=DESC&search_catalogue_entries=1)
Steps To Reproduce'Submitted within the previous' set to 'N/A'
'Sort' set to 'Title'
TagsNo tags attached.
Time estimation (hours)
Sponsorship open

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2017-04-25 01:41 Adam Edington New Issue
2017-04-25 12:38 Chris Graham Status non-assigned => resolved
2017-04-25 12:38 Chris Graham Resolution open => fixed
2017-04-25 12:38 Chris Graham Assigned To => Chris Graham