Unfortunately a query has failed [SELECT *,r.id AS id,r.cc_id AS r_cc_id,b.cv_value AS b_cv_value FROM ((ocp2_catalogue_fields f,ocp2_catalogue_entries r) LEFT JOIN ocp2_catalogue_efv_short_trans a ON (r.id=a.ce_id AND f.id=a.cf_id) LEFT JOIN ocp2_catalogue_efv_long_trans b ON (r.id=b.ce_id AND f.id=b.cf_id) LEFT JOIN ocp2_catalogue_efv_short c ON (r.id=c.ce_id AND f.id=c.cf_id) LEFT JOIN ocp2_catalogue_efv_long d ON (r.id=d.ce_id AND f.id=d.cf_id) LEFT JOIN ocp2_group_category_access z ON (z.module_the_name='catalogues_category' AND z.category_name=r.cc_id AND z.group_id=18) LEFT JOIN ocp2_group_category_access p ON (p.module_the_name='catalogues_catalogue' AND p.category_name=r.c_name AND p.group_id=18)) LEFT JOIN ocp2_translate t0 ON t0.id=a.cv_value LEFT JOIN ocp2_translate t1 ON t1.id=b.cv_value WHERE (MATCH (t0.text_original) AGAINST ('pictures') OR MATCH (t1.text_original) AGAINST ('pictures') OR MATCH (c.cv_value) AGAINST ('pictures') OR MATCH (d.cv_value) AGAINST ('pictures')) AND r.ce_add_date>1149991885 AND NOT (z.category_name IS NULL) AND NOT (p.category_name IS NULL) ORDER BY ce_add_date] [Unknown column 'r.c_name' in 'on clause']
I knew the search and catalogue systems were complex but fixing this particular bug doesn't look fun does it .
In unrelated news, I've upgraded to a Firefox 2 pre-beta which now includes a fantastic integrated spell checker - I no longer have any excuse for poor spelling . We're intending to add one to ocPortal at some point, but it's really nice to have checking as I type and a nice responsive real-time correction interface. When Firefox 2 is properly released I'd really recommend people give it a go - or if you run a forum full of users who can't spell, you might want to give out some ocP points to everyone of them who upgrades.