migration db error



  • 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.```

  • administrators

    Unknown character set: 'utf8mb4'

    Your system does meet the requirements for thirty bees. Has to be at least MySQL 5.5 and full UTF-8 support.


Log in to reply
 

Looks like your connection to thirty bees forum was lost, please wait while we try to reconnect.