Can't create database

[Former user]

My server will not allow players to log in when using sql. It is not properly creating the table rc_blocks. It did create rc_invs. I can't create those tables manually, I need to know their definitions.

Using Paper 1.16.3 #211 RestrictedCreative v 2.4.4

type: mysql

[05:00:29] [Server thread/INFO]: [RestrictedCreative] Enabling RestrictedCreative v2.4.4 [05:00:30] [Server thread/ERROR]: Could not execute SQL statement: [05:00:30] [Server thread/WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes [05:00:30] [Server thread/WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [05:00:30] [Server thread/WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [05:00:30] [Server thread/WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

[Hans Kurel]

It's the first time this has been reported, but I've encountered it myself once as well. I didn't bother to investigate further because it seemed to be specific to my setup.

However, I'll take a look now.