A fresh install of "bmo-4.2" has incomplete schema

RESOLVED WORKSFORME

Status

()

bugzilla.mozilla.org
General
--
minor
RESOLVED WORKSFORME
4 years ago
2 years ago

People

(Reporter: dylan, Unassigned)

Tracking

Production
x86_64
Linux

Details

Attachments

(1 attachment)

(Reporter)

Description

4 years ago
Created attachment 8343295 [details]
example of the schema generated by checksetup.pl

When installing bmo 4.2 on a dev machine, checksetup.pl will die with the error below after creating the database schema. it appears that the first_patch_reviewed_id is not a column of the profiles table.

Adding new table bz_schema...
Initializing bz_schema...
Creating tables...
Converting attach_data maximum size to 100G...
Setting up choices for standard drop-down fields:
   priority bug_status rep_platform resolution bug_severity op_sys
Removing existing compiled templates...
Precompiling templates...done.
Fixing file permissions...
DBD::mysql::db selectrow_hashref failed: Unknown column 'first_patch_reviewed_id' in 'field list' [for Statement "SELECT profiles.userid,profiles.login_name,profiles.realname,profiles.mybugslink AS showmybugslink,profiles.disabledtext,profiles.disable_mail,profiles.extern_id,profiles.is_enabled,DATE_FORMAT(last_seen_date, '%Y-%m-%d') AS last_seen_date,first_patch_reviewed_id,review_request_count,feedback_request_count,needinfo_request_count,comment_count,creation_ts,first_patch_bug_id,last_activity_ts,last_statistics_ts FROM profiles WHERE login_name = ?"] at Bugzilla/Object.pm line 130.
Attachment #8343295 - Attachment mime type: text/x-vhdl → text/plain
Component: Administration → General
this was fixed some time ago.
Status: NEW → RESOLVED
Last Resolved: 2 years ago
Resolution: --- → WORKSFORME
You need to log in before you can comment on or make changes to this bug.