Security module --> Creating sec_settings Specified key was too long; max key length is 1000 bytes

Scriptcase 9 Bugs
#1

Hello ,
I’m using very last version of SC 9.11.013 (2) and I’m trying to create a security module (Group) . I’m using mysql 8.0.31 on wampserver .
The error I always got is the following.

ERROR

Creating sec_settings

Specified key was too long; max key length is 1000 bytes

A part from the question about why Security module must to use so big keys …
does anyone can help me fix this annoying issue that stuck me ?
Thanks

#2

what database you running on WAMP ? what database driver have you choosed in project connection settings ?

#3

It was a temporary error . Now it works as usual

#4

I am getting the same Error now. What did you do to fix this ?

#5

I’m sorry , I really forgot everything…
Security model could be nice but the one has developed put some strange control and code inside it.

#6

check these items:

  1. the storage type for tables have ti be is InnoDB (not MyISAM )
  2. the collate for strings is utf8mb4, change it to utf8 ( if you can use utf8 ) so the bytes for the index is under the limit

Vincenzo