We updated all our CB plugins last Friday (related to the #7495 Authorize.net problems)
However, in updating all of our CB plugins it looks like there might be a problem with the CB Query Field (6.0.0+build.2019-03-21-15-18-16).
I've got a field with the following Query:
Code:
SELECT
CONCAT( IF(a.org_name_display<>'',a.org_name_display,a.org_name),' (',a.org_city,', ',b.name,')') as name,
a.id as id
FROM wukrp_cmd_systems_masterorg as a
LEFT JOIN wukrp_cmd_systems_state as b on a.org_state_id = b.id
WHERE a.org_state_id = '[cb_parish_state]'
ORDER BY a.org_name
And the following options set:
- Value Column - id
- Label Column - name
- Group Column - -blank-
On the admin-side of CB the query is displaying properly. I see the label in the drop-down.
However, on the front-end of the site, we just see the ID numbers.
This was all displaying properly prior to the last round of updates to CB plugins.
If it matters, the query for the cb_parish_state (which is referenced in this dropdown) is this:
Code:
SELECT CONCAT(`name`,' (', `abbrev`,')') AS label, id
FROM wukrp_cmd_systems_state
WHERE `country` = '[cb_parish_country]'
ORDER BY `name`
Value Column: id; Label Column: label; Group Column: blank
And the cb_parish_country is this:
Code:
SELECT `name`, id
FROM wukrp_cmd_systems_country
ORDER BY `ordering`, `name`
Value Column: id; Label Column: name; Group Column: blank
Additionally ... another problem, apparently with field is that there is also one more drop-down in this long chain:
Code:
SELECT
CONCAT(t1.org_name,' (',t1.org_city,', ',t2.abbrev,')') as 'generated_orgname',
t1.id as valueid
FROM wukrp_cmd_systems_organization AS t1
LEFT JOIN wukrp_cmd_systems_state AS t2 ON t1.org_state_id = t2.id
WHERE t1.master_org_id = '[cb_parish_archdiocese]'
ORDER BY t1.org_name
Which is obviously filtered on that initial drop-down select; however, it's not displaying anything in the admin (and obviously not working on the front-end either).
Any ideas what might be going on here?
krileon
