Mysql database error

charliecres

• January 10, 2023 05:49

facing this error after importing an SQL file to my server, but this SQL file working perfectly on another server! [QUOTE] 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 Jurassic Moderator

  • January 10, 2023 11:06

  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:

  0
• 

  charliecres

  • January 10, 2023 11:18

  [mysqld] sql_mode = "NO_ENGINE_SUBSTITUTION" from current setup "/etc/my.cnf"

  0
• 

  cPRex Jurassic Moderator

  • January 10, 2023 11:20

  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?

  0

Please sign in to leave a comment.