Tab Group Search Error

3 posts by 2 authors in: Forums > CMS Builder
Last Post: September 25, 2019   (RSS)

By KennyH - September 23, 2019 - edited: September 23, 2019

The Tab Group separators are being included in search queries and it is kicking back an error if I set Searching >> Search Fields to _all_ and then search for something.

If I have Searching >> Search Fields set to any field except the tab group separators, I don't get a get an error.

MySQL Error: Unknown column '__separator001__' in 'where clause'

By daniel - September 25, 2019

Hi KennyH,

This is a bug we are aware of and which is slated to be fixed in the next CMSB release. Fortunately, it's also very simple to fix in the meantime. In /cmsb/lib/menus/default/list_functions.php look for the following line (at or around line 404):

  $skippedFieldTypes        = array('','upload','separator','relatedRecords','none','accessList');

And change it to this:

  $skippedFieldTypes        = array('','upload','separator','relatedRecords','none','accessList','tabGroup');

Let me know if you have any questions!


Technical Lead

By KennyH - September 25, 2019

Thanks, Daniel - that works fine!