Error adding an "Access Level" to a form

[gerese]

Hi,
After version "DB Version: V.4.5-2022.01.20.01, Files Version: V.4.5-2022.01.21.02" it appeared.

error access level.gif

Code: Select all

[0] : 
===USER==========

globeadmin

===PDO MESSAGE=== 

SQLSTATE[42000]: Syntax error or access violation: 1110 Column 'slf_zzzzsys_access_id' specified twice

===SQL=========== 

INSERT INTO zzzzsys_access_form  (zzzzsys_access_form_id, `slf_zzzzsys_access_id`, `slf_zzzzsys_access_id`, `slf_add_button`, `slf_print_button`, `slf_save_button`, `slf_clone_button`, `slf_delete_button`)  VALUES ('61f06fcaaa0602b', '61f06c2541901c7', '61f06c3a5da864a', '1', '1', '1', '1', '1');

===BACK TRACE====

C:\wamp64\www\sisf1\core\nudata.php - line 422 (nuRunQuery)

C:\wamp64\www\sisf1\core\nuapi.php - line 85 (nuUpdateDatabase)

[kev1n]

Thanks for reporting. I believe it's fixed now (Github)

[gerese]

Hi ,
Same problem in "Access Level" when trying to add a procedure.

error_accesslevel.jpg

Code: Select all

[0] : 
===USER==========
globeadmin
===PDO MESSAGE=== 
SQLSTATE[42000]: Syntax error or access violation: 1110 Column 'slp_zzzzsys_php_id' specified twice
===SQL=========== 
INSERT INTO zzzzsys_access_php  (zzzzsys_access_php_id, `slp_zzzzsys_php_id`, `slp_zzzzsys_php_id`)  VALUES ('61f1a9881be47b4', '61f06c3a5da864a', 'nu61eceada0768c21');
===BACK TRACE====
C:\wamp64\www\sisf1\core\nudata.php - line 422 (nuRunQuery)
C:\wamp64\www\sisf1\core\nuapi.php - line 85 (nuUpdateDatabase)

[kev1n]

That error should be fixed as well.

[gerese]

Work fine now!