Description of problem:
Code in modules called by checksetup.pl calls Bugzilla::Hook which does does a do() on each extension code script. The extensions/redhat_fields/code/filter_custom_fields.pl in particular crashes checksetup.pl as it tries to load its values before checksetup.pl has had a chance to add the new visibility_value_id field to bug_cf_partner table.
DBD::mysql::db selectall_arrayref failed: Unknown column 'visibility_value_id' in 'field list' [for Statement "SELECT id,value,sortkey,isactive,visibility_value_id FROM cf_partner ORDER BY sortkey, value"] at Bugzilla/Object.pm line 229
Bugzilla::Object::_do_list_select('Bugzilla::Field::Choice::cf_partner') called at Bugzilla/Object.pm line 410
Bugzilla::Object::get_all('Bugzilla::Field::Choice::cf_partner') called at Bugzilla/Field.pm line 510
Bugzilla::Field::legal_values('Bugzilla::Field=HASH(0x10f3f490)') called at Bugzilla/User.pm line 1054
Bugzilla::User::can_set_targetrelease('Bugzilla::User=HASH(0xd0f2a30)') called at ./extensions/redhat_fields/code/filter_custom_fields.pl line 40
require ./extensions/redhat_fields/code/filter_custom_fields.pl called at Bugzilla/Hook.pm line 51
Bugzilla::Hook::process('filter_custom_fields', 'HASH(0xdd79180)') called at Bugzilla.pm line 542
If you move the extensions/redhat_fields/code/filter_custom_fields.pl out of the way and re-run checksetup.pl the process is allowed to continue without error.
How can I reproduce this error? by running checksetup.pl on bz-web1? I tried running it there but got no errors.
(In reply to comment #1)
> Hey Dave,
> How can I reproduce this error? by running checksetup.pl on bz-web1? I tried
> running it there but got no errors.
I didn't get this errors either when I ran checksetup.pl on bz-web1. But I think it may happen if there are some inconsistency between the table definition in bz_schema table and actual tables. For example, in bz_schema table, the cf_partner has the 'visibility_value_id' column but the actual cf_partner doesn't include that column.
I will ask our system admin to re-import the data to bugs34 on bz-db1 and run checksetup.pl again and see if we can get that error.
I tried to remove visibility_value_id from the cf_partner table and then reran checksetup.pl but it has given me a different error related to ThrowTemplateError, please let me know how the data refresh will go.
After refresh the data on bugs34 on bz-db1-test, still couldn't reproduced the error.
Close this bug now and will reopen it if this error occurs again.
This reoccured on partner-bugzilla.redhat.com when doing 3.2 to 3.4 migration.
Undefined subroutine &Bugzilla::Util::ThrowTemplateError called at Bugzilla/Util.pm line 628.
Fix: touch extensions/redhat_fields/disabled
Is this fixed now?
I would say so. This has not happened the last two times that we converted the live db on partner-bugzilla. I wish I knew why this is not failing anymore but did before for me. We can just keep an eye out for it in the future I guess.