acces levels - forms not saving

[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

[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

[kev1n]

Hi,

Can you upload a screnshot of the table structure?

[johan]

Kevin

[kev1n]

Please change all fields (but the primary key) to default NULL.

[johan]

Kevin

This solved it.
Thanks for your help.