Query Drop Down - Single Select displaying Value not Label after update

The problem is only happening on the drop-down, and not always - and I really can't determine what if any pattern is reflected in when or when it is displaying ids instead of labels. However, when clearing the site's cache then it 'usually' has the labels show again for a while, but after a few times testing (and refreshing the front-end registration form) the id numbers start appearing again.

I did see that the 3rd query's table fields somehow started saving the label (looks like the query got changed at some point). I changed the query to make sure it was storing the id. Then went through the entire table where those records were stored with labels in the fields and replaced them with the appropriate IDs; however, that didn't seem to make any different.

Also, the 4th query is still showing nothing at all - except the manually entered item (value:9999;label:My Location Not listed).
In fact, I don't even get a 'spinning wheel' upon changing the 3rd query's selection which this 4th is dependent upon.

I thought that this might be a javascript problem - but I'm not seeing any errors in the console when debugging.

Any other ideas come to mind what might be causing this?

Two additional things I just noticed:

1. the last query had `#__ for the query's table prefix - instead of the actual prefix. When I changed that the last query started to work (at least it will occasionally display values there, although still having problems with the 3rd query sometimes showing IDs - which causes the last query to not function.

2. The RAM on the server is being maxed out due to cache useage (even though all caching is disabled).
I'm guessing that running out of resources (esp RAM) could easily be a cause of the problems where so I'm working with our hosting techs to try to identify that issue.

I'll repost here after the ram/cache issues are resolved.

Also, the 4th query is still showing nothing at all - except the manually entered item (value:9999;label:My Location Not listed).
In fact, I don't even get a 'spinning wheel' upon changing the 3rd query's selection which this 4th is dependent upon.

Was able to confirm that as a bug in CB Core Fields Ajax and its Update On chaining functionality. Have fixed for a new build available now.

forge.joomlapolis.com/issues/7508

1. the last query had `#__ for the query's table prefix - instead of the actual prefix. When I changed that the last query started to work (at least it will occasionally display values there, although still having problems with the 3rd query sometimes showing IDs - which causes the last query to not function.

It's best to always use #__ as it'll replace the table prefix automatically as defined in Joomla. Be sure to be using quotes appropriately to escape tables, strings, etc.. as well for a clean SQL.



I'm still unable to reproduce your id/label switching issue. Maybe it's a problem with the query not being clear enough? I'm using the below in my tests successfully without issues.

Field: cb_billingcountry
Query Value Column: country_name
Label Column: country_name
Group Column: country_region

Field: cb_billingstate
Query: Value Column: province_iso_code
Label Column: province_name
Update On: cb_billingcountry

I've yet to find any issues in CB Query Field it self when building the select options.

OK ... that update seeded to fix the 4th query field. Thanks!

However, now we've got another (new) problem.

I've got a Text Field (cb_parishnamenew) that is set-up to be conditionally displayed when the user selects a specific entry in the 4th field - specifically with a value of 9999 (i.e. 'My parish is not listed').

The Text field has the following settings in the Integrations tab:

CB Conditional:

Display: Field conditional show
Conditions:
Field: cb_parishid
Operator: Equal To
Value: 9999
Translate Value: No

CB Core Fields Ajax:

Template: Same as Global
Profile View: Disabled
Userlists View: Disabled
Placeholder: blank
Update On: cb_parishid

However, this field is never showing up.

NOTE: I've also got a similar field associated with the 2nd drop-down field (9999-'My state is not listed') and the the 3rd drop-down field (9999-My diocese is not listed). They are all behaving the same - not showing. I THINK that they were showing prior to this last update (although everything was a bit 'off' so I'm not sure they always displayed).

Thanks for the work on this ... we're getting closer!

I've got a Text Field (cb_parishnamenew) that is set-up to be conditionally displayed when the user selects a specific entry in the 4th field - specifically with a value of 9999 (i.e. 'My parish is not listed').

Ok, that should be fixed now as well in the latest CB Core Fields Ajax build. I've a Country > State > City query select setup that is fully functional. State conditions and updates on Country and City conditions and updates on State. There should be no further chaining issues. I still don't know what is causing your ID/LABEL switch issue though in CB Query Field it self.

Just to clarify - the ID/LABEL issue appears to be resolved - either with the latest patch or because we threw some additional resources at the server and it's no longer hitting RAM limits.

However, the last problem noted - the conditional text field is not resolved with the latest patch.

The drop-downs are all displaying properly, but none of these other conditional text fields (that are all only displaying when a specific option is selected in a drop-down) are displaying at all.

We've updated all CB Plugins as well just to be sure and all are up-to-date.