From 9d9a3e65518f04fc0001bc41b1bc3a56b48bc51b Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Wed, 4 Oct 2006 23:37:35 +0000 Subject: [PATCH] r1234: Let's get rid of some SQL errors, mmk? --- admin/product.php | 4 ++-- docs/changes.txt | 1 + 2 files changed, 3 insertions(+), 2 deletions(-) diff --git a/admin/product.php b/admin/product.php index 1abeb74..703fc80 100755 --- a/admin/product.php +++ b/admin/product.php @@ -83,7 +83,7 @@ if ($_REQUEST['do'] == 'killversion') { $bugsys->input_clean('versionid', TYPE_UINT); $db->query("DELETE FROM " . TABLE_PREFIX . "version WHERE versionid = " . $bugsys->in['versionid']); - $db->query("DELETE FROM " . TABLE_PREFIX . "bug WHERE versionid = " . $bugsys->in['versionid']); + $db->query("DELETE FROM " . TABLE_PREFIX . "bug WHERE version = " . $bugsys->in['versionid']); build_versions(); @@ -194,7 +194,7 @@ if ($_REQUEST['do'] == 'killproduct') $db->query("DELETE FROM " . TABLE_PREFIX . "product WHERE productid IN (" . implode(', ', $list) . ")"); $db->query("DELETE FROM " . TABLE_PREFIX . "version WHERE productid IN (" . implode(', ', $list) . ")"); - $db->query("DELETE FROM " . TABLE_PREFIX . "bug WHERE productid IN (" . implode(', ', $list) . ")"); + $db->query("DELETE FROM " . TABLE_PREFIX . "bug WHERE product IN (" . implode(', ', $list) . ")"); build_products(); diff --git a/docs/changes.txt b/docs/changes.txt index e7b75ae..3e45cd7 100644 --- a/docs/changes.txt +++ b/docs/changes.txt @@ -5,6 +5,7 @@ - Use the correct language variable key for exporting the XML encoding in syndicate.php - API-level errors are not caught in the registration process before insertion because of user_cumulative [register.php] - Remove warnings on explain.php?do=products (http://www.bluestatic.org/bugs/showreport.php?bugid=29) +- Removed SQL errors when deleting a product or version due to bad column names (http://www.bluestatic.org/bugs/showreport.php?bugid=28) [admin/product.php] 1.1.0 =============================== -- 2.22.5