Invalid column name reported in Fast Form Builder

[nac]

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

[toms]

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

[nac]

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

[toms]

You're welcome!

[admin]

.