subform value disappears

[johan]

Hi

I made a form with several subforms. Everything seems ok but on a few registrations (forms) the values of the subform actions dissapears after save. In other registrations everything works fine and every value of actions is saved in the database.

Any idea how to solve this problem?
Johan

[toms]

Hi,

What do you mean by subform actions?
Besides, this question is way to abstract imo.

[johan]

Hi

I'll try to explane with a printscreen.

Selectie_028.png

This is the subform. It's in the form 'clienten'.
In some forms (not all) I can't save any value in the subform actie. If I save the form, the value of the subform dissapears.

When I add a row in the database table with foreignkey the ID of that form, it appears (and stays) in the subform. But when I try to delete that row from my subform it won't go away.
It's strange because in most of the forms it works fine.
Johan

[toms]

I'd first verify some basic things (you might have done it already).

1. Make sure that the Foreign Key is correct. (use the up-/down-arrows to verify that it is correct)

sub.png

2. Make sure that the primary and foreign key are of the same data type

3. Make sure that primary keys are set in each table.

4. Last but not least: This is the recommended table structure (https://wiki.nubuilder.net/nubuilderv3/ ... _Structure)
(don't use auto-incrementing numbers for PKs)

[johan]

Toms

I've checked all these things and everything is correct.
Johan

[toms]

What if you temporarily remove the dropdown (select) object and then check if the data is saved when you enter some data in the "datum" field?

[johan]

Hi

I've removed the dropdown but the result is the same.

[toms]

It's really hard to say where the problem lies..

I can offer the following if you want: Create a new, separate nuBuilder DB, create a simple/slimmed down form/subform and upload an sql dump of the db here. Then I can have a closer look at it.

[johan]

Toms

Thanks for your offer but I've found the problem

Code: Select all

[Wed Jul 18 10:31:47.523482 2018] [:error] [pid 20525] [client 192.168.100.1:8501] PHP Warning:  Unknown: Input variables exceeded 1000. To increase the limit change max_input_vars in php.ini. in Unknown on line 0, referer: 

I've increase max_input_vars.

Johan

[toms]

Cool !