nuBuilder Forum

Hi Steven

I run nuBuilder on a synology webstation. Its all been working fine until an update yesterday.
Since the update i couldn't:
See any add / delete and clone buttons.
See nuDebug Results / Form properties / Form object list options
Update kept "Something's wrong. Try logging in again..."
and a few other issues

Eventually i traced the problem through the zzzzsys_debug
Once i amended the table to set a default value on this field everything worked fine.

Please can you amend the amend the update procedure so went it updates the table definition it assigns a default setting to sss_time

At the moment i am having to repeat this procedure after doing a system update

Kinds regards
Andrew

Andrew,

I believe I have fixed it.

Let me know if it works for you now.


Steven

Hi Steven,

i have also experienced the same problem on zzzzsys_object and zzzzsys_php. Both have fields that lack defaults values that nuBuilder does not populate when inserting.

zzzzsys_php has sph_php, sph_run, sph_zzzzsys_form_id and sph_hide - discovered when inserting an beforesave event

zzzzsys_object had sob_lookup_autocomplete and sob_lookup_php. discovered when cloning a form object


Andrew

Hi Steven,

Another one in

zzzzsys_file

Field 'sfi_system' doesn't have a default value

another one

Field 'syt_help' doesn't have a default value in zzzzsys_tab

another one,

sus_language in zzzzsys_user

Andrew,

I don't get these problems.

I believe it is to do with your setup.

This might help.

https://stackoverflow.com/questions/187 ... ault-value

Steven

Hi Steven,

That helps. Upon further examination i found this too.

https://mariadb.com/kb/en/library/sql-mode/

It appears that from version MariaDB 10.2.4 strict mode is active as default. The last update my diskstation did took the version upto 10.3.7.

Runnng the above in phpMyAdmin does confirm that my MariaDb has the 'STRICT_TRANS_TABLES' flag active.

The page also describes how to remove the flag, which in theory, should resolve the problem.

Why this may be a simple solution, i'm not sure if it is the best solution. if newer installs of mariadb has this flag set as default then more users, in particular new users, will experience the same issues as me. This appears to be already happening https://forums.nubuilder.cloud/viewtopic.php?f=19&t=9715.

I am more than happy to leave it strict mode and report errors as i find them if you are willing to correct them

Please let me know how you wish to proceed.

Andrew

Andrew,

Thanks for the offer but I have just set a default value of NULL to all but fields with Primary Keys.

And pushed the changes to Github.

If you could test it on your box, that would be great.


Steven

hi Steven,

will do. i will let you know how it goes.

Andrew