From 6b743f8630607f00884bbfdcfec60b9c9a833214 Mon Sep 17 00:00:00 2001 From: Marcel Werk Date: Wed, 12 Oct 2011 20:07:35 +0200 Subject: [PATCH] SQL query fixed query wasn't compatible with PostgreSQL --- wcfsetup/install/files/lib/data/package/Package.class.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/wcfsetup/install/files/lib/data/package/Package.class.php b/wcfsetup/install/files/lib/data/package/Package.class.php index 0eea3bdd5e..48e397e53c 100644 --- a/wcfsetup/install/files/lib/data/package/Package.class.php +++ b/wcfsetup/install/files/lib/data/package/Package.class.php @@ -496,7 +496,7 @@ class Package extends DatabaseObject { $currentPrefix = strtoupper(Package::getAbbreviation($package->package)); // get dependencies (only standalones) - $sql = "SELECT package.*, IF(package.packageID = ?, 1, 0) AS sortOrder + $sql = "SELECT package.*, CASE WHEN package.packageID = ? THEN 1 ELSE 0 END AS sortOrder FROM wcf".WCF_N."_package_dependency package_dependency LEFT JOIN wcf".WCF_N."_package package ON (package.packageID = package_dependency.dependency) -- 2.20.1