From 042f3f2622e1adbc7546cfa25a5d138486b99341 Mon Sep 17 00:00:00 2001 From: Florian Pritz Date: Mon, 14 Jan 2019 20:44:12 +0100 Subject: Quote MySql 8.0 reserved keywords Signed-off-by: Florian Pritz Signed-off-by: Eli Schwartz --- web/lib/aurjson.class.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'web/lib/aurjson.class.php') diff --git a/web/lib/aurjson.class.php b/web/lib/aurjson.class.php index c51e9c26..c275d214 100644 --- a/web/lib/aurjson.class.php +++ b/web/lib/aurjson.class.php @@ -284,10 +284,10 @@ class AurJSON { "LEFT JOIN RelationTypes " . "ON RelationTypes.ID = PackageRelations.RelTypeID " . "WHERE PackageRelations.PackageID = " . $pkgid . " " . - "UNION SELECT 'groups' AS Type, Groups.Name, '' AS Cond " . - "FROM Groups INNER JOIN PackageGroups " . + "UNION SELECT 'groups' AS Type, `Groups`.`Name`, '' AS Cond " . + "FROM `Groups` INNER JOIN PackageGroups " . "ON PackageGroups.PackageID = " . $pkgid . " " . - "AND PackageGroups.GroupID = Groups.ID " . + "AND PackageGroups.GroupID = `Groups`.ID " . "UNION SELECT 'license' AS Type, Licenses.Name, '' AS Cond " . "FROM Licenses INNER JOIN PackageLicenses " . "ON PackageLicenses.PackageID = " . $pkgid . " " . -- cgit v1.2.3-24-g4f1b