Jump to content

Welcome, Guest!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

  • 0
zimmer-media

migration db error

Question

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.

Share this post


Link to post
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...