too long enumeration/set value for column access

Operating System & Version
CloudLinux v8.7.0 STANDARD
cPanel & WHM Version
110.0.5

charliecres

Well-Known Member
Mar 5, 2020
50
3
8
Dhaka
cPanel Access Level
Root Administrator
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.

Screenshot 2023-05-22 134240.png


and here is etc/my.conf

Screenshot 2023-05-22 134332.png




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
 
Last edited by a moderator:

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
17,470
2,843
363
cPanel Access Level
Root Administrator
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:


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.