Red Hat Bugzilla – Bug 116070
Changing the "Product" field gives an error message.
Last modified: 2007-04-18 13:03:16 EDT
I tried to change bug 112207 from "Product: Bugzilla" to "Product: Red
Hat Linux" and got an error message. Unfortunatelly, I did not write
it down - I pressed back, thinking I will be able to reproduce it
later, but it turned out that the change actually succeeded (at least
up to some point).
Just tried changing the "Product" field of the bug 35236 and got:
SELECT profiles.login_name, profiles.userid, votes.count,
products.votesperuser, products.maxvotesperbug FROM profiles LEFT JOIN
votes ON profiles.userid = votes.who LEFT JOIN bugs USING(bug_id) LEFT
JOIN products ON products.id = bugs.product_id WHERE votes.bug_id =
35236 : ERROR: Attribute profiles.login_name must be GROUPed or used
in an aggregate function at globals.pl line 337.
For help, please send mail to the webmaster (firstname.lastname@example.org),
giving this error message and the time and date of the error.
P.S. Not sure whether this is another side of the same problem, or a
separate one, but after I change the Product field, the "Bug Activity"
respectively) do _not_ have any mention of the product change, only
showing the corresponding component change.
P.P.S. Forgot to say in comment #2 - in bug 35236 I was changing the
Product from "Red Hat Raw Hide" to "Fedora Core" (so it probably does
not depend on the specific old/new values of the field).
The failure in comment #1 was due to a schema change recently made.
Changing votes.count to votes.vote_count in the cgi code should fix
that from occuring again. Anything after the offending code failed to
execute which is why the bug report was left uncompleted. Closing, but
reopen if you see this again.