Listing Display
Bug Id ?
28
Reporter ?
Product/Version ?
Bugdar / 1.1.0
Status ?
Closed
Severity ?
Trivial
Duplicate Of ?
- none -
Fixed in Revision ?
1234
Mstone ?
Summary ?
SQL Error in Product Page
Report Time ?
October 4, 2006 06:27 AM
Assignment ?
- none -
Resolution ?
Fixed
Priority ?
Normal
Dependencies ?
- none -
Mstone (old) ?


Attachments
patch.diff Final patch
Votes
For: 0 (0%)
Against: 0 (0%)
Total: 0

October 4, 2006 06:27 AM
Hi,
I haven't tested this yet but I think we need the following patched:

--- admin/product.php 2006-10-04 16:22:06.832752000 +1000
+++ Bugdar_1-1-0/upload/admin/product.php 2006-10-04 13:00:05.000000000 +1000
@@ -83,7 +83,7 @@
{
$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 version = " . $bugsys->in['versionid']);
+ $db->query("DELETE FROM " . TABLE_PREFIX . "bug WHERE versionid = " . $bugsys->in['versionid']);

build_versions();

@@ -194,7 +194,7 @@

$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 product IN (" . implode(', ', $list) . ")");
+ $db->query("DELETE FROM " . TABLE_PREFIX . "bug WHERE productid IN (" . implode(', ', $list) . ")");

build_products();

Terry

On October 4, 2006 05:23 PM, Robert changed:
October 4, 2006 05:26 PM Robert
By the way, your diff is in the wrong direction... confused me there for a second. But thanks for the report. I'll be releasing 1.1.1 sometime next week to wait for any more bugs in 1.1.0.

October 4, 2006 11:29 PM Robert
Thank you for your bug report. This issue has been closed and fixed in Subversion. This change will be available in a future release, but you can download the change at any time from the Subversion server.

On October 4, 2006 11:29 PM, Robert changed:
October 5, 2006 12:04 AM
Ahh... yes, your right about the diff.

On October 10, 2006 03:59 AM, Robert changed: