?
avatar michifischer
michifischer
9 Dec 2017

Steps to reproduce the issue

Install Joomla 3.8.2 and use a member of a mysql group replication as database server.

Expected result

Joomla installs.

Actual result

The installer gives
"Error
The table does not comply with the requirements by an external plugin."

System information (as much as possible)

PHP 7.2
MySQLi driver
MySQL Sever version 5.7.18 with multimaster group replication

Additional comments

The problem is missing key statements for the following tables in installation/sql/mysql/joomla.sql:
#__finder_terms_common
#__utf8_conversion

Suggested fix:
CREATE TABLE IF NOT EXISTS #__finder_terms_common (
term varchar(75) NOT NULL,
language varchar(3) NOT NULL,
PRIMARY KEY (term,language),
KEY idx_word_lang (term,language),
KEY idx_lang (language)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS #__utf8_conversion (
converted tinyint(4) NOT NULL DEFAULT 0,
PRIMARY KEY (converted)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

avatar michifischer michifischer - open - 9 Dec 2017
avatar joomla-cms-bot joomla-cms-bot - labeled - 9 Dec 2017
avatar franz-wohlkoenig franz-wohlkoenig - change - 26 Jan 2018
Status New Information Required
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 26 Jan 2018

Can a MySQL-Experienced User comment this Issue?


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/19032.

avatar alikon
alikon - comment - 26 Jan 2018

as far as i know every table must have a primary key....i'll submit a pr ....

avatar alikon
alikon - comment - 26 Jan 2018

@michifischer can you test with #19460

avatar michifischer
michifischer - comment - 26 Jan 2018

MySQL tables do not necessarily need a primary key per se [1]. Only if you are using group replication it's a must [2].

[1] https://dev.mysql.com/doc/refman/5.7/en/create-table.html#create-table-indexes-keys
[2] https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html

avatar franz-wohlkoenig franz-wohlkoenig - change - 26 Jan 2018
Status Information Required Closed
Closed_Date 0000-00-00 00:00:00 2018-01-26 09:05:09
Closed_By franz-wohlkoenig
avatar joomla-cms-bot joomla-cms-bot - change - 26 Jan 2018
Closed_Date 2018-01-26 09:05:09 2018-01-26 09:05:10
Closed_By franz-wohlkoenig joomla-cms-bot
avatar joomla-cms-bot
joomla-cms-bot - comment - 26 Jan 2018
avatar joomla-cms-bot joomla-cms-bot - close - 26 Jan 2018
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 26 Jan 2018

closed as having Pull Request #19460

Add a Comment

Login with GitHub to post a comment