Datebase Editor can't edit pillbox **BUG** CMSB 3.65

4 posts by 2 authors in: Forums > CMS Builder
Last Post: March 13, 2024   (RSS)

By kitsguru - February 23, 2024 - edited: February 24, 2024

In CMSB 3.65, you can't edit the pillbox SQL statement. See attached image.

Also, when in data entry mode, if something is added to the dropdown, saved and then removed, a single \t is stored instead of null or "" .

EDIT:: actually I discovered the issue, there is a text-nowrap class applied to the textarea. I was trying to format the query for easier reading by adding spaces and newline. I prefer to have that class removed as it serves no useful purpose that I can see.

I have edited 'cmsb/lib/menus/database/editField.php' lines 404 and 560 and removed 'text-nowrap'  and have experienced no negative effects.

Jeff Shields
Attachments:

listoption bug.png 259K

By kitsguru - March 13, 2024

First on the text-nowrap issue, I simply removed it from the source code as I prefer not to have to scroll. I prefer to format it as follows.

SELECT  title
FROM `<?php echo $TABLE_PREFIX ?>lookup`
WHERE module_name = 120 and hidden = 0
ORDER BY title;

On the issue with the pillbox \t, in the editor, to reproduce:

  1. add two or more items to a pillbox.
  2. save the record
  3. modify the record and delete all the items in the pillbox
  4. save the record

The field now should contain null or empty space but contains a tab

Jeff Shields

By Dave - March 13, 2024

Hi Jeff, 

Okay, great find. I'll have that patched shortly. 

Dave Edis - Senior Developer
interactivetools.com