HTML Logo by World Wide Web Consortium ( Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS. ocPortal 9 is superseded by Composr 10.

Head over to for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.

Fixing fun

Fixing fun As we've only recently released 3 fixing automated bug reports is still a pretty regular occurrence. Today one really shook fear into me:
Unfortunately a query has failed [SELECT *, 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 ( AND LEFT JOIN ocp2_catalogue_efv_long_trans b ON ( AND LEFT JOIN ocp2_catalogue_efv_short c ON ( AND LEFT JOIN ocp2_catalogue_efv_long d ON ( AND 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 LEFT JOIN ocp2_translate t1 ON 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  O_o.

In unrelated :offtopic: 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.

View all


There have been no trackbacks yet