Bug #23463 Bug Fixed

EE4 DB Create Table Charset Error

Version: 4.0.9 Reporter: obfuscode

In EE4, the enforceCharsetAndCollation() method in mysqli_connection.php adds: $want = "\\1CHARACTER SET {$charset} COLLATE {$collation}"; whereas in EE3 it added: $want = "DEFAULT CHARACTER SET {$charset} COLLATE {$collation}"; without the \\1.

If the conditional fails, the $want is appended to the $query raw without removing the \1 which makes the query fail.

I modifed line 249 of mysqli_connection.php from this: $query .= ' '.$want.';'; to this: $query .= ' '.substr($want, 2).';';

  • Nobody has said anything yet.

You must be signed in to comment on a bug report.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases