Publisher does not support the Fluid field type. Please do not contact asking when support will be available.

If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.

Ticket: [PATCH] Category custom fields with dashes in name causes SQL error

Status Resolved
Add-on / Version Publisher 1.1.2
Severity Trivial
EE Version 2.7.3

Christopher Imrie

Feb 17, 2014

Been using the exp:publisher:translate_category tag inside a channel entries tag (to translate categories with a category tag pair) and kept encountering SQL errors.

Narrowed it down to the use of dashes in a category custom field name.  I fixed it with the following patch:

Line 585 of expressionengine/third_party/publisher/models/publisher_category.php

Changed from:

$field_select_default[] = 'cfd.'. $name .' AS '. $field->field_name;
$field_select_custom[] = $name .' AS '. $field->field_name;

to:

$field_select_default[] = 'cfd.'. $name .' AS \''. $field->field_name.'\'';
$field_select_custom[] = $name .' AS \''. $field->field_name.'\'';
#1

BoldMinded (Brian)

Thanks, included for the next release.

Login to reply