summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorAndy Scherzinger <info@andy-scherzinger.de>2025-03-04 21:47:29 +0100
committerGitHub <noreply@github.com>2025-03-04 21:47:29 +0100
commit7381387d24fb3962136b3249be4b6b478f190c29 (patch)
tree80ef6015b554e59f96fa5424b56c2539e556421c
parentc4669ba439e13acff3662ef8407d4961a60ec659 (diff)
parentddebea24c21e7e04d6bb114abb5bac0db95c4e5e (diff)
downloadnextcloud-server-7381387d24fb3962136b3249be4b6b478f190c29.tar.gz
nextcloud-server-7381387d24fb3962136b3249be4b6b478f190c29.zip
Merge pull request #51091 from nextcloud/backport/51069/stable31
[stable31] Fix SQL query so that it is ansi safe fixing #51067
-rw-r--r--apps/settings/lib/SetupChecks/MysqlRowFormat.php6
1 files changed, 3 insertions, 3 deletions
diff --git a/apps/settings/lib/SetupChecks/MysqlRowFormat.php b/apps/settings/lib/SetupChecks/MysqlRowFormat.php
index 17e7fc6696b..3c27b73db89 100644
--- a/apps/settings/lib/SetupChecks/MysqlRowFormat.php
+++ b/apps/settings/lib/SetupChecks/MysqlRowFormat.php
@@ -56,11 +56,11 @@ class MysqlRowFormat implements ISetupCheck {
* @return string[]
*/
private function getRowNotDynamicTables(): array {
- $sql = 'SELECT table_name
+ $sql = "SELECT table_name
FROM information_schema.tables
WHERE table_schema = ?
- AND table_name LIKE "*PREFIX*%"
- AND row_format != "Dynamic";';
+ AND table_name LIKE '*PREFIX*%'
+ AND row_format != 'Dynamic';";
return $this->connection->executeQuery(
$sql,