1. 7daw@gmx.at
  2. Commercial Templates
  3. Tuesday, 05 July 2016
  4.  Subscribe via email
Hello,
I have problems installing the demo content of the CAITLIN Template. Other demos and Joomla basic install work on my server.
Trying with the demo of Caitlin, I get a very long list (see below). Any possible help for this from you?


Table 'usrdb_t85xxabo_caitlin.#__viewlevels' doesn't exist SQL=/*!40000 ALTER TABLE `#__viewlevels` ENABLE KEYS */

Table 'usrdb_t85xxabo_caitlin.#__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_caitlin.#__viewlevels' doesn't exist SQL=/*!40000 ALTER TABLE `#__viewlevels` DISABLE KEYS */

Table 'usrdb_t85xxabo_caitlin.#__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_caitlin.#__utf8_conversion' doesn't exist SQL=/*!40000 ALTER TABLE `#__utf8_conversion` ENABLE KEYS */

Table 'usrdb_t85xxabo_caitlin.#__utf8_conversion' doesn't exist SQL=INSERT INTO `#__utf8_conversion` VALUES (2)

Table 'usrdb_t85xxabo_caitlin.#__utf8_conversion' doesn't exist SQL=/*!40000 ALTER TABLE `#__utf8_conversion` DISABLE KEYS */

Table 'usrdb_t85xxabo_caitlin.#__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_caitlin.#__usergroups' doesn't exist SQL=/*!40000 ALTER TABLE `#__usergroups` ENABLE KEYS */

Table 'usrdb_t85xxabo_caitlin.#__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_caitlin.#__usergroups' doesn't exist SQL=/*!40000 ALTER TABLE `#__usergroups` DISABLE KEYS */
Accepted Answer Pending Moderation
0
Votes
Undo
Hello

On the second step of your Joomla installation try using the 'Database Type' of 'MySQLi'.

Ciarán
  1. more than a month ago
  2. Commercial Templates
  3. # 1
Accepted Answer Pending Moderation
0
Votes
Undo
Hello Ciarán,
I tried all of the possible settings. No success with this.
Other possibility?
  1. more than a month ago
  2. Commercial Templates
  3. # 2
Accepted Answer Pending Moderation
0
Votes
Undo
Hello

I have updated and re built the installer to the latest version of Joomla which should hopefully resolve this issue for you. To obtain simply re download from your Joomla51 'My Downloads'.

Ciarán
  1. more than a month ago
  2. Commercial Templates
  3. # 3
Accepted Answer Pending Moderation
0
Votes
Undo
Hello Ciarán,
unfortunately it still doesn´t work. I can install a empty standard Joomla or a Joomla with training content but not your demo-content. I also tried different demo packages like willow. I tried different sub-domains and different database. still the same list of bugs.
Any other idea?
  1. more than a month ago
  2. Commercial Templates
  3. # 4
Accepted Answer Pending Moderation
0
Votes
Undo
By the way: I have tried php version 7.0.6 and 5.6.21 also.
  1. more than a month ago
  2. Commercial Templates
  3. # 5
Accepted Answer Pending Moderation
0
Votes
Undo
Could it be the caracter set? "utf8mb4"? Is this standard or did you change this lately? My provider told me this is not standard...
  1. more than a month ago
  2. Commercial Templates
  3. # 6
Accepted Answer Pending Moderation
0
Votes
Undo
Hello

This should not cause you any issues when installing. May I ask does Your database and server meets minimal joomla installation requirements.. https://www.joomla.org/about-joomla/technical-requirements.html

If so may I suggest setting us up with temporary server access and we will attempt to install the demo for you.

Ciarán
  1. more than a month ago
  2. Commercial Templates
  3. # 7
Accepted Answer Pending Moderation
0
Votes
Undo
Hello Ciaran,
I talked to my provider now. The server and database meets the minimal standards of Joomla for sure.
The problem here lies in the demo data from this template.
The database encoding is not the same here with the minimum requirements of Joomla.

I was now able to install the demo content using one of the following adjustments:
In the installation files can be found at installation / sql / mysql / sample_data.sql. If you perform in this file Find / Replace, of utf8mp4 to utf8, and replaced all the hits, you can install the demo data successfully.
It seems, that you use the absolutely newest (maybe beta or not stable) version to produce the data for the demo templates. If the provider hasn´t installed the absolutely newest Mysqli database but a version which meets the minimum requirements of Joomla right now, the database will not understand utf8mp4 and the install of demo content fails.
You should consider, that not every provider has installed the absolutely newest version of Mysqil at any time.
It would be great (not only for me I suppose) if you could provide demo content which expects the minimum or a common standard of Joomla and not the brand new latest. My provider for example will implement the newest version of mysqli not before August 2016.

Best Regards
  1. more than a month ago
  2. Commercial Templates
  3. # 8
Accepted Answer Pending Moderation
0
Votes
Undo
Hello

Thank you for detailing and sharing your solution. Admittedly this is something that I had not considered. UTF8mp4 has been around for a number of year however only appears to be supported from MySQL 5.5.3 which although matched the recommended requirements for Joomla does not match the minimum requirements. Once we check that there is not ill effects we will look in to changing all demo installers to UTF8 as you rightly suggest.

Thanks again for bringing this to our attention!

Regards
Ciarán
  1. more than a month ago
  2. Commercial Templates
  3. # 9
Accepted Answer Pending Moderation
0
Votes
Undo
Please could you let me know if the caitlin demo content is changed to UTF8?
  1. more than a month ago
  2. Commercial Templates
  3. # 10
Accepted Answer Pending Moderation
0
Votes
Undo
Hello

The demo installer database of our Caitlin template has been converted to UTF8 and upgraded to Joomla 3.6.

Ciarán
  1. more than a month ago
  2. Commercial Templates
  3. # 11
Accepted Answer Pending Moderation
0
Votes
Undo
Please could you let me know if the creative demo content is changed to UTF8?

Would need it badly..
  1. more than a month ago
  2. Commercial Templates
  3. # 12
Accepted Answer Pending Moderation
0
Votes
Undo
Hello

As requested we have updated our Creative template demo installer to use UTF8. To obtain simply redownload from your 'My Downloads'.

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