Elevation Blocker detected: Unknown data type: 'MYSQL_JSON'

Cesar Perez

• November 20, 2024 02:36

Hello, I am trying to upgrade cPanel to AlmaLinux 8, but i have this blocker:
* 2024-11-19 19:26:04 [WARN] *** Elevation Blocker detected: ***
  We have found the following problems with your database(s):
  Base_Notesis.nt_rededores
  Error    : Unknown data type: 'MYSQL_JSON'
  error    : Corrupt
  belquita_wp415.wpob_wfls_role_counts
  note     : The storage engine for the table doesn't support check
  ropita_romba.wp_wfls_role_counts
  note     : The storage engine for the table doesn't support check
  simplility_2024.ihmoa_finder_tokens
  note     : The storage engine for the table doesn't support check
  simplility_2024.ihmoa_finder_tokens_aggregate
  note     : The storage engine for the table doesn't support check
  You should repair any corrupted databases before elevating the system.

How can I fix this blocker?

• 

  Andrew

  • November 20, 2024 10:51
  • Edited

  You probably upgraded MySQL 5.7 to MariaDB at some point. MariaDB requires a plugin to read json data. Load the plugin:

  plugin_load_add=mysql_json=type_mysql_json
  plugin_maturity=alpha

  
then run mysql_upgrade --force to pick up all the JSON data types and convert them otherwise if thats the only table then you can convert it with:

  ALTER TABLE nt_rededores FORCE

  Andrew N. - cPanel Plesk VMWare Certified Professional
  Do you need immediate assistance? 20 minutes response time!* Open a ticket
  EmergencySupport - Professional Server Management and One-time Services

  0

Please sign in to leave a comment.