Installation Fail at 3 step making the database

Questions related to the configuration of Joomla, Templates, and Security related questions/issues
Rate this topic: Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.
GK User
Thu Aug 18, 2016 1:55 am
I had try a 2 of the templates (Photo and Creativity) and I et the same error in both. I check my server and I meet the minimum requirements. Also I to confirm this I download the latest Joomla 3.6 from joomla.org and the install when with out issues.
I had try to download a 2nd time, make MySQL again and I always get the same error.

This is just a small part of the error the database give me.

Table 'db643579324.#__users' doesn't exist SQL=UPDATE `#__users` SET block=1 WHERE block=0
Table 'db643579324.#__viewlevels' doesn't exist SQL=INSERT INTO `#__viewlevels` (`id`, `title`, `ordering`, `rules`) VALUES (1,'Public',0,'[1]'),(2,'Registered',1,'[6,2,8]'),(3,'Special',2,'[6,3,8]')
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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Table 'db643579324.#__utf8_conversion' doesn't exist SQL=INSERT INTO `#__utf8_conversion` (`converted`) VALUES (2)
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 'db643579324.#__users' doesn't exist SQL=INSERT INTO `#__users` (`id`, `name`, `username`, `email`, `password`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`, `otpKey`, `otep`, `requireReset`) VALUES (295,'Super User','gkadmin2','[email protected]','ede2a7c592b0d010e154157f9bc23ae5:7sehziAcekja7OnoFMASBGt0BOQhuxAO',0,1,'2013-05-15 16:35:13','2013-05-27 10:57:57','0','{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"none\",\"helpsite\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(838,'Super User','gkadmin','[email protected]','$2y$10$xAlLdeBKz44BUFn/gn0fB.7MgrMpeZRs2HUqaOHBwSvU8H5Hgrxem',0,1,'2013-04-22 09:01:54','2016-07-15 09:42:16','0','{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"none\",\"helpsite\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(839,'test','test','[email protected]','f76434d27ec3a95912557ff4180130a6:mH53DiWOjxQai2hEsNRcsisXQ4fOzhNO',1,0,'2013-07-08 12:03:24','0000-00-00 00:00:00','7eab44a64283cd7d7be859a9ad8c7a85','{}','0000-00-00 00:00:00',0,'','',0),(840,'lorem','lorem','[email protected]','8028e80388f7870ad0d43aa0d5333dda:vvCBEJ4AyAJmDn5RTakmUkZXiRWineJX',1,0,'2013-07-08 12:13:02','0000-00-00 00:00:00','ff6ee48332b5f4530dfb14b74451029c','{}','0000-00-00 00:00:00',0,'','',0)
Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE `#__users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `username` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `password` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `block` tinyint(4) NOT NULL DEFAULT '0', `sendEmail` tinyint(4) DEFAULT '0', `registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `activation` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `params` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `lastResetTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date of last password reset', `resetCount` int(11) NOT NULL DEFAULT '0' COMMENT 'Count of password resets since lastResetTime', `otpKey` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Two factor authentication encrypted keys', `otep` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'One time emergency passwords', `requireReset` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Require user to reset password on next login', PRIMARY KEY (`id`), KEY `idx_block` (`block`), KEY `username` (`username`), KEY `email` (`email`), KEY `idx_name` (`name`(100)) ) ENGINE=InnoDB AUTO_INCREMENT=841 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Table 'db643579324.#__usergroups' doesn't exist SQL=INSERT INTO `#__usergroups` (`id`, `parent_id`, `lft`, `rgt`, `title`) 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')
User avatar
Fresh Boarder

teitbite
Sun Aug 21, 2016 1:12 pm
Hi

Please unpack quickstart and in /installation folder find joomla.sql file and change all "utf8mb4" into "utf8". I think Your server doesn't support utf8mb4.
User avatar
Moderator


cron