20
« il: 08 Giu 2021, 18:07:01 »
Ho la necessità di portare il locale un sito e, come altre volte, utilizzo Akeeba backup.
Questa volta qualcosa è andato storto, dopo l'estrazione dei files, si presenta un errore nel database che riporto in fondo.
Facendo qualche ricerca online, pare che si sia presentato varie volte e qualcuno ha risolto così:
"The problem was finally solved with the help of my provider. They changed the innodb global file format settings to BARRACUDA and the ROW_SIZE of the jos_eb_events table was set to DYNAMIC. innodb_strict_mode was turned OFF."
Purtroppo, non essendo essendo esperto di database, non capisco dove intervenire e in che modo.
Come posso risolvere?
Avete qualche suggerimento?
Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline. SQL=CREATE TABLE `ybcj2_ucm_content` ( `core_content_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `core_type_alias` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'FK to the content types table', `core_title` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `core_alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `core_body` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `core_state` tinyint(1) NOT NULL DEFAULT '0', `core_checked_out_time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0000-00-00 00:00:00', `core_checked_out_user_id` int(10) unsigned NOT NULL DEFAULT '0', `core_access` int(10) unsigned NOT NULL DEFAULT '0', `core_params` text COLLATE utf8mb4_unicode_ci NOT NULL, `core_featured` tinyint(4) unsigned NOT NULL DEFAULT '0', `core_metadata` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'JSON encoded metadata properties.', `core_created_user_id` int(10) unsigned NOT NULL DEFAULT '0', `core_created_by_alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `core_created_time` datetime NOT NULL, `core_modified_user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Most recent user that modified', `core_modified_time` datetime NOT NULL, `core_language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `core_publish_up` datetime NOT NULL, `core_publish_down` datetime NOT NULL, `core_content_item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID from the individual type table', `asset_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.', `core_images` text COLLATE utf8mb4_unicode_ci NOT NULL, `core_urls` text COLLATE utf8mb4_unicode_ci NOT NULL, `core_hits` int(10) unsigned NOT NULL DEFAULT '0', `core_version` int(10) unsigned NOT NULL DEFAULT '1', `core_ordering` int(11) NOT NULL DEFAULT '0', `core_metakey` text COLLATE utf8mb4_unicode_ci NOT NULL, `core_metadesc` text COLLATE utf8mb4_unicode_ci NOT NULL, `core_catid` int(10) unsigned NOT NULL DEFAULT '0', `core_xreference` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'A reference to enable linkages to external data sets.', `core_type_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`core_content_id`) , KEY `tag_idx` (`core_state`,`core_access`) , KEY `idx_access` (`core_access`) , KEY `idx_alias` (`core_alias`(100)) , KEY `idx_language` (`core_language`) , KEY `idx_title` (`core_title`(100)) , KEY `idx_modified_time` (`core_modified_time`) , KEY `idx_created_time` (`core_created_time`) , KEY `idx_content_type` (`core_type_alias`(100)) , KEY `idx_core_modified_user_id` (`core_modified_user_id`) , KEY `idx_core_checked_out_user_id` (`core_checked_out_user_id`) , KEY `idx_core_created_user_id` (`core_created_user_id`) , KEY `idx_core_type_id` (`core_type_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='Contains core content data in name spaced fields'
Raw query text:
CREATE TABLE `ybcj2_ucm_content` ( `core_content_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `core_type_alias` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'FK to the content types table', `core_title` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `core_alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `core_body` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `core_state` tinyint(1) NOT NULL DEFAULT '0', `core_checked_out_time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0000-00-00 00:00:00', `core_checked_out_user_id` int(10) unsigned NOT NULL DEFAULT '0', `core_access` int(10) unsigned NOT NULL DEFAULT '0', `core_params` text COLLATE utf8mb4_unicode_ci NOT NULL, `core_featured` tinyint(4) unsigned NOT NULL DEFAULT '0', `core_metadata` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'JSON encoded metadata properties.', `core_created_user_id` int(10) unsigned NOT NULL DEFAULT '0', `core_created_by_alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `core_created_time` datetime NOT NULL, `core_modified_user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Most recent user that modified', `core_modified_time` datetime NOT NULL, `core_language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `core_publish_up` datetime NOT NULL, `core_publish_down` datetime NOT NULL, `core_content_item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID from the individual type table', `asset_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.', `core_images` text COLLATE utf8mb4_unicode_ci NOT NULL, `core_urls` text COLLATE utf8mb4_unicode_ci NOT NULL, `core_hits` int(10) unsigned NOT NULL DEFAULT '0', `core_version` int(10) unsigned NOT NULL DEFAULT '1', `core_ordering` int(11) NOT NULL DEFAULT '0', `core_metakey` text COLLATE utf8mb4_unicode_ci NOT NULL, `core_metadesc` text COLLATE utf8mb4_unicode_ci NOT NULL, `core_catid` int(10) unsigned NOT NULL DEFAULT '0', `core_xreference` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'A reference to enable linkages to external data sets.', `core_type_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`core_content_id`) , KEY `tag_idx` (`core_state`,`core_access`) , KEY `idx_access` (`core_access`) , KEY `idx_alias` (`core_alias`(100)) , KEY `idx_language` (`core_language`) , KEY `idx_title` (`core_title`(100)) , KEY `idx_modified_time` (`core_modified_time`) , KEY `idx_created_time` (`core_created_time`) , KEY `idx_content_type` (`core_type_alias`(100)) , KEY `idx_core_modified_user_id` (`core_modified_user_id`) , KEY `idx_core_checked_out_user_id` (`core_checked_out_user_id`) , KEY `idx_core_created_user_id` (`core_created_user_id`) , KEY `idx_core_type_id` (`core_type_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='Contains core content data in name spaced fields'
Visualizza post
