diff options
author | Morris Jobke <hey@morrisjobke.de> | 2018-02-16 22:55:23 +0100 |
---|---|---|
committer | GitHub <noreply@github.com> | 2018-02-16 22:55:23 +0100 |
commit | 45e7bb7f409d8d4585ef6f8cea76b422e246c2de (patch) | |
tree | d2e68dc24b5abe3580ff8a3002b5bc7cea710835 | |
parent | 8b3e703c53b71470766bd9da6e8ed55605e45b8a (diff) | |
parent | 6aa816915af99090057b10a5540b0eba1e6d856d (diff) | |
download | nextcloud-server-45e7bb7f409d8d4585ef6f8cea76b422e246c2de.tar.gz nextcloud-server-45e7bb7f409d8d4585ef6f8cea76b422e246c2de.zip |
Merge pull request #8391 from coder-hugo/feature/mysql_ansi_quotes
Don't use double quotes in MySQL queries
-rw-r--r-- | lib/private/Repair/Collation.php | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/lib/private/Repair/Collation.php b/lib/private/Repair/Collation.php index 2642985371b..f2cc9373176 100644 --- a/lib/private/Repair/Collation.php +++ b/lib/private/Repair/Collation.php @@ -6,6 +6,7 @@ * @author Morris Jobke <hey@morrisjobke.de> * @author Robin Appelman <robin@icewind.nl> * @author Thomas Müller <thomas.mueller@tmit.eu> + * @author Robin Müller <robin.mueller@1und1.de> * * @license AGPL-3.0 * @@ -124,7 +125,7 @@ class Collation implements IRepairStep { " FROM INFORMATION_SCHEMA . COLUMNS" . " WHERE TABLE_SCHEMA = ?" . " AND (COLLATION_NAME <> '" . $characterSet . "_bin' OR CHARACTER_SET_NAME <> '" . $characterSet . "')" . - " AND TABLE_NAME LIKE \"*PREFIX*%\"", + " AND TABLE_NAME LIKE '*PREFIX*%'", array($dbName) ); $rows = $statement->fetchAll(); @@ -139,7 +140,7 @@ class Collation implements IRepairStep { " FROM INFORMATION_SCHEMA . TABLES" . " WHERE TABLE_SCHEMA = ?" . " AND TABLE_COLLATION <> '" . $characterSet . "_bin'" . - " AND TABLE_NAME LIKE \"*PREFIX*%\"", + " AND TABLE_NAME LIKE '*PREFIX*%'", [$dbName] ); $rows = $statement->fetchAll(); |