1. giuliano.colabucci
  2. Commercial Templates
  3. Tuesday, 11 October 2016
  4.  Subscribe via email
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_
Accepted Answer Pending Moderation
0
Votes
Undo
Hello

Are you having this issue on a localhost or web server?

Ciarán
  1. more than a month ago
  2. Commercial Templates
  3. # 1
Accepted Answer Pending Moderation
0
Votes
Undo
The issue is on web server, but without sample data work fine.
Thanks
  1. more than a month ago
  2. Commercial Templates
  3. # 2
Accepted Answer Pending Moderation
0
Votes
Undo
Thank you

I have changed the sample data from 'utf8mb4' to the more widely supported 'utf8' and also the updated the demo installer to the latest version of Joomla which should hopefully resolve this issue. To obtain the updated demo installer simply re-download your template from your 'My Downloads'.

Ciarán
  1. more than a month ago
  2. Commercial Templates
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!

Join Our Newsletter

* indicates required
We respect your privacy and do not tolerate spam and will never sell, rent, lease or give away your information (name, email, number, etc.) to any third party. Nor will we send you unsolicited email.
Joomla51 - Mullaghmore, Co. Sligo, Ireland
Joomla51.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by
Open Source Matters
the trademark holder in the United States and other countries.