Problems with changing column width in browse tab

[JohnKlassen]

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:

Original width for cat_category

Width at 100.png (25.05 KiB) Viewed 14936 times

When I tried to change the width to 200, the width said 'undefined':

Width changes to undefined

width as undefined.png (25.5 KiB) Viewed 14936 times

When I click on 'save', the width changes to '0':

Width as zero

width is zero.png (25.15 KiB) Viewed 14936 times

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

[massiws]

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

setupObject.png (9.28 KiB) Viewed 14926 times

[JohnKlassen]

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.

Object with text width set to 300.

Text screen with width of 300.png (15.73 KiB) Viewed 14922 times

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

[massiws]

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:

browseColumn.png (51.69 KiB) Viewed 14917 times

Also, try to reload browse.php from a previous backup (or extract from a fresh download).

Max

[JohnKlassen]

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

[johnbertell]

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

[zazzium]

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).

[JohnKlassen]

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

John

[massiws]

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

[JohnKlassen]

Max,

I am running IE 10.

John