Skip to content
This repository has been archived by the owner on Aug 14, 2019. It is now read-only.

Init results in massive amount of errors #60

Open
Enverex opened this issue Mar 31, 2013 · 0 comments
Open

Init results in massive amount of errors #60

Enverex opened this issue Mar 31, 2013 · 0 comments

Comments

@Enverex
Copy link

Enverex commented Mar 31, 2013

I'm not sure if these can be ignored, but I have the user and DB created, but running the init script (and selecting yes) results in the following (using Postgres):

Ready to proceed? (it may take over 24 hours for this script to fully
complete) (y/n): y
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "kv_pkey" for table "kv"
Downloading schema... Done
Table annotation
NOTICE: ALTER TABLE will create implicit sequence "annotation_id_seq" for serial column "annotation.id"
Table artist
NOTICE: ALTER TABLE will create implicit sequence "artist_id_seq" for serial column "artist.id"
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "artist" ADD "("
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "OR"
LINE 1: ALTER TABLE "artist" ADD "(end_date_year" IS NOT NULL OR
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "OR"
LINE 1: ALTER TABLE "artist" ADD ")" OR (
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "AND"
LINE 1: ALTER TABLE "artist" ADD "(end_date_year" IS NULL AND
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "artist" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "artist" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
Table artist_alias_type
NOTICE: ALTER TABLE will create implicit sequence "artist_alias_type_id_seq" for serial column "artist_alias_type.id"
Table artist_alias
NOTICE: ALTER TABLE will create implicit sequence "artist_alias_id_seq" for serial column "artist_alias.id"
DBD::Pg::db do failed: ERROR: syntax error at or near "<>"
LINE 1: ALTER TABLE "artist_alias" ADD "(type" <> 3) OR (
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "artist_alias" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "artist_alias" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
Table artist_annotation
Table artist_ipi
Table artist_meta
Table artist_tag
Table artist_rating_raw
Table artist_tag_raw
Table artist_credit
NOTICE: ALTER TABLE will create implicit sequence "artist_credit_id_seq" for serial column "artist_credit.id"
Table artist_credit_name
Table artist_gid_redirect
Table artist_name
NOTICE: ALTER TABLE will create implicit sequence "artist_name_id_seq" for serial column "artist_name.id"
Table artist_type
NOTICE: ALTER TABLE will create implicit sequence "artist_type_id_seq" for serial column "artist_type.id"
Table autoeditor_election
NOTICE: ALTER TABLE will create implicit sequence "autoeditor_election_id_seq" for serial column "autoeditor_election.id"
Table autoeditor_election_vote
NOTICE: ALTER TABLE will create implicit sequence "autoeditor_election_vote_id_seq" for serial column "autoeditor_election_vote.id"
Table cdtoc
NOTICE: ALTER TABLE will create implicit sequence "cdtoc_id_seq" for serial column "cdtoc.id"
Table cdtoc_raw
NOTICE: ALTER TABLE will create implicit sequence "cdtoc_raw_id_seq" for serial column "cdtoc_raw.id"
Table clientversion
NOTICE: ALTER TABLE will create implicit sequence "clientversion_id_seq" for serial column "clientversion.id"
Table country
NOTICE: ALTER TABLE will create implicit sequence "country_id_seq" for serial column "country.id"
Table edit
NOTICE: ALTER TABLE will create implicit sequence "edit_id_seq" for serial column "edit.id"
Table edit_note
NOTICE: ALTER TABLE will create implicit sequence "edit_note_id_seq" for serial column "edit_note.id"
Table edit_artist
Table edit_label
Table edit_release
Table edit_release_group
Table edit_recording
Table edit_work
Table edit_url
Table editor
NOTICE: ALTER TABLE will create implicit sequence "editor_id_seq" for serial column "editor.id"
Table editor_language
DBD::Pg::db do failed: ERROR: type "fluency" does not exist
LINE 1: ALTER TABLE "editor_language" ADD "fluency" FLUENCY NOT NULL
^ at backend/postgresql.pl line 184, line 1410.
Table editor_preference
NOTICE: ALTER TABLE will create implicit sequence "editor_preference_id_seq" for serial column "editor_preference.id"
Table editor_subscribe_artist
NOTICE: ALTER TABLE will create implicit sequence "editor_subscribe_artist_id_seq" for serial column "editor_subscribe_artist.id"
Table editor_subscribe_label
NOTICE: ALTER TABLE will create implicit sequence "editor_subscribe_label_id_seq" for serial column "editor_subscribe_label.id"
Table editor_subscribe_editor
NOTICE: ALTER TABLE will create implicit sequence "editor_subscribe_editor_id_seq" for serial column "editor_subscribe_editor.id"
Table gender
NOTICE: ALTER TABLE will create implicit sequence "gender_id_seq" for serial column "gender.id"
Table isrc
NOTICE: ALTER TABLE will create implicit sequence "isrc_id_seq" for serial column "isrc.id"
Table iswc
NOTICE: ALTER TABLE will create implicit sequence "iswc_id_seq" for serial column "iswc.id"
Table l_artist_artist
NOTICE: ALTER TABLE will create implicit sequence "l_artist_artist_id_seq" for serial column "l_artist_artist.id"
Table l_artist_label
NOTICE: ALTER TABLE will create implicit sequence "l_artist_label_id_seq" for serial column "l_artist_label.id"
Table l_artist_recording
NOTICE: ALTER TABLE will create implicit sequence "l_artist_recording_id_seq" for serial column "l_artist_recording.id"
Table l_artist_release
NOTICE: ALTER TABLE will create implicit sequence "l_artist_release_id_seq" for serial column "l_artist_release.id"
Table l_artist_release_group
NOTICE: ALTER TABLE will create implicit sequence "l_artist_release_group_id_seq" for serial column "l_artist_release_group.id"
Table l_artist_url
NOTICE: ALTER TABLE will create implicit sequence "l_artist_url_id_seq" for serial column "l_artist_url.id"
Table l_artist_work
NOTICE: ALTER TABLE will create implicit sequence "l_artist_work_id_seq" for serial column "l_artist_work.id"
Table l_label_label
NOTICE: ALTER TABLE will create implicit sequence "l_label_label_id_seq" for serial column "l_label_label.id"
Table l_label_recording
NOTICE: ALTER TABLE will create implicit sequence "l_label_recording_id_seq" for serial column "l_label_recording.id"
Table l_label_release
NOTICE: ALTER TABLE will create implicit sequence "l_label_release_id_seq" for serial column "l_label_release.id"
Table l_label_release_group
NOTICE: ALTER TABLE will create implicit sequence "l_label_release_group_id_seq" for serial column "l_label_release_group.id"
Table l_label_url
NOTICE: ALTER TABLE will create implicit sequence "l_label_url_id_seq" for serial column "l_label_url.id"
Table l_label_work
NOTICE: ALTER TABLE will create implicit sequence "l_label_work_id_seq" for serial column "l_label_work.id"
Table l_recording_recording
NOTICE: ALTER TABLE will create implicit sequence "l_recording_recording_id_seq" for serial column "l_recording_recording.id"
Table l_recording_release
NOTICE: ALTER TABLE will create implicit sequence "l_recording_release_id_seq" for serial column "l_recording_release.id"
Table l_recording_release_group
NOTICE: ALTER TABLE will create implicit sequence "l_recording_release_group_id_seq" for serial column "l_recording_release_group.id"
Table l_recording_url
NOTICE: ALTER TABLE will create implicit sequence "l_recording_url_id_seq" for serial column "l_recording_url.id"
Table l_recording_work
NOTICE: ALTER TABLE will create implicit sequence "l_recording_work_id_seq" for serial column "l_recording_work.id"
Table l_release_release
NOTICE: ALTER TABLE will create implicit sequence "l_release_release_id_seq" for serial column "l_release_release.id"
Table l_release_release_group
NOTICE: ALTER TABLE will create implicit sequence "l_release_release_group_id_seq" for serial column "l_release_release_group.id"
Table l_release_url
NOTICE: ALTER TABLE will create implicit sequence "l_release_url_id_seq" for serial column "l_release_url.id"
Table l_release_work
NOTICE: ALTER TABLE will create implicit sequence "l_release_work_id_seq" for serial column "l_release_work.id"
Table l_release_group_release_group
NOTICE: ALTER TABLE will create implicit sequence "l_release_group_release_group_id_seq" for serial column "l_release_group_release_group.id"
Table l_release_group_url
NOTICE: ALTER TABLE will create implicit sequence "l_release_group_url_id_seq" for serial column "l_release_group_url.id"
Table l_release_group_work
NOTICE: ALTER TABLE will create implicit sequence "l_release_group_work_id_seq" for serial column "l_release_group_work.id"
Table l_url_url
NOTICE: ALTER TABLE will create implicit sequence "l_url_url_id_seq" for serial column "l_url_url.id"
Table l_url_work
NOTICE: ALTER TABLE will create implicit sequence "l_url_work_id_seq" for serial column "l_url_work.id"
Table l_work_work
NOTICE: ALTER TABLE will create implicit sequence "l_work_work_id_seq" for serial column "l_work_work.id"
Table label
NOTICE: ALTER TABLE will create implicit sequence "label_id_seq" for serial column "label.id"
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "label" ADD "("
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "OR"
LINE 1: ALTER TABLE "label" ADD "(end_date_year" IS NOT NULL OR
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "OR"
LINE 1: ALTER TABLE "label" ADD ")" OR (
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "AND"
LINE 1: ALTER TABLE "label" ADD "(end_date_year" IS NULL AND
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "label" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "label" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
Table label_rating_raw
Table label_tag_raw
Table label_alias_type
NOTICE: ALTER TABLE will create implicit sequence "label_alias_type_id_seq" for serial column "label_alias_type.id"
Table label_alias
NOTICE: ALTER TABLE will create implicit sequence "label_alias_id_seq" for serial column "label_alias.id"
DBD::Pg::db do failed: ERROR: syntax error at or near "<>"
LINE 1: ALTER TABLE "label_alias" ADD "(type" <> 2) OR (
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "label_alias" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "label_alias" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
Table label_annotation
Table label_ipi
Table label_meta
Table label_gid_redirect
Table label_name
NOTICE: ALTER TABLE will create implicit sequence "label_name_id_seq" for serial column "label_name.id"
Table label_tag
Table label_type
NOTICE: ALTER TABLE will create implicit sequence "label_type_id_seq" for serial column "label_type.id"
Table language
NOTICE: ALTER TABLE will create implicit sequence "language_id_seq" for serial column "language.id"
DBD::Pg::db do failed: ERROR: syntax error at or near "CONSTRAINT"
LINE 1: ALTER TABLE "language" ADD "ADD" CONSTRAINT iso_code_check
^ at backend/postgresql.pl line 184, line 1410.
Table link
NOTICE: ALTER TABLE will create implicit sequence "link_id_seq" for serial column "link.id"
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "link" ADD "("
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "OR"
LINE 1: ALTER TABLE "link" ADD "(end_date_year" IS NOT NULL OR
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "OR"
LINE 1: ALTER TABLE "link" ADD ")" OR (
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at or near "AND"
LINE 1: ALTER TABLE "link" ADD "(end_date_year" IS NULL AND
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "link" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "link" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
Table link_attribute
Table link_attribute_type
NOTICE: ALTER TABLE will create implicit sequence "link_attribute_type_id_seq" for serial column "link_attribute_type.id"
Table link_type
NOTICE: ALTER TABLE will create implicit sequence "link_type_id_seq" for serial column "link_type.id"
Table link_type_attribute_type
Table editor_collection
NOTICE: ALTER TABLE will create implicit sequence "editor_collection_id_seq" for serial column "editor_collection.id"
Table editor_collection_release
Table editor_watch_preferences
Table editor_watch_artist
Table editor_watch_release_group_type
Table editor_watch_release_status
Table medium
NOTICE: ALTER TABLE will create implicit sequence "medium_id_seq" for serial column "medium.id"
Table medium_cdtoc
NOTICE: ALTER TABLE will create implicit sequence "medium_cdtoc_id_seq" for serial column "medium_cdtoc.id"
Table medium_format
NOTICE: ALTER TABLE will create implicit sequence "medium_format_id_seq" for serial column "medium_format.id"
Table puid
NOTICE: ALTER TABLE will create implicit sequence "puid_id_seq" for serial column "puid.id"
Table replication_control
NOTICE: ALTER TABLE will create implicit sequence "replication_control_id_seq" for serial column "replication_control.id"
Table recording
NOTICE: ALTER TABLE will create implicit sequence "recording_id_seq" for serial column "recording.id"
Table recording_rating_raw
Table recording_tag_raw
Table recording_annotation
Table recording_meta
Table recording_gid_redirect
Table recording_puid
NOTICE: ALTER TABLE will create implicit sequence "recording_puid_id_seq" for serial column "recording_puid.id"
Table recording_tag
Table release
NOTICE: ALTER TABLE will create implicit sequence "release_id_seq" for serial column "release.id"
Table release_raw
NOTICE: ALTER TABLE will create implicit sequence "release_raw_id_seq" for serial column "release_raw.id"
Table release_tag_raw
Table release_annotation
Table release_gid_redirect
Table release_meta
DBD::Pg::db do failed: ERROR: type "cover_art_presence" does not exist
LINE 1: ...TER TABLE "release_meta" ADD "cover_art_presence" cover_art_...
^ at backend/postgresql.pl line 184, line 1410.
Table release_coverart
Table release_label
NOTICE: ALTER TABLE will create implicit sequence "release_label_id_seq" for serial column "release_label.id"
Table release_packaging
NOTICE: ALTER TABLE will create implicit sequence "release_packaging_id_seq" for serial column "release_packaging.id"
Table release_status
NOTICE: ALTER TABLE will create implicit sequence "release_status_id_seq" for serial column "release_status.id"
Table release_tag
Table release_group
NOTICE: ALTER TABLE will create implicit sequence "release_group_id_seq" for serial column "release_group.id"
Table release_group_rating_raw
Table release_group_tag_raw
Table release_group_annotation
Table release_group_gid_redirect
Table release_group_meta
Table release_group_tag
Table release_group_primary_type
NOTICE: ALTER TABLE will create implicit sequence "release_group_primary_type_id_seq" for serial column "release_group_primary_type.id"
Table release_group_secondary_type
NOTICE: ALTER TABLE will create implicit sequence "release_group_secondary_type_id_seq" for serial column "release_group_secondary_type.id"
Table release_group_secondary_type_join
Table release_name
NOTICE: ALTER TABLE will create implicit sequence "release_name_id_seq" for serial column "release_name.id"
Table script
NOTICE: ALTER TABLE will create implicit sequence "script_id_seq" for serial column "script.id"
Table script_language
NOTICE: ALTER TABLE will create implicit sequence "script_language_id_seq" for serial column "script_language.id"
Table tag
NOTICE: ALTER TABLE will create implicit sequence "tag_id_seq" for serial column "tag.id"
Table tag_relation
Table track
NOTICE: ALTER TABLE will create implicit sequence "track_id_seq" for serial column "track.id"
Table track_raw
NOTICE: ALTER TABLE will create implicit sequence "track_raw_id_seq" for serial column "track_raw.id"
Table track_name
NOTICE: ALTER TABLE will create implicit sequence "track_name_id_seq" for serial column "track_name.id"
Table tracklist
NOTICE: ALTER TABLE will create implicit sequence "tracklist_id_seq" for serial column "tracklist.id"
Table tracklist_index
Table url
NOTICE: ALTER TABLE will create implicit sequence "url_id_seq" for serial column "url.id"
Table url_gid_redirect
Table vote
NOTICE: ALTER TABLE will create implicit sequence "vote_id_seq" for serial column "vote.id"
Table work
NOTICE: ALTER TABLE will create implicit sequence "work_id_seq" for serial column "work.id"
Table work_rating_raw
Table work_tag_raw
Table work_alias_type
NOTICE: ALTER TABLE will create implicit sequence "work_alias_type_id_seq" for serial column "work_alias_type.id"
Table work_alias
NOTICE: ALTER TABLE will create implicit sequence "work_alias_id_seq" for serial column "work_alias.id"
DBD::Pg::db do failed: ERROR: syntax error at or near "<>"
LINE 1: ALTER TABLE "work_alias" ADD "(type" <> 2) OR (
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "work_alias" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
DBD::Pg::db do failed: ERROR: syntax error at end of input
LINE 1: ALTER TABLE "work_alias" ADD ")"
^ at backend/postgresql.pl line 184, line 1410.
Table work_annotation
Table work_gid_redirect
Table work_meta
Table work_name
NOTICE: ALTER TABLE will create implicit sequence "work_name_id_seq" for serial column "work_name.id"
Table work_tag
Table work_type
NOTICE: ALTER TABLE will create implicit sequence "work_type_id_seq" for serial column "work_type.id"
Table dbmirror_Pending
NOTICE: ALTER TABLE will create implicit sequence "dbmirror_Pending_SeqId_seq" for serial column "dbmirror_Pending.SeqId"
Table dbmirror_PendingData
Logging into MusicBrainz FTP (ftp.musicbrainz.org)...

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant