{"id":14876971,"date":"2021-09-16T05:27:44","date_gmt":"2021-09-16T05:27:44","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/wordpress-database-error-unknown-collation\/"},"modified":"2021-09-16T05:27:44","modified_gmt":"2021-09-16T05:27:44","slug":"wordpress-database-error-unknown-collation","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/wordpress-database-error-unknown-collation\/","title":{"rendered":"WordPress database error Unknown collation"},"content":{"rendered":"<p>G&#8217;day AIOSEO team,<\/p>\n<p>Would you please be able to help me with the error below?<\/p>\n<p>Thank you \ud83d\ude42<\/p>\n<pre><code>[16-Sep-2021 05:15:52 UTC] WordPress database error Unknown collation: &#039;UXmos&#039; for query CREATE TABLE wp_aioseo_notifications (\n\t\t\t\t\tid bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n\t\t\t\t\tslug varchar(13) NOT NULL,\n\t\t\t\t\ttitle text NOT NULL,\n\t\t\t\t\tcontent longtext NOT NULL,\n\t\t\t\t\ttype varchar(64) NOT NULL,\n\t\t\t\t\tlevel text NOT NULL,\n\t\t\t\t\tnotification_id bigint(20) unsigned DEFAULT NULL,\n\t\t\t\t\tnotification_name varchar(255) DEFAULT NULL,\n\t\t\t\t\tstart datetime DEFAULT NULL,\n\t\t\t\t\tend datetime DEFAULT NULL,\n\t\t\t\t\tbutton1_label varchar(255) DEFAULT NULL,\n\t\t\t\t\tbutton1_action varchar(255) DEFAULT NULL,\n\t\t\t\t\tbutton2_label varchar(255) DEFAULT NULL,\n\t\t\t\t\tbutton2_action varchar(255) DEFAULT NULL,\n\t\t\t\t\tdismissed tinyint(1) NOT NULL DEFAULT 0,\n\t\t\t\t\tcreated datetime NOT NULL,\n\t\t\t\t\tupdated datetime NOT NULL,\n\t\t\t\t\tPRIMARY KEY (id),\n\t\t\t\t\tUNIQUE KEY ndx_aioseo_notifications_slug (slug),\n\t\t\t\t\tKEY ndx_aioseo_notifications_dates (start, end),\n\t\t\t\t\tKEY ndx_aioseo_notifications_type (type),\n\t\t\t\t\tKEY ndx_aioseo_notifications_dismissed (dismissed)\n\t\t\t\t) DEFAULT CHARACTER SET utf8mb4 COLLATE UXmos-7F1H]T; made by require(&#039;\/usr\/local\/cpanel\/3rdparty\/wp-toolkit\/plib\/vendor\/wp-cli\/wpt-wp-cli.php&#039;), require_once(&#039;\/usr\/local\/cpanel\/3rdparty\/wp-toolkit\/plib\/vendor\/wp-cli\/vendor\/wp-cli\/wp-cli\/php\/boot-fs.php&#039;), require_once(&#039;\/usr\/local\/cpanel\/3rdparty\/wp-toolkit\/plib\/vendor\/wp-cli\/vendor\/wp-cli\/wp-cli\/php\/wp-cli.php&#039;), WP_CLI\\bootstrap, WP_CLI\\Bootstrap\\LaunchRunner-&gt;process, WP_CLI\\Runner-&gt;start, WP_CLI\\Runner-&gt;load_wordpress, require(&#039;\/home2\/nanotech\/public_html\/wp-settings.php&#039;), include_once(&#039;\/home2\/nanotech\/public_html\/wp-content\/plugins\/all-in-one-seo-pack\/all_in_one_seo_pack.php&#039;), aioseo, AIOSEO\\Plugin\\AIOSEO::instance, AIOSEO\\Plugin\\AIOSEO-&gt;init, AIOSEO\\Plugin\\AIOSEO-&gt;load, AIOSEO\\Plugin\\Common\\Tools\\RobotsTxt-&gt;__construct, AIOSEO\\Plugin\\Common\\Main\\Updates-&gt;addInitialCustomTablesForV4, AIOSEO\\Plugin\\Common\\Utils\\Database-&gt;execute\n[16-Sep-2021 05:15:52 UTC] WordPress database error Unknown collation: &#039;UXmos&#039; for query CREATE TABLE wp_aioseo_posts (\n\t\t\t\t\tid bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n\t\t\t\t\tpost_id bigint(20) unsigned NOT NULL,\n\t\t\t\t\ttitle text DEFAULT NULL,\n\t\t\t\t\tdescription text DEFAULT NULL,\n\t\t\t\t\tkeywords mediumtext DEFAULT NULL,\n\t\t\t\t\tkeyphrases longtext DEFAULT NULL,\n\t\t\t\t\tpage_analysis longtext DEFAULT NULL,\n\t\t\t\t\tcanonical_url text DEFAULT NULL,\n\t\t\t\t\tog_title text DEFAULT NULL,\n\t\t\t\t\tog_description text DEFAULT NULL,\n\t\t\t\t\tog_object_type varchar(64) DEFAULT &#039;default&#039;,\n\t\t\t\t\tog_image_type varchar(64) DEFAULT &#039;default&#039;,\n\t\t\t\t\tog_image_custom_url text DEFAULT NULL,\n\t\t\t\t\tog_image_custom_fields text DEFAULT NULL,\n\t\t\t\t\tog_custom_image_width int(11) DEFAULT NULL,\n\t\t\t\t\tog_custom_image_height int(11) DEFAULT NULL,\n\t\t\t\t\tog_video varchar(255) DEFAULT NULL,\n\t\t\t\t\tog_custom_url text DEFAULT NULL,\n\t\t\t\t\tog_article_section text DEFAULT NULL,\n\t\t\t\t\tog_article_tags text DEFAULT NULL,\n\t\t\t\t\ttwitter_use_og tinyint(1) DEFAULT 1,\n\t\t\t\t\ttwitter_card varchar(64) DEFAULT &#039;default&#039;,\n\t\t\t\t\ttwitter_image_type varchar(64) DEFAULT &#039;default&#039;,\n\t\t\t\t\ttwitter_image_custom_url text DEFAULT NULL,\n\t\t\t\t\ttwitter_image_custom_fields text DEFAULT NULL,\n\t\t\t\t\ttwitter_title text DEFAULT NULL,\n\t\t\t\t\ttwitter_description text DEFAULT NULL,\n\t\t\t\t\tseo_score int(11) DEFAULT 0 NOT NULL,\n\t\t\t\t\tschema_type varchar(20) DEFAULT NULL,\n\t\t\t\t\tschema_type_options longtext DEFAULT NULL,\n\t\t\t\t\tpillar_content tinyint(1) DEFAULT NULL,\n\t\t\t\t\trobots_default tinyint(1) DEFAULT 1 NOT NULL,\n\t\t\t\t\trobots_noindex tinyint(1) DEFAULT 0 NOT NULL,\n\t\t\t\t\trobots_noarchive tinyint(1) DEFAULT 0 NOT NULL,\n\t\t\t\t\trobots_nosnippet tinyint(1) DEFAULT 0 NOT NULL,\n\t\t\t\t\trobots_nofollow tinyint(1) DEFAULT 0 NOT NULL,\n\t\t\t\t\trobots_noimageindex tinyint(1) DEFAULT 0 NOT NULL,\n\t\t\t\t\trobots_noodp tinyint(1) DEFAULT 0 NOT NULL,\n\t\t\t\t\trobots_notranslate tinyint(1) DEFAULT 0 NOT NULL,\n\t\t\t\t\trobots_max_snippet int(11) DEFAULT NULL,\n\t\t\t\t\trobots_max_videopreview int(11) DEFAULT NULL,\n\t\t\t\t\trobots_max_imagepreview varchar(20) DEFAULT &#039;none&#039;,\n\t\t\t\t\ttabs mediumtext DEFAULT NULL,\n\t\t\t\t\timages longtext DEFAULT NULL,\n\t\t\t\t\tpriority tinytext DEFAULT NULL,\n\t\t\t\t\tfrequency tinytext DEFAULT NULL,\n\t\t\t\t\tvideos longtext DEFAULT NULL,\n\t\t\t\t\tvideo_thumbnail text DEFAULT NULL,\n\t\t\t\t\tvideo_scan_date datetime DEFAULT NULL,\n\t\t\t\t\tlocal_seo longtext DEFAULT NULL,\n\t\t\t\t\tcreated datetime NOT NULL,\n\t\t\t\t\tupdated datetime NOT NULL,\n\t\t\t\t\tPRIMARY KEY (id),\n\t\t\t\t\tKEY ndx_aioseo_posts_post_id (post_id)\n\t\t\t\t) DEFAULT CHARACTER SET utf8mb4 COLLATE UXmos-7F1H]T; made by require(&#039;\/usr\/local\/cpanel\/3rdparty\/wp-toolkit\/plib\/vendor\/wp-cli\/wpt-wp-cli.php&#039;), require_once(&#039;\/usr\/local\/cpanel\/3rdparty\/wp-toolkit\/plib\/vendor\/wp-cli\/vendor\/wp-cli\/wp-cli\/php\/boot-fs.php&#039;), require_once(&#039;\/usr\/local\/cpanel\/3rdparty\/wp-toolkit\/plib\/vendor\/wp-cli\/vendor\/wp-cli\/wp-cli\/php\/wp-cli.php&#039;), WP_CLI\\bootstrap, WP_CLI\\Bootstrap\\LaunchRunner-&gt;process, WP_CLI\\Runner-&gt;start, WP_CLI\\Runner-&gt;load_wordpress, require(&#039;\/home2\/nanotech\/public_html\/wp-settings.php&#039;), include_once(&#039;\/home2\/nanotech\/public_html\/wp-content\/plugins\/all-in-one-seo-pack\/all_in_one_seo_pack.php&#039;), aioseo, AIOSEO\\Plugin\\AIOSEO::instance, AIOSEO\\Plugin\\AIOSEO-&gt;init, AIOSEO\\Plugin\\AIOSEO-&gt;load, AIOSEO\\Plugin\\Common\\Tools\\RobotsTxt-&gt;__construct, AIOSEO\\Plugin\\Common\\Main\\Updates-&gt;addInitialCustomTablesForV4, AIOSEO\\Plugin\\Common\\Utils\\Database-&gt;execute\n[16-Sep-2021 05:15:52 UTC] WordPress database error Unknown collation: &#039;UXmos&#039; for query CREATE TABLE wp_actionscheduler_claims (\n\t\t\t\t        claim_id bigint(20) unsigned NOT NULL auto_increment,\n\t\t\t\t        date_created_gmt datetime NOT NULL default &#039;0000-00-00 00:00:00&#039;,\n\t\t\t\t        PRIMARY KEY  (claim_id),\n\t\t\t\t        KEY date_created_gmt (date_created_gmt)\n\t\t\t\t        ) DEFAULT CHARACTER SET utf8mb4 COLLATE UXmos-7F1H]T made by require(&#039;\/usr\/local\/cpanel\/3rdparty\/wp-toolkit\/plib\/vendor\/wp-cli\/wpt-wp-cli.php&#039;), require_once(&#039;\/usr\/local\/cpanel\/3rdparty\/wp-toolkit\/plib\/vendor\/wp-cli\/vendor\/wp-cli\/wp-cli\/php\/boot-fs.php&#039;), require_once(&#039;\/usr\/local\/cpanel\/3rdparty\/wp-toolkit\/plib\/vendor\/wp-cli\/vendor\/wp-cli\/wp-cli\/php\/wp-cli.php&#039;), WP_CLI\\bootstrap, WP_CLI\\Bootstrap\\LaunchRunner-&gt;process, WP_CLI\\Runner-&gt;start, WP_CLI\\Runner-&gt;load_wordpress, require(&#039;\/home2\/nanotech\/public_html\/wp-settings.php&#039;), do_action(&#039;plugins_loaded&#039;), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, AIOSEO\\Plugin\\AIOSEO-&gt;actionScheduler, AIOSEO\\Plugin\\Common\\Utils\\ActionScheduler-&gt;__construct, ActionScheduler_ListTable-&gt;recreate_tables, ActionScheduler_Abstract_Schema-&gt;register_tables, ActionScheduler_Abstract_Schema-&gt;update_table, dbDelta\n[16-Sep-2021 05:15:52 UTC] WordPress database error Unknown collation: &#039;UXmos&#039; for query CREATE TABLE wp_actionscheduler_groups (\n\t\t\t\t        group_id bigint(20) unsigned NOT NULL auto_increment,\n\t\t\t\t        slug varchar(255) NOT NULL,\n\t\t\t\t        PRIMARY KEY  (group_id),\n\t\t\t\t        KEY slug (slug(191))\n\t\t\t\t        ) DEFAULT CHARACTER SET utf8mb4 COLLATE UXmos-7F1H]T made by require(&#039;\/usr\/local\/cpanel\/3rdparty\/wp-toolkit\/plib\/vendor\/wp-cli\/wpt-wp-cli.php&#039;), require_once(&#039;\/usr\/local\/cpanel\/3rdparty\/wp-toolkit\/plib\/vendor\/wp-cli\/vendor\/wp-cli\/wp-cli\/php\/boot-fs.php&#039;), require_once(&#039;\/usr\/local\/cpanel\/3rdparty\/wp-toolkit\/plib\/vendor\/wp-cli\/vendor\/wp-cli\/wp-cli\/php\/wp-cli.php&#039;), WP_CLI\\bootstrap, WP_CLI\\Bootstrap\\LaunchRunner-&gt;process, WP_CLI\\Runner-&gt;start, WP_CLI\\Runner-&gt;load_wordpress, require(&#039;\/home2\/nanotech\/public_html\/wp-settings.php&#039;), do_action(&#039;plugins_loaded&#039;), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, AIOSEO\\Plugin\\AIOSEO-&gt;actionScheduler, AIOSEO\\Plugin\\Common\\Utils\\ActionScheduler-&gt;__construct, ActionScheduler_ListTable-&gt;recreate_tables, ActionScheduler_Abstract_Schema-&gt;register_tables, ActionScheduler_Abstract_Schema-&gt;update_table, dbDelta\n[16-Sep-2021 05:15:52 UTC] WordPress database error Unknown collation: &#039;UXmos&#039; for query CREATE TABLE wp_actionscheduler_logs (\n\t\t\t\t        log_id bigint(20) unsigned NOT NULL auto_increment,\n\t\t\t\t        action_id bigint(20) unsigned NOT NULL,\n\t\t\t\t        message text NOT NULL,\n\t\t\t\t        log_date_gmt datetime NOT NULL default &#039;0000-00-00 00:00:00&#039;,\n\t\t\t\t        log_date_local datetime NOT NULL default &#039;0000-00-00 00:00:00&#039;,\n\t\t\t\t        PRIMARY KEY  (log_id),\n\t\t\t\t        KEY action_id (action_id),\n\t\t\t\t        KEY log_date_gmt (log_date_gmt)\n\t\t\t\t        ) DEFAULT CHARACTER SET utf8mb4 COLLATE UXmos-7F1H]T made by require(&#039;\/usr\/local\/cpanel\/3rdparty\/wp-toolkit\/plib\/vendor\/wp-cli\/wpt-wp-cli.php&#039;), require_once(&#039;\/usr\/local\/cpanel\/3rdparty\/wp-toolkit\/plib\/vendor\/wp-cli\/vendor\/wp-cli\/wp-cli\/php\/boot-fs.php&#039;), require_once(&#039;\/usr\/local\/cpanel\/3rdparty\/wp-toolkit\/plib\/vendor\/wp-cli\/vendor\/wp-cli\/wp-cli\/php\/wp-cli.php&#039;), WP_CLI\\bootstrap, WP_CLI\\Bootstrap\\LaunchRunner-&gt;process, WP_CLI\\Runner-&gt;start, WP_CLI\\Runner-&gt;load_wordpress, require(&#039;\/home2\/nanotech\/public_html\/wp-settings.php&#039;), do_action(&#039;plugins_loaded&#039;), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, AIOSEO\\Plugin\\AIOSEO-&gt;actionScheduler, AIOSEO\\Plugin\\Common\\Utils\\ActionScheduler-&gt;__construct, ActionScheduler_ListTable-&gt;recreate_tables, ActionScheduler_Abstract_Schema-&gt;register_tables, ActionScheduler_Abstract_Schema-&gt;update_table, dbDelta<\/code><\/pre>\n","protected":false},"template":"","class_list":["post-14876971","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14876971","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14876971\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=14876971"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}