summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorLukas Fleischer <lfleischer@archlinux.org>2017-08-08 15:33:25 +0200
committerLukas Fleischer <lfleischer@archlinux.org>2017-08-08 15:33:25 +0200
commit624d168b22ef48b304d09c4ef8c58b78dc061e92 (patch)
treeb35767e489d21dd519bd9c44c0a07c2579d14cc7
parente0d3fbfdf1fa421800051c265e1f4f2f9d2466cb (diff)
downloadaur-624d168b22ef48b304d09c4ef8c58b78dc061e92.tar.gz
aur-624d168b22ef48b304d09c4ef8c58b78dc061e92.zip
git-serve: Fix broken SQL statement
Add a missing space to the SQL statement performing the disown operation. Fixes FS#55068. Note that the broken query was not discovered by the test suite since SQLite parses "?AND" inside prepared statements gracefully while MySQL does not. Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
-rwxr-xr-xaurweb/git/serve.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/aurweb/git/serve.py b/aurweb/git/serve.py
index eea0c9c..dfaddd1 100755
--- a/aurweb/git/serve.py
+++ b/aurweb/git/serve.py
@@ -192,7 +192,7 @@ def pkgreq_by_pkgbase(pkgbase_id, reqtype):
"INNER JOIN RequestTypes ON " +
"RequestTypes.ID = PackageRequests.ReqTypeID " +
"WHERE PackageRequests.Status = 0 " +
- "AND PackageRequests.PackageBaseID = ?" +
+ "AND PackageRequests.PackageBaseID = ? " +
"AND RequestTypes.Name = ?", [pkgbase_id, reqtype])
return [row[0] for row in cur.fetchall()]