- Code: Select all
"Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE `"
Below is the first table.
- Code: Select all
Table 'noloing_london.#__users' doesn't exist SQL=UPDATE `#__users` SET block=1 WHERE block=0
Table 'noloing_london.#__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 'noloing_london.#__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 'noloing_london.#__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 (532,'Robert Gavick','gkadmin','[email protected]','$2y$10$ioEj6832AKAUOKI5/0DyhOhNZi07rV2AaSAGt2HyoZDdBoUweJ4ba',0,1,'2014-03-19 13:57:34','2016-03-30 08:01:39','0','{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"none\",\"helpsite\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0)
This is from the John 3.x quick start with a blank database, please assist.
