nuBuilder Forum

I have a billing form (pictured above) that is not saving changes to the main charges/payments subform consistently on records like the one shown adding a payment and hitting the save button saves no problem but forms that have monthly charges dating back years that I have to scroll to the bottom of sometimes save but most are not saving. The nuDebug log states syntax error and the SQL is " UPDATE tblCurrentRentedUnits SET WHERE `BillingID` = '12193'; " for new subform rows that aren't saving. Shouldn't it be running an INSERT for the new record? Editing just the Notes or other main form fields I have had no problem saving on those records that fail on subform inserts.

Hi,

Are you using an auto increment primary key? This can lead to issues while saving and is not recommended.

Recommended Table Structure:
https://wiki.nubuilder.net/nubuilderv3/ ... _Structure

Naming conventions:
https://wiki.nubuilder.cloud/ ... onventions

More about this topic:
https://forums.nubuilder.cloud/viewtopic. ... it=varchar

After testing with changing my primary and foreign keys for the main tables to varchar(25) and running a cascading update against them based on the https://forums.nubuilder.cloud/viewtopic. ... har#p17363 code and I'm still seeing the same thing happening i'm getting queries run when adding rows to the longer histories
that table is also the main table not the subform table it's called tblCharges_Payments

Apart from seeing an error in nuDebug log, are changes still saved inconsistently?
Are you using the latest update?

I figured out why it's adding a debug error. Since it's only attempting to save for the subform there are no changes to the main form. I am using the latest release from sourceforge and it is not saving on subform inserts consistently.

Update I just saw https://forums.nubuilder.cloud/viewtopic.php?f=20&t=10015 Which sounds almost exactly like the problem I'm having however the version on the main sourceforge page under project activity isn't showing the update but I see it under files now so I will try tomorrow to run the update (I have to make sure I verify/reapply a change I made to output pdf's as files when run and my custom scripts folder) but I'll give it a shot.

Alright I just tried the new version both on my autonumber columns as well as resetting them to the hex UUIDs and they save if there are less than 25-30 rows for me.

Hi,
With my specific subform I have it working up to 58 records. If I reduced the number of fields in the subform then I could add few more records.
You wrote it's OK up to about 30 records.

So the conclusion for me was - there is some limitation for total "data container"

and following this path I increased in the php.ini following variable:
max_input_vars 2000 (default is 1000)
and clould easilly go to more then 100 records

I'm using php7.3 and have max_input_vars set to 1000000000 to try to eliminate any problem.

I just checked PHP 7.0 and 7.2 with MAMP and they both work so I'm rolling php on my server back to 7.2