too long enumeration/set value for column access

[charliecres]

I have 4 Dedicated servers.
I am facing an error when I am trying to import a specific SQL file. "too long enumeration/set value for column access"

I tried this file on all of my servers. but I am facing the same error.


Here is the attached screenshot of the error.




and here is etc/my.conf






OS: CloudLinux v8.7.0 STANDARD standard
cPanel Version:110.0.5



Database server

• Server: Localhost via UNIX socket
• Server type: MySQL
• Server connection: SSL is not being used
• Server version: 8.0.33 - MySQL Community Server - GPL
• Protocol version: 10
• User: root@localhost
• Server charset: UTF-8 Unicode (utf8mb4)

Web server

• cpsrvd 11.110.0.5
• Database client version: libmysql - mysqlnd 8.1.16
• PHP extension: mysqli curl mbstring
• PHP version: 8.1.16

phpMyAdmin

• Version information: 5.2.1

 

[cPRex]

Hey there! I believe this could be a result of the update to MySQL version 8.

"Prior to MySQL 8.0, the total length of all enum elements could go up to approximately 64k since it was stored in 2 bytes in the FRM file. Hence tables and stored procedures could be created with enum elements greater than 255 chars. However in MySQL 8.0, tables or stored procedures containing too long enum literals(i.e greater 255 chars) are not supported."

That was taken from this article, under step 7:

MySQL :: Upgrading to MySQL 8.0? Here is what you need to know...

dev.mysql.com

Can you review your table structure to see if that is the case? It seems like modifying the table is the most likely solution to the issue.