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

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

By kitsguru - February 23 - edited: February 24

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 Dave - March 13

Hi Jeff, 

Thanks for reporting this.  I wasn't able to reproduce this.  Can you give me some more details?  Does this occur just within the field editor?  And can you list the steps to reproduce? 

The "text-nowrap" class isn't required, but what it does it not wrap long SQL lines, so you'll get a horizontal scroll bar on the bottom instead.  Sometimes that's nicer, depends on your preferences.

Thanks!

Dave Edis - Senior Developer
interactivetools.com

By kitsguru - March 13

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