#25067Add compatibility with MySQL 5.5: Replace "TYPE" with "ENGINE"
Description
*Problem:*
When using MySQL 5.5 or newer you cannot install the default tables in the install tool. Trying to create them the install tool uses the “type” table option to specify the table storage engine. This option is no longer supported in MySQL 5.5.
Error message:
"Removed Features: The TYPE table option to specify the storage engine for CREATE TABLE or ALTER TABLE (use ENGINE)."
*Fix:*
Change the sqlparser (class.t3lib_sqlparser.php): Do not use “TYPE”, but “ENGINE”.
line 1823:
// Make query:
$query = 'CREATE TABLE ' . $components['TABLE'] . ' (
' . implode(',
', $fieldsKeys) . '
)' . ($components['tableType'] ? ' TYPE=' . $components['tableType'] : '');
(issue imported from #M17629)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.