uninitialized value warnings when running checksetup.pl

RESOLVED FIXED

Status

Testopia
General
RESOLVED FIXED
9 years ago
9 years ago

People

(Reporter: richlv, Assigned: Greg Hendricks)

Tracking

Details

(Reporter)

Description

9 years ago
User-Agent:       Opera/9.27 (X11; Linux i686; U; en)
Build Identifier: cvs

fresh install of bugzilla, testopia (current cvs) and a fresh db.
running checksetup.pl shows a lot of warnings about uninitialized values :

Checking Testopia setup ...
Use of uninitialized value in string eq at Bugzilla/Util.pm line 301.
Use of uninitialized value in string eq at Bugzilla/Util.pm line 301.
Use of uninitialized value in string eq at Bugzilla/Util.pm line 301.
Use of uninitialized value in string eq at Bugzilla/Util.pm line 301.
Use of uninitialized value in string eq at Bugzilla/Util.pm line 301.
Use of uninitialized value in string eq at Bugzilla/Util.pm line 301.
Use of uninitialized value in string ne at Bugzilla/Util.pm line 309.
...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
...
Adding foreign key: attachments.submitter_id -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: bugs_activity.who -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: bugs_fulltext.bug_id -> bugs.bug_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: cc.who -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: component_cc.user_id -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: components.initialowner -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: components.initialqacontact -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: email_setting.user_id -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: logincookies.userid -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: namedqueries.userid -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: namedqueries_link_in_footer.namedquery_id -> namedqueries.id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: namedqueries_link_in_footer.user_id -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: profile_setting.user_id -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: profiles_activity.userid -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: profiles_activity.who -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: profiles_activity.fieldid -> fielddefs.id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_attachment_data.attachment_id -> test_attachments.attachment_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_attachments.submitter_id -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_builds.product_id -> products.id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_activity.case_id -> test_cases.case_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_activity.fieldid -> test_fielddefs.fieldid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_activity.who -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_attachments.attachment_id -> test_attachments.attachment_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_attachments.case_id -> test_cases.case_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_attachments.case_run_id -> test_case_runs.case_run_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_bugs.bug_id -> bugs.bug_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_bugs.case_run_id -> test_case_runs.case_run_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_bugs.case_id -> test_cases.case_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_categories.product_id -> products.id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_components.case_id -> test_cases.case_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_components.component_id -> components.id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_plans.plan_id -> test_plans.plan_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_plans.case_id -> test_cases.case_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_runs.run_id -> test_runs.run_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_runs.case_id -> test_cases.case_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_runs.assignee -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_runs.testedby -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_runs.case_run_status_id -> test_case_run_status.case_run_status_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_runs.build_id -> test_builds.build_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_runs.environment_id -> test_environments.environment_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_tags.tag_id -> test_tags.tag_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_tags.case_id -> test_cases.case_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_tags.userid -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_texts.case_id -> test_cases.case_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_case_texts.who -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_cases.case_status_id -> test_case_status.case_status_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_cases.category_id -> test_case_categories.category_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_cases.priority_id -> priority.id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_cases.author_id -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_cases.default_tester_id -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_email_settings.userid -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_email_settings.eventid -> test_events.eventid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_email_settings.relationship_id -> test_relationships.relationship_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_environment_element.env_category_id -> test_environment_category.env_category_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_environment_map.environment_id -> test_environments.environment_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_environment_map.property_id -> test_environment_property.property_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_environment_map.element_id -> test_environment_element.element_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_environment_property.element_id -> test_environment_element.element_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_environments.product_id -> products.id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_named_queries.userid -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_plan_activity.plan_id -> test_plans.plan_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_plan_activity.fieldid -> test_fielddefs.fieldid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_plan_activity.who -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_plan_attachments.attachment_id -> test_attachments.attachment_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_plan_attachments.plan_id -> test_plans.plan_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_plan_permissions.userid -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_plan_permissions.plan_id -> test_plans.plan_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_plan_permissions_regexp.plan_id -> test_plans.plan_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_plan_tags.tag_id -> test_tags.tag_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_plan_tags.plan_id -> test_plans.plan_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_plan_tags.userid -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_plan_texts.plan_id -> test_plans.plan_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_plan_texts.who -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_plans.product_id -> products.id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_plans.author_id -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_plans.type_id -> test_plan_types.type_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_run_activity.run_id -> test_runs.run_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_run_activity.fieldid -> test_fielddefs.fieldid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_run_activity.who -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_run_cc.run_id -> test_runs.run_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_run_cc.who -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_run_tags.tag_id -> test_tags.tag_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_run_tags.run_id -> test_runs.run_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_run_tags.userid -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_runs.plan_id -> test_plans.plan_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_runs.environment_id -> test_environments.environment_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_runs.build_id -> test_builds.build_id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_runs.manager_id -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: test_runs.default_tester_id -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: tokens.userid -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: votes.who -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: watch.watcher -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: watch.watched -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: whine_events.owner_userid -> profiles.userid...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: whine_queries.eventid -> whine_events.id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.
Adding foreign key: whine_schedules.eventid -> whine_events.id...
Use of uninitialized value in exists at Bugzilla/DB/Schema.pm line 1433.


