From 9d9a3e65518f04fc0001bc41b1bc3a56b48bc51b Mon Sep 17 00:00:00 2001
From: Robert Sesek <rsesek@bluestatic.org>
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.43.5