Page 1 of 1
acces levels - forms not saving
Posted: Tue Nov 10, 2020 10:23 am
by johan
Hi
When I try to add a new acces level (or clone one) the Forms tab is empty after I save it.
Any idea what's going wrong?
Johan
Re: acces levels - forms not saving
Posted: Tue Nov 10, 2020 10:55 am
by johan
Hi
Maybe this can help.
Code: Select all
===PDO MESSAGE===
SQLSTATE[HY000]: General error: 1364 Field 'slf_new_button' doesn't have a default value
===SQL===========
INSERT INTO zzzzsys_access_form (zzzzsys_access_form_id, `slf_zzzzsys_access_id`, `slf_zzzzsys_form_id`, `slf_add_button`, `slf_print_button`, `slf_save_button`, `slf_clone_button`, `slf_delete_button`) VALUES ('5faa5a96627fc0d', '5faa5a96623205d', '5af2b8cebbd6c6e', '1', '1', '1', '1', '1');
===BACK TRACE====
/var/www/html/straathoekwerk/nudata.php - line 320 (nuRunQuery)
/var/www/html/straathoekwerk/nuapi.php - line 50 (nuUpdateDatabase)
Johan
Re: acces levels - forms not saving
Posted: Tue Nov 10, 2020 11:01 am
by kev1n
Hi,
Can you upload a screnshot of the table structure?
Re: acces levels - forms not saving
Posted: Tue Nov 10, 2020 12:18 pm
by johan
Kevin
Re: acces levels - forms not saving
Posted: Tue Nov 10, 2020 12:43 pm
by kev1n
Please change all fields (but the primary key) to default NULL.
Re: acces levels - forms not saving
Posted: Tue Nov 10, 2020 12:57 pm
by johan
Kevin
This solved it.
Thanks for your help.