200584 - Software Error occurs when trying to logon or add new user

Status: RESOLVED WORKSFORME

(Bugzilla :: Installation & Upgrading, defect)

Description

[Kenny Pyles]

User-Agent:       Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; yie6_SBCDSL; sbcydsl 3.12; YComp 5.0.0.0)
Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) 

Error message:
select bit, userregexp from groups where userregexp != '': Unknown column 'bit' 
in 'field list' at globals.pl line 276
occurs when I try to create a new user.

Reproducible: Always

Steps to Reproduce:
1.Start up Bugzilla http://tourmaline/bugzilla-2.16.2/index.cgi
2.Select Create New User Account
3.Enter email and password and click Submit
4. You will then get the error message



In addition I get the following error messages when I ran checksetup.pl

21:48 2003] checksetup.pl: DBD::mysql::st execute failed: Unknown 
column 'product' in 'field list' 
at ./checksetup.pl line 2072.
Updating field type program in table components ...
old:  not null
new: varchar(64)
DBD::mysql::db do failed: Unknown column 'program' in 'components' 
at ./checksetup.pl line 2123.
[Thu Apr  3 15:21:48 2003] checksetup.pl: DBD::mysql::db do failed: Unknown 
column 'program' in 'components' 
at ./checksetup.pl line 2123.
Updating field type product in table bugs ...
old:  not null
new: varchar(64) not null
DBD::mysql::db do failed: Unknown column 'product' in 'bugs' at ./checksetup.pl 
line 2123.
[Thu Apr  3 15:21:48 2003] checksetup.pl: DBD::mysql::db do failed: Unknown 
column 'product' in 'bugs' 
at ./checksetup.pl line 2123.
Updating field type program in table components ...
old:  not null
new: varchar(64)
DBD::mysql::db do failed: Unknown column 'program' in 'components' 
at ./checksetup.pl line 2123.
[Thu Apr  3 15:21:48 2003] checksetup.pl: DBD::mysql::db do failed: Unknown 
column 'program' in 'components' 
at ./checksetup.pl line 2123.
Updating field type product in table products ...
old:  not null
new: varchar(64)
DBD::mysql::db do failed: Unknown column 'product' in 'products' 
at ./checksetup.pl line 2123.
[Thu Apr  3 15:21:48 2003] checksetup.pl: DBD::mysql::db do failed: Unknown 
column 'product' in 'products' 
at ./checksetup.pl line 2123.
Updating field type program in table versions ...
old:  not null
new: varchar(64) not null
DBD::mysql::db do failed: Unknown column 'program' in 'versions' 
at ./checksetup.pl line 2123.
[Thu Apr  3 15:21:48 2003] checksetup.pl: DBD::mysql::db do failed: Unknown 
column 'program' in 'versions' at ./checksetup.pl line 2123.
Populating duplicates table...
Reminder: Bugzilla now requires version 8.7 or later of sendmail.

Comment 1

[Bradley Baetz (:bbaetz)]

Ok... something went wrong with checksetup. What version were you upgrading
from? IF you go back to your backups from before the upgrade, can you attach the
resultof upgrading from that?

Are you running checksetup from the webserver?? Thats what those logs look like.
Checksetp.pl is a cmdline app, not a webserver one.

Comment 2

[Kenny Pyles]

Just for the record I am actually attempting a new install; however, I did 
previously attempt to install the Red Hat version of Bugzilla but ran into 
problems because I am using MySQL not PgSQL.  

Also, I am running all commands from the command line including ./checksetup.pl

The one thing I did not do was completely delete the bugs MySQL database before 
I began this new install.

I would appreciate any quidence.

Comment 3

[Bradley Baetz (:bbaetz)]

Upgrading from the RH pgsql version won't work.

Ifyou have a ocmpletely new database, then I don't see how we could be getting
this - none of the upgrade code should be running. What mysql version do you have?

Comment 4

[Kenny Pyles]

This issue may be closed.  I solved the problem by re-creating the bugs
database.