Closed Bug 276831 Opened 20 years ago Closed 20 years ago

editgroupcontols fails with SQL error if you specify an empty/invalid product

Categories

(Bugzilla :: Administration, task)

Product:
Bugzilla
Component:
Administration
Version:
2.19.1
Platform:
x86
Windows XP
Type:
task
Priority:
Not set
Severity:
minor

Tracking

()

Status:
VERIFIED DUPLICATE of bug 240250

People

(Reporter: timeless, Assigned: justdave)

References

(
URL
)

Details

Software error:

DBD::mysql::st execute failed: You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version for the right syntax to use
near 'JOIN bug_group_map ON bug_group_map.group_id = groups.id LEFT J [for
statement ``SELECT id, name, entry, membercontrol, othercontrol, canedit,
isactive, COUNT(bugs.bug_id) FROM groups LEFT JOIN group_control_map ON
group_control_map.group_id = id AND group_control_map.product_id =  LEFT JOIN
bug_group_map ON bug_group_map.group_id = groups.id LEFT JOIN bugs ON
bugs.bug_id = bug_group_map.bug_id AND bugs.product_id =  WHERE isbuggroup != 0
AND (isactive != 0 OR entry IS NOT NULL OR bugs.bug_id IS NOT NULL) GROUP BY
name'']) at Bugzilla/DB.pm line 62
	Bugzilla::DB::SendSQL('SELECT id, name, entry, membercontrol, othercontrol,
canedit, is...') called at /opt/webtools/bugzilla/editproducts.cgi line 1462

For help, please send mail to the webmaster (webmaster@mozilla.org), giving this
error message and the time and date of the error.
Summary: editgroups DBD::mysql::st execute failed: You have an error in your SQL syntax. → editgroupcontols fails with SQL error if you specify an empty/invalid product
timeless, you already submitted this bug twice....

I have a patch for this bug already, I will submit it in the following two hours. ;)


*** This bug has been marked as a duplicate of 240250 ***
Status: UNCONFIRMED → RESOLVED
Closed: 20 years ago
Resolution: --- → DUPLICATE
Status: RESOLVED → VERIFIED
QA Contact: matty_is_a_geek → default-qa
You need to log in before you can comment on or make changes to this bug.