Impossible to update Group/app permission

Scriptcase 9 Bugs
#1

Hello,

I can’t change the permissions on the applications from my production server. It works fine locally though.

Every time I save a modification and an option is unchecked (example: Insert), the value “UL” is saved in the database and generates an error.

permission
permission1034×66 2.22 KB 

mysqli): UPDATE sec_groups_apps SET priv_access = 'Y', priv_insert = 'UL', priv_delete = 'UL', priv_update = 'UL', priv_export = 'UL', priv_print = 'UL' WHERE group_id = 2 and app_name = 'Confidential_info_list' Query: UPDATE sec_groups_apps SET priv_access = 'Y', priv_insert = 'UL', priv_delete = 'UL', priv_update = 'UL', priv_export = 'UL', priv_print = 'UL' WHERE group_id = 2 and app_name = 'Confidential_Info_list' failed. Data too long for column 'priv_insert' at row 1
1406: Data too long for column 'priv_insert' at row 1

ADOConnection._Execute(UPDATE sec_groups_apps SET priv_access = 'Y', priv_insert = 'UL', priv_delete = 'UL', priv_update = 'UL', priv_export = 'UL', pr..., false) % line 1149, file: [adodb.inc.php](file://var/www/html/_lib/prod/third/adodb/adodb.inc.php) ADOConnection.Execute(UPDATE sec_groups_apps SET priv_access = 'Y', priv_insert = 'UL', priv_delete = 'UL', priv_update = 'UL', priv_export = 'UL', pr...) % line 3832, file: [ap_form_sec_groups_apps_apl.php](file://var/www/html/ap_form_sec_groups_apps/ap_form_sec_groups_apps_apl.php) ap_form_sec_groups_apps_apl.nm_acessa_banco() % line 1937, file: [ap_form_sec_groups_apps_apl.php](file://var/www/html/ap_form_sec_groups_apps/ap_form_sec_groups_apps_apl.php) ap_form_sec_groups_apps_apl.controle_form_vert() % line 1583, file: [ap_form_sec_groups_apps_apl.php](file://var/www/html/ap_form_sec_groups_apps/ap_form_sec_groups_apps_apl.php) ap_form_sec_groups_apps_apl.control() % line 2404, file: [index.php](file://var/www/html/ap_form_sec_groups_apps/index.php)

Where can this error come from? UL, can it come from the word NULL in the database?

Thanks

#2

Hard to tell, but a few options:

Failed upload. Sometimes occurs when you are reuploading and some files are locked, Try to re-upload or remove production and do it from scratch.
Verify PHP versions. If you are running PHP > 7.3 then downgrade
Verify Table structure in prod and dev

#3

That’s the right answer to this case. For sure the table in production the field priv_insert has 1 as length. It has to be modified to 2 and the same for the fields priv_delete, priv_update and priv_export.

#4

Hi,

However in local, the long is set to 1 and it works:

table_localhost
table_localhost542×557 17.4 KB

#5

My mistake came from my configuration on the production server, I had chosen Mysqli instead of Mysql PDO.

What does it change?
connect_prod