Installation problem step 2 to many SQL errors

Hi, I've got a problem with quickstart package, my server is OK with joomla 3.x requirements.

Sample :

Code: Select all

Table 'db623134963.#__users' doesn't exist SQL=UPDATE `#__users` SET block=1 WHERE block=0

Table 'db623134963.#__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 'db623134963.#__utf8_conversion' doesn't exist SQL=INSERT INTO `#__utf8_conversion` (`converted`) VALUES (2)

I've tried with English language and French language but same result...The problem happens on step 2 when creating database tables.
Thank you to help me, I'm wasting time. I saw another ticket opened a week ago but no answers...

thanks

Hello,

Most probably your MySQL does not support utf8mb4 charsets which are used by Joomla! since Joomla! 3.5.

In this case please open file:

installation/sql/mysql/joomla.sql and please replace all occurences of:

Code: Select all

utf8mb4

to:

Code: Select all

utf8

And then of course please try to run quickstart installation again.

HI
I have the same problem but if I replace all utf8mb4 in utf8 nothing changes...
Pls help me
tnx

Hi

@expressiva are You sure those are the exact same error messages after renaming ? Because there would be no errors: "Unknown collation: 'utf8mb4_unicode_ci'" if it was renamed correctly. Check if all sentences were changed and update Your mysql version.