Reproducible: Always
(Assignee)

Comment 1

9 years ago
I have been noticing these as well. 
Max, any ideas?
Status: UNCONFIRMED → NEW
Ever confirmed: true

Comment 2

9 years ago
Can you show me what those lines of code are?
(Assignee)

Comment 3

9 years ago
            # Replace abstract default values (such as 'TRUE' and 'FALSE')
            # with their database-specific implementations.
HERE ====>  if (exists($field_def->{DEFAULT})
                && exists($db_specific->{$field_def->{DEFAULT}})) {
                $field_def->{DEFAULT} = $db_specific->{$field_def->{DEFAULT}};
            }

Comment 4

9 years ago
(In reply to comment #3)
>             # Replace abstract default values (such as 'TRUE' and 'FALSE')
>             # with their database-specific implementations.
> HERE ====>  if (exists($field_def->{DEFAULT})
>                 && exists($db_specific->{$field_def->{DEFAULT}})) {

  This means that you have fields that have "DEFAULT => undef" which makes no sense.
(Assignee)

Comment 5

9 years ago
    Checking in extensions/testopia/code/install-update_db.pl;
    /cvsroot/mozilla/webtools/testopia/extensions/testopia/code/install-update_db.pl,v  <--  install-update_db.pl
    new rev
Status: NEW → RESOLVED
Last Resolved: 9 years ago
Resolution: --- → FIXED

Comment 6

9 years ago
I just picked up this latest fix (install-update_db.pl rev 1.14).  

After running ./checksetup.pl I no longer get the "Use of uninitialized value in string eq at Bugzilla/Util.pm line 301." error messages, but now I see this:

Checking Testopia setup ...
Done checking Testopia setup.

Adding foreign key: test_environment_map.property_id -> test_environment_property.property_id...
DBD::mysql::db do failed: Can't create table './bugzilla/#sql-e9e_70e.frm' (errno: 121) [for Statement "ALTER TABLE test_environment_map ADD
     CONSTRAINT fk_e72132d466ae73fe05cfc61b07fce50d FOREIGN KEY (property_id)
     REFERENCES test_environment_property(property_id)
      ON UPDATE CASCADE ON DELETE CASCADE"] at Bugzilla/DB.pm line 502
        Bugzilla::DB::bz_add_fk('Bugzilla::DB::Mysql=HASH(0xae2ae14)', 'test_environment_map', 'property_id', 'HASH(0xaf07138)') called at Bugzilla/DB.pm line 436
        Bugzilla::DB::bz_setup_foreign_keys('Bugzilla::DB::Mysql=HASH(0xae2ae14)') called at Bugzilla/Install/DB.pm line 535
        Bugzilla::Install::DB::update_table_definitions('HASH(0x94259f4)') called at ./checksetup.pl line 195
You need to log in before you can comment on or make changes to this bug.