Possible error in Security groups_application

[leorika]

Hi
I created a new security group application in one of my scriptcase applications. It creates the admin user with a default administrator group and also adds all the applications to the security app sec_apps, I am using the security exactly the way scriptcase created it in my project. I did no custom coding. Just need a normal Scriptcase Groups security.
When I update the privileges in the sec_groups_apps I get the following error
Data before update
1 admin_add_edit_car_information Y Y Y Y N N

ERROR Close

Error updating database -
Data too long for column ‘priv_access’ at row 1

View SQL
UPDATE sec_groups_apps SET priv_access = ‘UL’, priv_insert = ‘UL’, priv_delete = ‘UL’, priv_update = ‘UL’, priv_export = ‘UL’, priv_print = ‘UL’ WHERE group_id = 1 and app_name = ‘admin_add_edit_car_information’

The ’UL’ should be ‘N’ and not ‘UL’. I increased the database size to 2 then it writes the ’UL’ into the database without error.

This is the data after I increase the size to varchar 2. Note no error BUT…
1 admin_add_edit_car_information UL UL UL UL UL UL

PLEASE NOTE - i did no coding in the security app. This only started after I re-installed scriptcase. I was on version 9.4 before and after installation. I did download the latest version from your server.

Has anyone else had the same happening to them?

Regards

Leorika

[Jheyman_Mejia]

Same issue here, currently with version 9.7.000

I am using the default Security app, I get the same error.

Someone in support to give us an idea of ​​why this is happening?

[Kleyber_Derick]

Hi, Have you reviewed both app and table? If so, have you tried to synchronize your form?

[Jheyman_Mejia]

I am trying the same solutions that @leorika exposes in his post. I can try additional changes at the database level, but this should not be corrected by us as users, it should be a revision by Scriptcase, it is a flaw in its default application. From the number of views on this post, it doesn’t seem to be an isolated error.

[Jheyman_Mejia]

Same issue here:

Security Module...

Hello, i’m a little bit confused; but i think someone could help me. Generating Security… all is working fine… But in configure the security in groups/application level - update would fail. priv_insert = ‘UL’ (in sec_groups_apps) would bring a failure… As i know ther are two values “Y” or “N” (what means “UL” ??) in sec_groups_apps i had following structure: priv_insert varchar(1) utf8 Null allowed thats why update record is failing… but i can’t find “UL” Instead of “N” the application …

It is even discussed in depth in an entry from 2013, regrettable that the error is still present:

Fixing Issue with the Group Security Bug

All, As we all know there is an issue with the SC security security, where it will only give permission on only one group. You cannot add a user to multiple groups. I have been working this issue all day, and I thought I had it fixed… But for some reason, it is not working… Can someone take a look at the login app and see what I may be missing? I know the sql is generating the right dataset… here is the sql I am using to get the results… $sql = "SELECT app_name, ifnull(max(priv_…

It gets extended into similar entries by doing a simple search, some from old versions:

https://forum.scriptcase.net/search?q=priv_insert

[leorika]

Hi guys, scriptcase never gave me a reply and after a while they fixed the problem. I have not renewed my subscription as I feel they don’t give a damn about us users. I am a long time user of this product, but I decided not to renew which I am glad that I did not otherwise I would have had the same error. They have a lot of bugs every-time they launch a new version. I know all the bugs by now but do not bother to report it I made work arounds
Good luck sorting your problems with them. Lucky for most of you the forum has some ideas that help you. However, it should not be necessary for the user to correct the program as it is not an open source and we pay lots of money each year to them.
I have stopped my payment