Issue using multiple list options with "get options from MySQL query" with advanced filter refresh

6 posts by 2 authors in: Forums > CMS Builder
Last Post: February 12, 2013   (RSS)

By Steve99 - February 9, 2013

Hello,

I'm experiencing an issue in the admin area of CMS Builder with multiple list options using "get options from MySQL query" with advanced filter refresh.

In Brief:

My goal is to have two drop down lists populated based on selection from a key drop down list. The issue is using "get options from MySQL query" with advanced filter refresh for multiple drop down lists isn't working.

Detailed Scenario:

I have two drop down lists set up this way that are supposed to populate based on selection from a key drop down list. The first dependent drop down list displays "Loading..." every single time and the second drop down list does get populated... However, sometimes the second drop down list is populated with the proper information and sometimes it is populated with the values that are supposed to be in the first one...

For troubleshooting, I deleted one of the two dependent fields and the remaining one populated properly. I then switched it to the query that was used for the drop down list that was temporarily removed and that also populated properly. I also put everything back the way it was and added a third drop down list set up this way that ended up being populated (with mixed results as described above) and the first and second lists were displaying "Loading...". My findings indicate that the last drop down list set up this way will be the only one that ends up being populated - however, the values will either be proper or they will be the values that were supposed to appear in either the first or second drop down list...

Any help with this would be greatly appreciated. It seems like a CMSB issue, but perhaps it's something else. Thanks in advance.

By Dave - February 9, 2013

Hi Steve, 

Thanks for the report.  First up, are you running a recent version?  We made some improvements to how those fields work a few versions ago.  If you're not running a recent version, try upgrading.

If that doesn't solve it, feel free to email CMS & FTP login details to me at dave@interactivetools.com along with steps to reproduce and I can take a look.  Note: Don't post login details to the forum.

Hope that helps!  Let me know how it goes.

Dave Edis - Senior Developer
interactivetools.com

By Steve99 - February 9, 2013

Hi Dave,

This install is version 2.16. By any chance would that version have the updates on those fields?

On this install we hired your company last year for a customized version of "Simple Cart" with authorize.net AIM. Updating the CMS itself shouldn't affect that, correct?

I have a staging install with everything mirrored (files and database) so I suppose I can just upgrade and revert if for some reason I need to. Please let me know if 2.16 has those updates you mentioned and if you think I should be fine with the cart. I'll wait to pull the trigger on upgrading until I hear back even though everything would probably be just fine :)

Thank you for the quick response. Great software and support, that's why we all love Interactive Tools.

- Steve

Hi Dave,

I upgraded to CMSB 2.51 and the issue remains. I'll be in contact via email with info. Thanks.

Steve

Hi Dave,

That took care of it. All is well. Thank you very much!

- Steve