error quickstart install En

Rate this topic: Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.1.00 out of 6 based on 1 vote(s)
GK User
Wed Jan 18, 2017 3:00 pm
Reply with quote
Report this post
Dear all,

my problem is at forum already described, but no answer found.....could you help me
the same error after starting the quick install on fresh DB 3 times
thank you in advance
Error:

Table '1bgn5izh.#__users' doesn't exist SQL=UPDATE `#__users` SET block=1 WHERE block=0
Table '1bgn5izh.#__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 '1bgn5izh.#__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 '1bgn5izh.#__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 (880,'Super User','gkadmin','[email protected]','$2y$10$jhyD86vKG7Pw7OBY/0aTX.A7RGiRsK/sQKHEoybIZ46InVuKHE3xe',0,1,'2015-01-09 12:46:11','2016-11-09 14:27:19','0','{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(981,'Saul Bellow','gkadmin2','[email protected]','$2y$10$M3lu3MGXH5blBnGGBsruB.AqhN/WXfLuE9VYax.5CRWvamRlt/M0e',1,1,'2013-11-18 14:00:02','2014-12-01 08:50:31','0','{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"none\",\"helpsite\":\"\",\"timezone\":\"\"}','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=982 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Table '1bgn5izh.#__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')
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


....etc....
User avatar
Fresh Boarder

teitbite
Sun Jan 22, 2017 12:25 pm
Reply with quote
Report this post
User avatar
Moderator


cron
Remember me
Register New Account
If you are old Gavick user, click HERE for steps to retrieve your account.