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.
By Dave - March 13, 2024
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!
interactivetools.com
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:
- add two or more items to a pillbox.
- save the record
- modify the record and delete all the items in the pillbox
- save the record
The field now should contain null or empty space but contains a tab
By Dave - March 13, 2024
Hi Jeff,
Okay, great find. I'll have that patched shortly.
interactivetools.com