Bug 116070 - Changing the "Product" field gives an error message.
Summary: Changing the "Product" field gives an error message.
Alias: None
Product: Bugzilla
Classification: Community
Component: Bugzilla General
Version: 2.17
Hardware: All
OS: Linux
medium vote
Target Milestone: ---
Assignee: David Lawrence
QA Contact: David Lawrence
Depends On:
TreeView+ depends on / blocked
Reported: 2004-02-18 01:07 UTC by Aleksey Nogin
Modified: 2007-04-18 17:03 UTC (History)
0 users

Clone Of:
Last Closed: 2004-02-18 07:00:08 UTC

Attachments (Terms of Use)

Description Aleksey Nogin 2004-02-18 01:07:10 UTC
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).

Comment 1 Aleksey Nogin 2004-02-18 03:01:49 UTC
Just tried changing the "Product" field of the bug 35236 and got:

Software error:

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 (bugzilla@redhat.com),
giving this error message and the time and date of the error. 

Comment 2 Aleksey Nogin 2004-02-18 03:09:47 UTC
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"
pages (https://bugzilla.redhat.com/bugzilla/show_activity.cgi?id=35236
and https://bugzilla.redhat.com/bugzilla/show_activity.cgi?id=112207
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).

Comment 3 David Lawrence 2004-02-18 07:00:08 UTC
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.

Note You need to log in before you can comment on or make changes to this bug.