zimmer-media Posted July 15, 2017 Share Posted July 15, 2017 today the next shop migration, a error db upgrade - i created the tables manual SQL 2.0.0.1 1115 in CREATE TABLE `ps_module_carrier` ( `id_module` INT(10) UNSIGNED NOT NULL, `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1', `id_reference` INT(11) NOT NULL ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE utf8mb4_unicode_ci: Unknown character set: 'utf8mb4' SQL 2.0.0.1 1115 in CREATE TABLE `ps_redis_servers` ( `id_redis_server` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `ip` VARCHAR(46) NOT NULL, `port` INT(11) UNSIGNED NOT NULL, `auth` TEXT, `db` INT(11) UNSIGNED NOT NULL, PRIMARY KEY (`id_redis_server`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE utf8mb4_unicode_ci: Unknown character set: 'utf8mb4' SQL 2.0.0.1 1115 in CREATE TABLE `ps_currency_module` ( `id_currency` INT(11) UNSIGNED NOT NULL, `id_module` INT(11) UNSIGNED ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE utf8mb4_unicode_ci: Unknown character set: 'utf8mb4' SQL 2.0.0.1 1115 in CREATE TABLE `ps_page_cache` ( `id_page_cache` INT(11) UNSIGNED AUTO_INCREMENT, `cache_hash` VARCHAR(32) NOT NULL, `id_currency` INT(11) UNSIGNED, `id_language` INT(11) UNSIGNED, `id_country` INT(11) UNSIGNED, `id_shop` INT(11) UNSIGNED, `cache` TEXT NOT NULL, `cache_size` INT(10) UNSIGNED, `entity_type` VARCHAR(30) NOT NULL, `id_entity` INT(11) UNSIGNED, UNIQUE KEY `cache_combo` (`cache_hash`, `id_currency`, `id_language`, `id_country`, `id_shop`), PRIMARY KEY (`id_page_cache`), INDEX (`cache_hash`), INDEX (`id_currency`), INDEX (`id_language`), INDEX (`id_country`), INDEX (`id_shop`), INDEX (`id_entity`), INDEX (`entity_type`) ) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci: Unknown character set: 'utf8mb4' Warning detected during upgrade. Link to comment Share on other sites More sharing options...
Question
zimmer-media
today the next shop migration, a error db upgrade - i created the tables manual
SQL 2.0.0.1 1115 in CREATE TABLE `ps_module_carrier` ( `id_module` INT(10) UNSIGNED NOT NULL, `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1', `id_reference` INT(11) NOT NULL ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE utf8mb4_unicode_ci: Unknown character set: 'utf8mb4' SQL 2.0.0.1 1115 in CREATE TABLE `ps_redis_servers` ( `id_redis_server` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `ip` VARCHAR(46) NOT NULL, `port` INT(11) UNSIGNED NOT NULL, `auth` TEXT, `db` INT(11) UNSIGNED NOT NULL, PRIMARY KEY (`id_redis_server`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE utf8mb4_unicode_ci: Unknown character set: 'utf8mb4' SQL 2.0.0.1 1115 in CREATE TABLE `ps_currency_module` ( `id_currency` INT(11) UNSIGNED NOT NULL, `id_module` INT(11) UNSIGNED ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE utf8mb4_unicode_ci: Unknown character set: 'utf8mb4' SQL 2.0.0.1 1115 in CREATE TABLE `ps_page_cache` ( `id_page_cache` INT(11) UNSIGNED AUTO_INCREMENT, `cache_hash` VARCHAR(32) NOT NULL, `id_currency` INT(11) UNSIGNED, `id_language` INT(11) UNSIGNED, `id_country` INT(11) UNSIGNED, `id_shop` INT(11) UNSIGNED, `cache` TEXT NOT NULL, `cache_size` INT(10) UNSIGNED, `entity_type` VARCHAR(30) NOT NULL, `id_entity` INT(11) UNSIGNED, UNIQUE KEY `cache_combo` (`cache_hash`, `id_currency`, `id_language`, `id_country`, `id_shop`), PRIMARY KEY (`id_page_cache`), INDEX (`cache_hash`), INDEX (`id_currency`), INDEX (`id_language`), INDEX (`id_country`), INDEX (`id_shop`), INDEX (`id_entity`), INDEX (`entity_type`) ) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci: Unknown character set: 'utf8mb4' Warning detected during upgrade.
Link to comment
Share on other sites
0 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now