Page 1 of 1
Error adding an "Access Level" to a form
Posted: Tue Jan 25, 2022 10:56 pm
by 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)
Re: Error adding an "Access Level" to a form
Posted: Wed Jan 26, 2022 9:07 am
by kev1n
Thanks for reporting. I believe it's fixed now (Github)
Re: Error adding an "Access Level" to a form
Posted: Wed Jan 26, 2022 9:10 pm
by 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)
Re: Error adding an "Access Level" to a form
Posted: Thu Jan 27, 2022 7:34 am
by kev1n
That error should be fixed as well.
Re: Error adding an "Access Level" to a form
Posted: Thu Jan 27, 2022 6:13 pm
by gerese
Work fine now!
