Hello, guest. We have noticed that you are not registered at this bug tracker. Your experience will be greatly enhanced if you log in. To do so, you first must register by clicking on the Register tab at the top. If you are already registered, you can login at the Login tab.
Syndicate Syndicate Listing Display Search Login/Register
Bug Id ?
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 07: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 07: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

October 4, 2006 06: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 5, 2006 12:29 AM 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.

October 5, 2006 01:04 AM
Ahh... yes, your right about the diff.