I copied all file into a root folder and I selected Install sample data as like in the instruction file,
I receive a lot of error and nothing is istalled.
see the image.
Without sample data all work well but I don't have the site as a demo server joomla51.
below I post some row
Table 'seevisio28142.#__viewlevels' doesn't exist SQL=/*!40000 ALTER TABLE `#__viewlevels` ENABLE KEYS */
Table 'seevisio28142.#__viewlevels' doesn't exist SQL=INSERT INTO `#__viewlevels` VALUES (1,'Public',0,'[1]'),(2,'Registered',1,'[6,2,8]'),(3,'Special',2,'[6,3,8]'),(4,'Customer Access Level (Example)',3,'[6,3,12]')
Table 'seevisio28142.#__viewlevels' doesn't exist SQL=/*!40000 ALTER TABLE `#__viewlevels` DISABLE KEYS */
Table 'seevisio28142.#__viewlevels' doesn't exist SQL=LOCK TABLES `#__viewlevels` WRITE
Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE `#__viewlevels` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `ordering` int(11) NOT NULL DEFAULT '0', `rules` varchar(5120) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded access control.', PRIMARY KEY (`id`), UNIQUE KEY `idx_assetgroup_title_lookup` (`title`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Table 'seevisio28142.#__utf8_conversion' doesn't exist SQL=/*!40000 ALTER TABLE `#__utf8_conversion` ENABLE KEYS */
Table 'seevisio28142.#__utf8_conversion' doesn't exist SQL=INSERT INTO `#__utf8_conversion` VALUES (2)
Table 'seevisio28142.#__utf8_conversion' doesn't exist SQL=/*!40000 ALTER TABLE `#__utf8_conversion` DISABLE KEYS */
Table 'seevisio28142.#__utf8_conversion' doesn't exist SQL=LOCK TABLES `#__utf8_conversion` WRITE
Unknown character set: 'utf8mb4' SQL=CREATE TABLE `#__utf8_conversion` ( `converted` tinyint(4) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Table 'seevisio28142.#__usergroups' doesn't exist SQL=/*!40000 ALTER TABLE `#__usergroups` ENABLE KEYS */
Table 'seevisio28142.#__usergroups' doesn't exist SQL=INSERT INTO `#__usergroups` VALUES (1,0,1,20,'Public'),(2,1,6,17,'Registered'),(3,2,7,14,'Author'),(4,3,8,11,'Editor'),(5,4,9,10,'Publisher'),(6,1,2,5,'Manager'),(7,6,3,4,'Administrator'),(8,1,18,19,'Super Users'),(10,3,12,13,'Shop Suppliers (Example)'),(12,2,15,16,'Customer Group (Example)')
Table 'seevisio28142.#__usergroups' doesn't exist SQL=/*!40000 ALTER TABLE `#__usergroups` DISABLE KEYS */
Table 'seevisio28142.#__usergroups' doesn't exist SQL=LOCK TABLES `#__usergroups` WRITE
Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE `#__usergroups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Adjacency List Reference Id', `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.', `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.', `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `idx_usergroup_parent_title_lookup` (`parent_id`,`title`), KEY `idx_usergroup_title_lookup` (`title`), KEY `idx_usergroup_adjacency_lookup` (`parent_id`), KEY `idx_usergroup_nested_set_lookup` (`lft`,`rgt`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Table 'seevisio28142.#__user_usergroup_map' doesn't exist SQL=/*!40000 ALTER TABLE `#__user_usergroup_map` ENABLE KEYS */
Table 'seevisio28142.#__user_usergroup_map' doesn't exist SQL=INSERT INTO `#__user_usergroup_map` VALUES (3,8),(16,8),(25,8),(26,2),(27,2),(28,2),(29,2),(30,2),(31,2),(32,2),(45,8),(75,8),(100,8),(238,8),(292,8),(321,8),(324,8),(455,8),(480,8),(557,8),(570,8),(579,8),(593,8),(619,8),(684,8),(728,8),(739,8),(772,8),(787,8),(871,8),(874,8),(920,8),(925,8),(926,8),(975,8),(979,8)
Table 'seevisio28142.#__user_usergroup_map' doesn't exist SQL=/*!40000 ALTER TABLE `#__user_usergroup_map` DISABLE KEYS */
Table 'seevisio28142.#__user_usergroup_map' doesn't exist SQL=LOCK TABLES `#__user_usergroup_map` WRITE
Unknown character set: 'utf8mb4' SQL=CREATE TABLE `#__user_usergroup_map` ( `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__users.id', `group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__usergroups.id', PRIMARY KEY (`user_id`,`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Table 'seevisio28142.#__user_profiles' doesn't exist SQL=/*!40000 ALTER TABLE `#__user_profiles` ENABLE KEYS */
Table 'seevisio28142.#__user_profiles' doesn't exist SQL=/*!40000 ALTER TABLE `#__user_profiles` DISABLE KEYS */
Table 'seevisio28142.#__user_profiles' doesn't exist SQL=LOCK TABLES `#__user_profiles` WRITE
Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE `#__user_profiles` ( `user_id` int(11) NOT NULL, `profile_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `profile_value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `ordering` int(11) NOT NULL DEFAULT '0', UNIQUE KEY `idx_user_id_profile_key` (`user_id`,`profile_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Simple user profile storage table'
Table 'seevisio28142.#__user_notes' doesn't exist SQL=/*!40000 ALTER TABLE `#__user_notes` ENABLE KEYS */
Table 'seevisio28142.#__user_notes' doesn't exist SQL=/*!40000 ALTER TABLE `#__user_notes` DISABLE KEYS */
Table 'seevisio28142.#__user_notes' doesn't exist SQL=LOCK TABLES `#__user_notes` WRITE
Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE `#__user_notes` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT '0', `catid` int(10) unsigned NOT NULL DEFAULT '0', `subject` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `body` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `state` tinyint(3) NOT NULL DEFAULT '0', `checked_out` int(10) unsigned NOT NULL DEFAULT '0', `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_user_id` int(10) unsigned NOT NULL DEFAULT '0', `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_user_id` int(10) unsigned NOT NULL, `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `review_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `idx_user_id` (`user_id`), KEY `idx_category_id` (`catid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Table 'seevisio28142.#__user_keys' doesn't exist SQL=/*!40000 ALTER TABLE `#__user_keys` ENABLE KEYS */
Table 'seevisio28142.#__user_keys' doesn't exist SQL=INSERT INTO `#__user_keys` VALUES (1,'admin','$2y$10$OdW1DXlzFOXNhNPva11OS.VlEJioJE/o.YQ9rmnNXGy8DNrF/bDZa','InrXdUdsKqK9Hev3kJuQ',0,'1430050207','e558cc3ab471d683d25efef8efca754b')
Table 'seevisio28142.#__user_keys' doesn't exist SQL=/*!40000 ALTER TABLE `#__user_keys` DISABLE KEYS */
Table 'seevisio28142.#__user_keys' doesn't exist SQL=LOCK TABLES `#__user_keys` WRITE
Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE `#__user_keys` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `series` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `invalid` tinyint(4) NOT NULL, `time` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `uastring` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `series` (`series`), UNIQUE KEY `series_2` (`series`), UNIQUE KEY `series_3` (`series`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Table 'seevisio28142.#__update_sites_extensions' doesn't exist SQL=/*!40000 ALTER TABLE `#__update_sites_extensions` ENABLE KEYS */
Table 'seevisio28142.#__update_sites_extensions' doesn't exist SQL=INSERT INTO `#__update_sites_extensions` VALUES (1,700),(2,700),(3,866),(4,801)
Table 'seevisio28142.#__update_sites_extensions' doesn't exist SQL=/*!40000 ALTER TABLE `#__update_sites_extensions` DISABLE KEYS */
Table 'seevisio28142.#__update_sites_extensions' doesn't exist SQL=LOCK TABLES `#__update_sites_extensions` WRITE
Unknown character set: 'utf8mb4' SQL=CREATE TABLE `#__update_sites_extensions` ( `update_site_id` int(11) NOT NULL DEFAULT '0', `extension_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`update_site_id`,`extension_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Links extensions to update sites'
Table 'seevisio28142.#__update_sites' doesn't exist SQL=/*!40000 ALTER TABLE `#__update_sites` ENABLE KEYS */
Table 'seevisio28142.#__update_sites' doesn't exist SQL=INSERT INTO `#__update_sites` VALUES (1,'','collection','http://update.joomla.org/core/list.xml',1,1461661348,''),(2,'','collection','http://update.joomla.org/jed/list.xml',1,1461661348,''),(3,'Joomla! Update Component Update Site','extension','http://update.joomla.org/core/extensions/com_joomlaupdate.xml',1,0,''),(4,'Weblinks Update Site','extension','https://raw.githubusercontent.com/joomla-extensions/weblinks/master/manifest.xml',1,0,'')
Table 'seevisio28142.#__update_sites' doesn't exist SQL=/*!40000 ALTER TABLE `#__update_sites` DISABLE KEYS */
Table 'seevisio28142.#__update_sites' doesn't exist SQL=LOCK TABLES `#__update_sites` WRITE
Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE `#__update_sites` ( `update_site_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '', `type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '', `location` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `enabled` int(11) DEFAULT '0', `last_check_timestamp` bigint(20) DEFAULT '0', `extra_query` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT '', PRIMARY KEY (`update_site_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Update Sites'
Table 'seevisio28142.#__ucm_history' doesn't exist SQL=/*!40000 ALTER TABLE `#__ucm_history` ENABLE KEYS */
Table 'seevisio28142.#__ucm_history' doesn't exist SQL=/*!40000 ALTER TABLE `#__ucm_history` DISABLE KEYS */
Table 'seevisio28142.#__ucm_history' doesn't exist SQL=LOCK TABLES `#__ucm_history` WRITE
Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE `#__ucm_history` ( `version_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ucm_item_id` int(10) unsigned NOT NULL, `ucm_type_id` int(10) unsigned NOT NULL, `version_note` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Optional version name', `save_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `editor_user_id` int(10) unsigned NOT NULL DEFAULT '0', `character_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Number of characters in this version.', `sha1_hash` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'SHA1 hash of the version_data column.', `version_data` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'json-encoded string of version data', `keep_forever` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0=auto delete; 1=keep', PRIMARY KEY (`version_id`), KEY `idx_ucm_item_id` (`ucm_type_id`,`ucm_item_id`), KEY `idx_save_date` (`save_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Table 'seevisio28142.#__ucm_content' doesn't exist SQL=/*!40000 ALTER TABLE `#__ucm_content` ENABLE KEYS */
Table 'seevisio28142.#__ucm_content' doesn't exist SQL=/*!40000 ALTER TABLE `#__ucm_content` DISABLE KEYS */
Table 'seevisio28142.#__ucm_content' doesn't exist SQL=LOCK TABLES `#__ucm_content` WRITE
Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE `#__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, `core_alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `core_body` longtext 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 '', `core_checked_out_user_id` int(10) unsigned NOT NULL DEFAULT '0', `core_access` int(10) unsigned NOT NULL DEFAULT '0', `core_params` mediumtext 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 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 DEFAULT '0000-00-00 00:00:00', `core_modified_user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Most recent user that modified', `core_modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `core_language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL, `core_
- giuliano.colabucci
-
- Commercial Templates
- Tuesday, 11 October 2016
- Subscribe via email
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!