Install Joomla 3.8.2 and use a member of a mysql group replication as database server.
Joomla installs.
The installer gives
"Error
The table does not comply with the requirements by an external plugin."
PHP 7.2
MySQLi driver
MySQL Sever version 5.7.18 with multimaster group replication
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;
Status | New | ⇒ | Information Required |
as far as i know every table must have a primary key....i'll submit a pr ....
@michifischer can you test with #19460
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
Status | Information Required | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2018-01-26 09:05:09 |
Closed_By | ⇒ | franz-wohlkoenig |
Closed_Date | 2018-01-26 09:05:09 | ⇒ | 2018-01-26 09:05:10 |
Closed_By | franz-wohlkoenig | ⇒ | joomla-cms-bot |
Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/19032
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.