Hi,

when i upgrading bugzilla i am getting few errors I have posted earlier issues in earlier also.this is new error so i am raising new one.

I am struggling a lot at the end of upgradation below is the error.

ERROR: There are invalid values for the qa_contact column in the bugs
table. (These values do not exist in the profiles table, in the userid
column.) Before continuing with checksetup, you will need to fix these
values, either by deleting these rows from the database, or changing
the values of qa_contact in bugs to point to valid values in
profiles.userid. The bad values from the bugs.qa_contact column are: 4,
5, 8, 9, 10, 12, 13, 16, 17, 18, 19, 20, 21, 23, 25, 26, 27, 28, 30,
32, 33, 34, 35, 36, 37, 40, 41, 45, 46, 47, 49, 51, 52, 53, 54, 58, 61,
62, 63, 68, 70, 73, 74, 85, 90, 91, 92, 95, 101, 102, 103, 112, 122,
124, 126, 129, 135, 142, 156, 157, 161, 166, 172, 175, 178, 207, 208,
209, 212, 215, 216, 221, 222, 223, 224, 226, 231, 237, 238, 239, 240,
242, 245, 248, 250, 251, 253, 254, 257, 258, 259, 260, 261, 262, 267,
270, 273, 276, 278, 279

1. It is asking me to fix if possible please share the steps
2. In case it is not possible to fix, let me how to find which tables have problem and how t find the columns to delete exactly these columns in mysql and also i need to take backup of these columns so that i can use this after upgrade completes

Please help me am new to mysql

Maybe you can add the missing values in the profiles table to fill the missing dependency?

Please share the steps so how to add missing values from bugs table in qa_contact to profiles table in userid column.

I guess you have to add the users with these IDs to the table profiles or delete the bugs in the bugs table that were edited by these users:
4, 5, 8, 9, 10, 12, 13, 16, 17, 18, 19, 20, 21, 23, 25, 26, 27, 28, 30,
32, 33, 34, 35, 36, 37, 40, 41, 45, 46, 47, 49, 51, 52, 53, 54, 58, 61,
62, 63, 68, 70, 73, 74, 85, 90, 91, 92, 95, 101, 102, 103, 112, 122,
124, 126, 129, 135, 142, 156, 157, 161, 166, 172, 175, 178, 207, 208,
209, 212, 215, 216, 221, 222, 223, 224, 226, 231, 237, 238, 239, 240,
242, 245, 248, 250, 251, 253, 254, 257, 258, 259, 260, 261, 262, 267,
270, 273, 276, 278, 279

Do you have a graphic frontend to the mysql like phpMyAdmin or do you know SQL?

Hi dont know mysql and i dont have frontend to manage..please share steps it would be helpful

I think you do have frontend (or at least you can easily install it). Create a new database - and check how does it work. http://www.elated.com/articles/mysql...ute-beginners/ or http://www3.ntu.edu.sg/home/ehchua/p..._Beginner.html
(or search for another tutorial)