Fix inappropriate SQL-quoting in imap.phpv13.0.9RC2v13.0.9RC1v13.0.9v13.0.8RC2v13.0.8RC1v13.0.8v13.0.7RC2v13.0.7RC1v13.0.7v13.0.6RC1v13.0.6v13.0.5RC2v13.0.5RC1v13.0.5v13.0.4v13.0.3RC2v13.0.3RC1v13.0.3v13.0.2RC1v13.0.2v13.0.1RC1v13.0.12RC1v13.0.12v13.0.11RC1v13.0.11v13.0.10v13.0.1v13.0.0RC4v13.0.0stable13

External user-authentification against IMAP-gateways:
Commit f8fb4d9 broke compatibility with PostgreSQL due to inappropriate SQL-quoting.

1 files changed, 5 insertions, 5 deletions

diff --git a/user_external/lib/imap.php b/user_external/lib/imap.php
index e53fb4605..046ba94c6 100644
--- a/user_external/lib/imap.php
+++ b/user_external/lib/imap.php
@@ -52,11 +52,11 @@ class OC_User_IMAP extends \OCA\user_external\Base {
 			$uid = str_replace("%40","@",$uid);
 		}
 
-		$result = OC_DB::executeAudited(
-			'SELECT `userid` FROM `*PREFIX*preferences`'
-			. ' WHERE `appid` = "settings" AND `configkey` = "email" AND `configvalue` = ?',
-			array($uid)
-		);
+                $result = OC_DB::executeAudited(
+                        'SELECT `userid` FROM `*PREFIX*preferences` WHERE `appid`=? AND `configkey`=? AND `configvalue`=?',
+                        array('settings','email',$uid)
+                );
+
 		$users = array();
 		while ($row = $result->fetchRow()) {
 			$users[] = $row['userid'];