I'm a web developer for my customer I created the website using this theme in a temporary domain and hosting account and now im trying to migrate it to my client's real domain and hosting account but while im importing the database im getting this error. could you give me some advice on this matter as soon as posible?
This error is only minor error due to incompatibility between MySQL versions. Starting WordPress 4.2, the database of WordPress uses utf8mb4 charset so if your hosting is still using the old MySQL version does not support utf8mb4, then when importing will encounter the error as above. To fix this error we have the following way, you try each one until fix the error.
1st. Please check the hosting, may be you must update the PHP and MySQL. The core version of MySQL to support for utf8mb4_unicode_520_ci is 5.6
2nd. If you can't contact with host provide to increase the version of MySQL, you must convert the encoding utf8mb4_unicode_520_ci to the encodings that the current MySQL version you are using supports. You can using notepad++ to convert it.
I'm a web developer for my customer I created the website using this theme in a temporary domain and hosting account and now im trying to migrate it to my client's real domain and hosting account but while im importing the database im getting this error. could you give me some advice on this matter as soon as posible?
full error message
-- --------------------------------------------------------
--
-- Table structure for table `wpiq_ngg_album`
--
CREATE TABLE `wpiq_ngg_album` (
`id` bigint(20) NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`slug` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`previewpic` bigint(20) NOT NULL DEFAULT '0',
`albumdesc` mediumtext COLLATE utf8mb4_unicode_520_ci,
`sortorder` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
`pageid` bigint(20) NOT NULL DEFAULT '0',
`extras_post_id` bigint(20) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
Hi,
This error is only minor error due to incompatibility between MySQL versions. Starting WordPress 4.2, the database of WordPress uses utf8mb4 charset so if your hosting is still using the old MySQL version does not support utf8mb4, then when importing will encounter the error as above. To fix this error we have the following way, you try each one until fix the error.
1st. Please check the hosting, may be you must update the PHP and MySQL. The core version of MySQL to support for utf8mb4_unicode_520_ci is 5.6
2nd. If you can't contact with host provide to increase the version of MySQL, you must convert the encoding utf8mb4_unicode_520_ci to the encodings that the current MySQL version you are using supports. You can using notepad++ to convert it.
Thanks
Best regards,
Charmy - ThemeFTC technical expert