nuBuilder Forum

Hi,

Recently I have had some problems with changing the column width in the browse tab with new forms. I created a new form using the forms wizard. The table only has 2 columns with a primary key and one additional field called cat_category. The form wizard created the table without a problem. I can do all of the normal things with the form including adding data.

But, when I try to change the width variable for the field in the browse tab, the width turns to 'undefined'. When I save it, the width variable turn to zero and the column does not display a heading or any data. Here are the screen shots:

Here is the browse tab for the form before attempting to change the width: When I tried to change the width to 200, the width said 'undefined': When I click on 'save', the width changes to '0': The column heading and data then disappear from the browse form but the column heading and data are still displayed in the edit form.

This happens with multiple new forms. I did not have problems with this in the past.

Do you have any suggestions on what is causing this problem?

Thanks,

John Klassen

John, can you edit the width value directly from Setup > Objects?

Max,

I went into Setup --> Objects, searched on cat_category. and went to the 'text' tab. Although the browse tab showed the width as 100, the text tab for the object was set to 10.00. I changed the width to 300.00. When I went back to the browse tab for the form, the width is still set to 100.

Am I changing it in the wrong place?

John

John, sorry I messed up: the right place where to set column width is the Browse tab on the form.
What happens to you it's strange: I suspect that some records are missing in system tables.

Try this temporary solution:

• in phpmyadmin select the zzsys_form table and search your form;
• copy the zzsys_form_id value;
• in SQL tab, copy and execute this code:

  Code: Select all

  SELECT * FROM `zzsys_browse` WHERE `sbr_zzsys_form_id` = 'your-zzsys_form_id'

  The return is the list of all "columns" shown in the Browse tab of your form;
• select your field and change the value in sbr_width column
• reopen/refresh application page and try to see if it's working

Let me know if this works, I try to investigate deeper.

EDIT:
John,
in Setup > Objects search for "browseColumns": you should get this objects: Also, try to reload browse.php from a previous backup (or extract from a fresh download).

Max

Max,

I tried replacing browse.php but it didn't make a difference. On the other hand, your temporary solution does work.

I also tried searching for "browseColumns" in Objects but was not sure what to do with it.

For now I will use the temporary solution.

Thanks,

John

I believe there is some problem with the formatting of some fields in some browsers/browser configurations.
I get the same 'undefinedundefinedundefined' value into some fields for some users in Internet Explorer (but not for other), and then a 0 is saved to the database when pressing Save. In Chrome or Firefox it never happens. I have had to tell everyone to only use Chrome or Firefox.
Anyone else who have seen this problem or solved it?
John

Internet Explorer

There are some other problems with various IE versions.
It's banal, but my solution was to set a restriction that users can't log in with IE. (every other browser, but not IE).

Do you think that upgrading to nuBuilder 3.0 will fix the problem or do I need to give up IE?

John

JohnKlassen wrote:Do you think that upgrading to nuBuilder 3.0 will fix the problem or do I need to give up IE?

John, nuBuilder-2 projects are not compatible with nuBuilderPro: there could be some work to do to upgrade your project to nuBuilderPro.
What version of IE are you running? Maybe upgrading IE?

Max

Max,

I am running IE 10.

John