Skip to Content Skip to Menu

Query Plugin Not Working Correctly

8 years 4 months ago #281479 by tjohns92109
Query Plugin Not Working Correctly was created by tjohns92109
I'm using a query drop down. Here is my query:
SELECT * FROM `jos_comprofiler_field_values` WHERE `parent` = 'Catering'

There is only ONE row that has 'Catering' in the 'parent' column. But it not only is grabbing data from other rows but also duplicating it as you can see in the HTML that the system is using for the dropdown...

<select name="cb_subcats" id="cb_subcats" class="form-control" aria-invalid="false">
<option value=""></option>
<option value="Catering Company" id="cbf258">Catering Company</option>
<option value="Wedding Assistant" id="cbf259">Wedding Assistant</option>
<option value="Catering Company" id="cb_subcats__cbf2">Catering Company</option>
</select>

Attached is a chunk of the database table where you can see that only 1 row should be returned.
Attachments:

Please Log in or Create an account to join the conversation.

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
8 years 4 months ago #281483 by nant
Replied by nant on topic Query Plugin Not Working Correctly
moved out of potential cb bugs forum.

Latest CB Query field plugin is version 5.0.4.

Please Log in or Create an account to join the conversation.

8 years 4 months ago #281484 by tjohns92109
Replied by tjohns92109 on topic Query Plugin Not Working Correctly
I found a way around it. The bug is obviously still there. I dulplicated the field - every setting and exact word - except for the 'title' and 'name' of the field. And, now it seems to be working. It's not ignoring my query. My guess is that somewhere when you change an option (or maybe the query itself) and hit save, it's not overwriting the previous field value in the database correctly. But that's just a blind guess.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum