nuBuilder Forum

Posted: **Tue Sep 04, 2018 2:50 pm**

Hello,
I recently wanted to create a Fast Form (having not used the feature for a while). It used to work just fine but now I find that it fails to complete and reports an invalid column name. This is best illustrated with the screen grab below, which uses a simplified example (a browse & edit form with one field).

Build FF error.PNG

One thought: it looks as though the content of columns [2] and [3] of the sf.rows array could be transposed as nuValidColumn() checks that table sf.rows[2] is a field in the table and the correct field name is actually in sf.rows[0][3] - but I assume should not be. I have downloaded and installed the latest file from GitHub (3 Sept 18) and run the update routine. The same behaviour occurs on three different browsers.

Any ideas what may be causing this and how I start investigating? Thanks.

Neil

Posted: **Tue Sep 04, 2018 3:11 pm**

Neil,

I experienced the same issue. After some investigations, I found that the order of the fields got messed up. IIRC the fields ff_field and ff_id were mixed up.

Run these update statements to fix their order:

Code: Select all

UPDATE `zzzzsys_object` SET `sob_all_order` = 10  WHERE `sob_all_id` = 'ff_label'; -- probably not necessary

UPDATE `zzzzsys_object` SET `sob_all_order` = 20  WHERE `sob_all_id` = 'ff_field';

UPDATE `zzzzsys_object` SET `sob_all_order` = 30  WHERE `sob_all_id` = 'ff_id';

UPDATE `zzzzsys_object` SET `sob_all_order` = 40  WHERE `sob_all_id` = 'ff_browse';  -- probably not necessary

The correct order should look like this:

2018-09-04_151141.png

Posted: **Tue Sep 04, 2018 3:23 pm**

As ever toms, you deliver the solution. I ran the update queries and they seem to have fixed the FF Builder.
Many thanks,
Neil

Posted: **Wed Sep 05, 2018 2:05 am**

You're welcome!

Posted: **Wed Sep 12, 2018 4:22 am**

nuBuilder Forum

Invalid column name reported in Fast Form Builder

Invalid column name reported in Fast Form Builder

Re: Invalid column name reported in Fast Form Builder

Re: Invalid column name reported in Fast Form Builder

Re: Invalid column name reported in Fast Form Builder

Re: Invalid column name reported in Fast Form Builder