71020 - Error trying to edit components

Status: VERIFIED WORKSFORME

(Bugzilla :: Bugzilla-General, defect)

Description

[Brian Z]

In the latest CVS update, when I try to edit components, I get the following
error:

Software error:

select login_name from profiles where userid = [e-mail]: You have an
error in your SQL syntax near '@brianz.net' at line 1 at globals.pl line 171. 

For help, please send mail to the webmaster (root@localhost), giving this error
message and the time and date of the error. 

Thanks!

Comment 1

[Dave Miller [:justdave]]

can you provide any more details?  I am unable to reproduce this.  Is it giving 
you this error on any other pages?  What exactly are you typing in the form, or 
are you getting this just trying to load the page to begin with?  Are you logged 
in yet at the time?  etc.

Comment 2

[Jacob Steenhagen]

Just looked through the code and it appears the only place that 
"select login_name from profiles where userid =" is used is in globals.pl at
line 620 (inside of the DBID_to_name sub).  It appears that everyplace
DBID_to_name is called it is being called with the db id... but this software
error suggests that it's being called instead with the e-mail address (login_name).

Can you provide any more detail about which screen you were on when you saw this
error (I've been unable to reproduce it)?  Also, are you sure that your CVS pull
was 100% clean (no conflicts)?

Comment 3

[Brian Z]

I just setup the bugzilla server a little bit ago. Everything was working fine
until I cvs update (ed) it.  The update went clean, and everything was fine.  If
you want to log in and take a look, go to the above URL, login [e-mail]
password: sndbxhgf .  I'm using it personally right now, so there is no real
problem if something bad happens.  Go to query | Edit bugzilla products and
components, click on any of the products, click edit components.

Hrm.. just ran a sanity check, and the DB has a few errors in it.  Looks like
something is really messed up somewhere.  The components aren't even appearing
in the query window, yet when you add, there are there.  Alos, only bug 4 shows.
 Hrm..... guess one of thse interesting cases.  

Looks like this one is my prob.  That's what happens when you stay on the
cutting development edge. :)  Thanks for the time!

Comment 4

[Dave Miller [:justdave]]

did you run checksetup.pl from the shell after you ran cvs update?

Comment 5

[Brian Z]

Nope. :)  That's probably where I went wrong.  Didn't even think too.

Comment 6

[Dave Miller [:justdave]]

per reporters comments.... worksforme

Comment 7

[Brian Z]

vrfy.  Thanks for your help!

Comment 8

[Dave Miller [:justdave]]

moving to Bugzilla product
reassign to default owner/qa for INVALID/WONTFIX/WORKSFORME/DUPLICATE