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 ?
28
Reporter ?
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: