1. 7daw@gmx.at
  2. Commercial Templates
  3. Wednesday, 12 October 2016
  4.  Subscribe via email
Hello,
I have problem to install the demo content from the Creative template.
After entering all Passwords, servers etc. I get the errors I attached for you below..
Maybe you have an Idea?

Errors:
Table 'usrdb_t85xxabo_furdes.#__viewlevels' doesn't exist SQL=/*!40000 ALTER TABLE `#__viewlevels`
ENABLE KEYS */
Table 'usrdb_t85xxabo_furdes.#__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 'usrdb_t85xxabo_furdes.#__viewlevels' doesn't exist SQL=/*!40000 ALTER TABLE `#__viewlevels`
DISABLE KEYS */
Table 'usrdb_t85xxabo_furdes.#__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 'usrdb_t85xxabo_furdes.#__utf8_conversion' doesn't exist SQL=/*!40000 ALTER TABLE
`#__utf8_conversion` ENABLE KEYS */
Table 'usrdb_t85xxabo_furdes.#__utf8_conversion' doesn't exist SQL=INSERT INTO `#__utf8_conversion`
VALUES (2)
Table 'usrdb_t85xxabo_furdes.#__utf8_conversion' doesn't exist SQL=/*!40000 ALTER TABLE
`#__utf8_conversion` DISABLE KEYS */
Table 'usrdb_t85xxabo_furdes.#__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 'usrdb_t85xxabo_furdes.#__usergroups' doesn't exist SQL=/*!40000 ALTER TABLE `#__usergroups`
ENABLE KEYS */
Table 'usrdb_t85xxabo_furdes.#__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 'usrdb_t85xxabo_furdes.#__usergroups' doesn't exist SQL=/*!40000 ALTER TABLE `#__usergroups`
DISABLE KEYS */
Table 'usrdb_t85xxabo_furdes.#__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 'usrdb_t85xxabo_furdes.#__user_usergroup_map' doesn't exist SQL=/*!40000 ALTER TABLE
`#__user_usergroup_map` ENABLE KEYS */
Table 'usrdb_t85xxabo_furdes.#__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),(674,8),
(684,8),(739,8),(772,8),(787,8),(871,8),(874,8),(920,8),(925,8),(926,8),(975,8),(979,8)
Table 'usrdb_t85xxabo_furdes.#__user_usergroup_map' doesn't exist SQL=/*!40000 ALTER TABLE
`#__user_usergroup_map` DISABLE KEYS */
Table 'usrdb_t85xxabo_furdes.#__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 'usrdb_t85xxabo_furdes.#__user_profiles' doesn't exist SQL=/*!40000 ALTER TABLE
`#__user_profiles` ENABLE KEYS */
Table 'usrdb_t85xxabo_furdes.#__user_profiles' doesn't exist SQL=/*!40000 ALTER TABLE
`#__user_profiles` DISABLE KEYS */
Table 'usrdb_t85xxabo_furdes.#__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 'usrdb_t85xxabo_furdes.#__user_notes' doesn't exist SQL=/*!40000 ALTER TABLE `#__user_notes`
ENABLE KEYS */
Table 'usrdb_t85xxabo_furdes.#__user_notes' doesn't exist SQL=/*!40000 ALTER TABLE `#__user_notes`
DISABLE KEYS */
Table 'usrdb_t85xxabo_furdes.#__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

and so on...
Accepted Answer Pending Moderation
0
Votes
Undo
Hello

We have updated our Creative template demo installer to use UTF8 which should hoepfully resolve this issue for you. To obtain simply redownload from your 'My Downloads'.

CiarĂ¡n
  1. more than a month ago
  2. Commercial Templates
  3. # 1
  • 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.