Mysql database error

[charliecres]

facing this error after importing an SQL file to my server, but this SQL file working perfectly on another server!

MySQL said:

#3505 - Too long enumeration/set value for column access.

Note: (Server version: 8.0.31-cll-lve - MySQL)


I have attached a screenshot for better view.

 

[cPRex]

Hey there! Is it possible that MySQL has strict mode enabled on the new machine? If so, we have a guide on how to change that here:

How to disable MySQL Strict Mode

Introduction On MySQL 5.7, strict mode is enabled by default. Often at time, there are some applications, such as WHMCS that would requires you to disable MySQL strict mode. Here are some of th...

support.cpanel.net

 

[charliecres]

[mysqld]
sql_mode = "NO_ENGINE_SUBSTITUTION"


from current setup "/etc/my.cnf"

 

[cPRex]

Thanks for the additional details. Unfortunately I'm not finding anything else about this error on my end, so it might be best to create a ticket with our team so we can check this out directly on your server.

If you're able to do that, can you please post the ticket number here so I can follow along?