Volaclub jili sabong apk download,Demo slots PG.REGISTER NOW GET FREE 888 PESOS REWARDS!

Resolved

Ian

(@ipgill)

G’day AIOSEO team,

Would you please be able to help me with the error below?

Thank you ??

[16-Sep-2021 05:15:52 UTC] WordPress database error Unknown collation: 'UXmos' for query CREATE TABLE wp_aioseo_notifications (
					id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
					slug varchar(13) NOT NULL,
					title text NOT NULL,
					content longtext NOT NULL,
					type varchar(64) NOT NULL,
					level text NOT NULL,
					notification_id bigint(20) unsigned DEFAULT NULL,
					notification_name varchar(255) DEFAULT NULL,
					start datetime DEFAULT NULL,
					end datetime DEFAULT NULL,
					button1_label varchar(255) DEFAULT NULL,
					button1_action varchar(255) DEFAULT NULL,
					button2_label varchar(255) DEFAULT NULL,
					button2_action varchar(255) DEFAULT NULL,
					dismissed tinyint(1) NOT NULL DEFAULT 0,
					created datetime NOT NULL,
					updated datetime NOT NULL,
					PRIMARY KEY (id),
					UNIQUE KEY ndx_aioseo_notifications_slug (slug),
					KEY ndx_aioseo_notifications_dates (start, end),
					KEY ndx_aioseo_notifications_type (type),
					KEY ndx_aioseo_notifications_dismissed (dismissed)
				) DEFAULT CHARACTER SET utf8mb4 COLLATE UXmos-7F1H]T; made by require('/usr/local/cpanel/3rdparty/wp-toolkit/plib/vendor/wp-cli/wpt-wp-cli.php'), require_once('/usr/local/cpanel/3rdparty/wp-toolkit/plib/vendor/wp-cli/vendor/wp-cli/wp-cli/php/boot-fs.php'), require_once('/usr/local/cpanel/3rdparty/wp-toolkit/plib/vendor/wp-cli/vendor/wp-cli/wp-cli/php/wp-cli.php'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('/home2/nanotech/public_html/wp-settings.php'), include_once('/home2/nanotech/public_html/wp-content/plugins/all-in-one-seo-pack/all_in_one_seo_pack.php'), aioseo, AIOSEO\Plugin\AIOSEO::instance, AIOSEO\Plugin\AIOSEO->init, AIOSEO\Plugin\AIOSEO->load, AIOSEO\Plugin\Common\Tools\RobotsTxt->__construct, AIOSEO\Plugin\Common\Main\Updates->addInitialCustomTablesForV4, AIOSEO\Plugin\Common\Utils\Database->execute
[16-Sep-2021 05:15:52 UTC] WordPress database error Unknown collation: 'UXmos' for query CREATE TABLE wp_aioseo_posts (
					id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
					post_id bigint(20) unsigned NOT NULL,
					title text DEFAULT NULL,
					description text DEFAULT NULL,
					keywords mediumtext DEFAULT NULL,
					keyphrases longtext DEFAULT NULL,
					page_analysis longtext DEFAULT NULL,
					canonical_url text DEFAULT NULL,
					og_title text DEFAULT NULL,
					og_description text DEFAULT NULL,
					og_object_type varchar(64) DEFAULT 'default',
					og_image_type varchar(64) DEFAULT 'default',
					og_image_custom_url text DEFAULT NULL,
					og_image_custom_fields text DEFAULT NULL,
					og_custom_image_width int(11) DEFAULT NULL,
					og_custom_image_height int(11) DEFAULT NULL,
					og_video varchar(255) DEFAULT NULL,
					og_custom_url text DEFAULT NULL,
					og_article_section text DEFAULT NULL,
					og_article_tags text DEFAULT NULL,
					twitter_use_og tinyint(1) DEFAULT 1,
					twitter_card varchar(64) DEFAULT 'default',
					twitter_image_type varchar(64) DEFAULT 'default',
					twitter_image_custom_url text DEFAULT NULL,
					twitter_image_custom_fields text DEFAULT NULL,
					twitter_title text DEFAULT NULL,
					twitter_description text DEFAULT NULL,
					seo_score int(11) DEFAULT 0 NOT NULL,
					schema_type varchar(20) DEFAULT NULL,
					schema_type_options longtext DEFAULT NULL,
					pillar_content tinyint(1) DEFAULT NULL,
					robots_default tinyint(1) DEFAULT 1 NOT NULL,
					robots_noindex tinyint(1) DEFAULT 0 NOT NULL,
					robots_noarchive tinyint(1) DEFAULT 0 NOT NULL,
					robots_nosnippet tinyint(1) DEFAULT 0 NOT NULL,
					robots_nofollow tinyint(1) DEFAULT 0 NOT NULL,
					robots_noimageindex tinyint(1) DEFAULT 0 NOT NULL,
					robots_noodp tinyint(1) DEFAULT 0 NOT NULL,
					robots_notranslate tinyint(1) DEFAULT 0 NOT NULL,
					robots_max_snippet int(11) DEFAULT NULL,
					robots_max_videopreview int(11) DEFAULT NULL,
					robots_max_imagepreview varchar(20) DEFAULT 'none',
					tabs mediumtext DEFAULT NULL,
					images longtext DEFAULT NULL,
					priority tinytext DEFAULT NULL,
					frequency tinytext DEFAULT NULL,
					videos longtext DEFAULT NULL,
					video_thumbnail text DEFAULT NULL,
					video_scan_date datetime DEFAULT NULL,
					local_seo longtext DEFAULT NULL,
					created datetime NOT NULL,
					updated datetime NOT NULL,
					PRIMARY KEY (id),
					KEY ndx_aioseo_posts_post_id (post_id)
				) DEFAULT CHARACTER SET utf8mb4 COLLATE UXmos-7F1H]T; made by require('/usr/local/cpanel/3rdparty/wp-toolkit/plib/vendor/wp-cli/wpt-wp-cli.php'), require_once('/usr/local/cpanel/3rdparty/wp-toolkit/plib/vendor/wp-cli/vendor/wp-cli/wp-cli/php/boot-fs.php'), require_once('/usr/local/cpanel/3rdparty/wp-toolkit/plib/vendor/wp-cli/vendor/wp-cli/wp-cli/php/wp-cli.php'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('/home2/nanotech/public_html/wp-settings.php'), include_once('/home2/nanotech/public_html/wp-content/plugins/all-in-one-seo-pack/all_in_one_seo_pack.php'), aioseo, AIOSEO\Plugin\AIOSEO::instance, AIOSEO\Plugin\AIOSEO->init, AIOSEO\Plugin\AIOSEO->load, AIOSEO\Plugin\Common\Tools\RobotsTxt->__construct, AIOSEO\Plugin\Common\Main\Updates->addInitialCustomTablesForV4, AIOSEO\Plugin\Common\Utils\Database->execute
[16-Sep-2021 05:15:52 UTC] WordPress database error Unknown collation: 'UXmos' for query CREATE TABLE wp_actionscheduler_claims (
				        claim_id bigint(20) unsigned NOT NULL auto_increment,
				        date_created_gmt datetime NOT NULL default '0000-00-00 00:00:00',
				        PRIMARY KEY  (claim_id),
				        KEY date_created_gmt (date_created_gmt)
				        ) DEFAULT CHARACTER SET utf8mb4 COLLATE UXmos-7F1H]T made by require('/usr/local/cpanel/3rdparty/wp-toolkit/plib/vendor/wp-cli/wpt-wp-cli.php'), require_once('/usr/local/cpanel/3rdparty/wp-toolkit/plib/vendor/wp-cli/vendor/wp-cli/wp-cli/php/boot-fs.php'), require_once('/usr/local/cpanel/3rdparty/wp-toolkit/plib/vendor/wp-cli/vendor/wp-cli/wp-cli/php/wp-cli.php'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('/home2/nanotech/public_html/wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\AIOSEO->actionScheduler, AIOSEO\Plugin\Common\Utils\ActionScheduler->__construct, ActionScheduler_ListTable->recreate_tables, ActionScheduler_Abstract_Schema->register_tables, ActionScheduler_Abstract_Schema->update_table, dbDelta
[16-Sep-2021 05:15:52 UTC] WordPress database error Unknown collation: 'UXmos' for query CREATE TABLE wp_actionscheduler_groups (
				        group_id bigint(20) unsigned NOT NULL auto_increment,
				        slug varchar(255) NOT NULL,
				        PRIMARY KEY  (group_id),
				        KEY slug (slug(191))
				        ) DEFAULT CHARACTER SET utf8mb4 COLLATE UXmos-7F1H]T made by require('/usr/local/cpanel/3rdparty/wp-toolkit/plib/vendor/wp-cli/wpt-wp-cli.php'), require_once('/usr/local/cpanel/3rdparty/wp-toolkit/plib/vendor/wp-cli/vendor/wp-cli/wp-cli/php/boot-fs.php'), require_once('/usr/local/cpanel/3rdparty/wp-toolkit/plib/vendor/wp-cli/vendor/wp-cli/wp-cli/php/wp-cli.php'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('/home2/nanotech/public_html/wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\AIOSEO->actionScheduler, AIOSEO\Plugin\Common\Utils\ActionScheduler->__construct, ActionScheduler_ListTable->recreate_tables, ActionScheduler_Abstract_Schema->register_tables, ActionScheduler_Abstract_Schema->update_table, dbDelta
[16-Sep-2021 05:15:52 UTC] WordPress database error Unknown collation: 'UXmos' for query CREATE TABLE wp_actionscheduler_logs (
				        log_id bigint(20) unsigned NOT NULL auto_increment,
				        action_id bigint(20) unsigned NOT NULL,
				        message text NOT NULL,
				        log_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
				        log_date_local datetime NOT NULL default '0000-00-00 00:00:00',
				        PRIMARY KEY  (log_id),
				        KEY action_id (action_id),
				        KEY log_date_gmt (log_date_gmt)
				        ) DEFAULT CHARACTER SET utf8mb4 COLLATE UXmos-7F1H]T made by require('/usr/local/cpanel/3rdparty/wp-toolkit/plib/vendor/wp-cli/wpt-wp-cli.php'), require_once('/usr/local/cpanel/3rdparty/wp-toolkit/plib/vendor/wp-cli/vendor/wp-cli/wp-cli/php/boot-fs.php'), require_once('/usr/local/cpanel/3rdparty/wp-toolkit/plib/vendor/wp-cli/vendor/wp-cli/wp-cli/php/wp-cli.php'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('/home2/nanotech/public_html/wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\AIOSEO->actionScheduler, AIOSEO\Plugin\Common\Utils\ActionScheduler->__construct, ActionScheduler_ListTable->recreate_tables, ActionScheduler_Abstract_Schema->register_tables, ActionScheduler_Abstract_Schema->update_table, dbDelta

Viewing 4 replies - 1 through 4 (of 4 total)

Plugin Author arnaudbroes
(@arnaudbroes)

3 years, 5 months ago

@ipgill when we create our tables, we use the collate value that is set on the wpdb instance (database class from WordPress Core). I have no idea where that value came from but it’s definitely not valid.

I would try dropping the notifications table through a database management software like Adminer or PHPMyAdmin so that AIOSEO will recreate the table. If you then run into the same error, you’ll need to troubleshoot why WordPress is using such a weird value.
Thread Starter Ian
(@ipgill)

3 years, 5 months ago
Thank you.

I managed to create the tables manually in SQL.

Just have one last error as below:
```
WordPress database error Unknown column 'new' in 'where clause' for query SELECT 
	*
FROM wp_aioseo_notifications
WHERE 1 = 1 AND
	<code>dismissed</code> = 0
	AND <code>new</code> = 1
	AND (start <= '2021-09-17 05:47:05' OR start IS NULL)
	AND (end >= '2021-09-17 05:47:05' OR end IS NULL)
ORDER BY start DESC, created DESC
/* 1 = 1 */ made by require_once('wp-admin/admin-header.php'), do_action('admin_enqueue_scripts'), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Main\Main->enqueueAssets, AIOSEO\Plugin\Common\Models\Notification::getNewNotifications, AIOSEO\Plugin\Common\Utils\Database->run
```
Plugin Author arnaudbroes
(@arnaudbroes)

3 years, 5 months ago
@ipgill that’s an extra column we added via an update migration.
```
$tableName = $wpdb->prefix . 'aioseo_notifications';
"ALTER TABLE $tableName
ADD new tinyint(1) NOT NULL DEFAULT 1 AFTER dismissed"
```
Just use the proper prefix there, run the query and it should do the trick.
- This reply was modified 3 years, 5 months ago by arnaudbroes.
Thread Starter Ian
(@ipgill)

3 years, 5 months ago

Thank you. This has fixed the error.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘WordPress database error Unknown collation’ is closed to new replies.