Save Error -All Forms- not a valid table name for a Subform

[StephenSmothers]

I am new to the nuBuilder community but am a veteran IT person with many year of experience.
I have created a new installation of nuBuilder4 on the following platform:
Windows Server 2012R2
PHP 7.2.7
MySQL 8.0.12
I have managed to resolve every issue I've encountered during setup using the forum and web searches.
The only issue that has me stumped is every form produces the same error when I click save. This is happing on the initial setup screen and any fast forms created using the builder. (screen shots below)
Any assistance would be greatly appreciated.

Saving Time Zone change.

Setup.PNG

Successful Creation of basic form and table.

formcreated.PNG

Test form failed on saving.

TestForm.PNG

[admin]

Stephen,

I have no idea - sorry.

Have you run the Update Button?

This keeps the system files up to date.

Steven

[StephenSmothers]

Yes, I have tried updates, reinstalling nuBuilder4, Recreating the entire database and several configuration changes. Best I can tell is that the code is not getting the table name to use based on a modification I did to the underlying code to troubleshoot the problem.

I've updated PHP
current configuration
Windows Server 2012R2
IIS 8.5
PHP 7.2.11
MySQL 8.0.12

I've determined that the basic configuration should work.
I loaded nuBuilderPro on the system and was able to run everything without any issues.

Why doesn't nuBuilder4 work? Any idea on the best way to troubleshoot the nuBuilder base code? (PHP is not my strong suit.)

[admin]

Stephen,

What do you mean by this?

Code: Select all

based on a modification I did to the underlying code

Steven

[StephenSmothers]

Added a little code to see what was in the variable.

nuDisplayError("<b>$table</b> is not a valid table name for a Subform - $cts[$table]");

It comes back ' '.

I've determined that the basic configuration should work.
I loaded nuBuilderPro on the system and was able to run everything without any issues.

Why doesn't nuBuilder4 work? Any idea on the best way to troubleshoot the nuBuilder base code? (PHP is not my strong suit.)

[admin]

Stephen,

I've pulled the latest from github.

And it works fine for me.


Steven

[kev1n]

Make sure that the object names are written exactly the same as the database field names. Table names (and also field names) are case sensitive.

Also check out this related topic: https://forums.nubuilder.cloud/viewtopic. ... orm#p18003

If this doesn't solve your issue dump your db to an .sql-file and upload it somewhere (e.g. to http://www.tinyupload.com/) and I'll have a look at it.
Remove/replace any confidential data, if there are any.

Export instructions: https://www.inmotionhosting.com/support ... phpmyadmin

Upload the .sql-file here (zip it if necessary)
http://www.tinyupload.com/

Or contact me by email and I'll help you solve your issue: cnux@mailed.ro

[StephenSmothers]

I built some additional VM servers to test various configurations.
The issue appears to be with the MYSQL 8.0.12 configuration. It work under MySQL 5.7.
I believe is has something to do with the JSON configuration.
Any Ideas? Anyone with a MySQL 8.0 under windows configuration working?

[admin]

.