Oh it works now, almost!
I did not do your command yet (docker-compose
, not just docker
I guessed), I will try, in case it solves the following.
I can log in, I can see the home page.
Even the search works! http://localhost:5000/search?query=bowie&type=artist&limit=25&method=direct
BUT
But http://localhost:5000/artist/5441c29d-3602-4898-b1a1-b77fa23b8e50 says (directly in the browser, now):
Internal Server Error
Oops, something went wrong!
Error:
DBD::Pg::st execute failed: ERROR: relation "area_containment" does not exist
LINE 1: SELECT 1 FROM area_containment LIMIT 1
^ [for Statement "SELECT 1 FROM area_containment LIMIT 1"] at lib/MusicBrainz/Server/Connector.pm line 50
Sql::select_single_value(?, ?) called at lib/MusicBrainz/Server/Data/Utils.pm line 262
MusicBrainz::Server::Data::Utils::get_area_containment_join(?) called at lib/MusicBrainz/Server/Data/Area.pm line 75
MusicBrainz::Server::Data::Area::load_containment(?, ?, ?, ?) called at lib/MusicBrainz/Server/Controller/Artist.pm line 157
Catalyst::dispatch(?) called at lib/MusicBrainz/Server.pm line 388
MusicBrainz::Server::__ANON__ at lib/MusicBrainz/Server.pm line 353
MusicBrainz::Server::with_translations(?, ?) called at lib/MusicBrainz/Server.pm line 389
Class::MOP::Method::Wrapped::__ANON__(?) called at lib/MusicBrainz/Server.pm line 403
Class::MOP::Method::Wrapped::__ANON__(?) called at lib/MusicBrainz/Server.pm line 488
Time: 2022-08-30T18:40:17.965Z
Host: 379f22553c61
Interface language: en
URL: http://localhost:5000/artist/5441c29d-3602-4898-b1a1-b77fa23b8e50
Request data:
{
"body_parameters": {},
"query_parameters": {}
}
And http://localhost:5000/user/jesus2099 says (in the browser):
Internal Server Error
Oops, something went wrong!
Error:
DBD::Pg::st execute failed: ERROR: relation "place_rating_raw" does not exist
LINE 1: ...w WHERE editor = '285909' UNION ALL SELECT 1 FROM place_rati...
^ [for Statement "SELECT count(*) FROM (SELECT 1 FROM artist_rating_raw WHERE editor = ? UNION ALL SELECT 1 FROM event_rating_raw WHERE editor = ? UNION ALL SELECT 1 FROM place_rating_raw WHERE editor = ? UNION ALL SELECT 1 FROM release_group_rating_raw WHERE editor = ? UNION ALL SELECT 1 FROM label_rating_raw WHERE editor = ? UNION ALL SELECT 1 FROM recording_rating_raw WHERE editor = ? UNION ALL SELECT 1 FROM work_rating_raw WHERE editor = ?) x" with ParamValues: 1='285909', 2='285909', 3='285909', 4='285909', 5='285909', 6='285909', 7='285909'] at lib/MusicBrainz/Server/Connector.pm line 50
Sql::select_single_value(?, ?, ?, ?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Data/Editor.pm line 770
MusicBrainz::Server::Data::Editor::secondary_counts(?, ?, ?) called at lib/MusicBrainz/Server/Controller/User.pm line 472
Catalyst::dispatch(?) called at lib/MusicBrainz/Server.pm line 388
MusicBrainz::Server::__ANON__ at lib/MusicBrainz/Server.pm line 353
MusicBrainz::Server::with_translations(?, ?) called at lib/MusicBrainz/Server.pm line 389
Class::MOP::Method::Wrapped::__ANON__(?) called at lib/MusicBrainz/Server.pm line 403
Class::MOP::Method::Wrapped::__ANON__(?) called at lib/MusicBrainz/Server.pm line 488
Time: 2022-08-30T18:39:31.739Z
Host: 379f22553c61
Interface language: en
URL: http://localhost:5000/user/jesus2099
Request data:
{
"body_parameters": {},
"query_parameters": {}
}
It seems I have problems with the database content.
Maybe I should remove everything and retry a new install of musicbrainz-docker?
I tried:
git pull --ff-only
sudo docker-compose up --build musicbrainz
But I still have those DB errors, like for http://localhost:5000/search?query=the&type=release_group&limit=25&method=direct it says:
Internal Server Error
Oops, something went wrong!
Error:
DBD::Pg::st execute failed: ERROR: column ac.gid does not exist
LINE 2: ...tist.ended, ac.edits_pending AS ac_edits_pending, ac.gid AS ...
^
HINT: Perhaps you meant to reference the column "ac.id". [for Statement "SELECT artist, artist_credit_name.name AS ac_name, join_phrase, artist_credit,
artist.id, artist.gid, artist.name COLLATE musicbrainz, artist.sort_name COLLATE musicbrainz, artist.type, artist.area, artist.begin_area, artist.end_area, gender, artist.edits_pending, artist.comment, artist.last_updated, artist.begin_date_year, artist.begin_date_month, artist.begin_date_day, artist.end_date_year, artist.end_date_month, artist.end_date_day,artist.ended, ac.edits_pending AS ac_edits_pending, ac.gid AS ac_gid
FROM artist_credit_name
JOIN artist ON artist.id=artist_credit_name.artist
JOIN artist_credit ac ON ac.id = artist_credit_name.artist_credit
WHERE artist_credit IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
ORDER BY artist_credit, position" with ParamValues: 1='531923', 2='66', 3='24138', 4='854602', 5='192470', 6='11214', 7='226435', 8='1757', 9='299', 10='2333', 11='192', 12='434620', 13='100472', 14='1596440', 15='67938', 16='1464285', 17='1', 18='2147', 19='2403507', 20='43157', 21='88971', 22='2131043', 23='926', 24='347'] at lib/MusicBrainz/Server/Connector.pm line 50
Sql::select_list_of_hashes(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Data/ArtistCredit.pm line 45
MusicBrainz::Server::Data::ArtistCredit::get_by_ids(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Data/Role/EntityCache.pm line 42
MusicBrainz::Server::Data::ArtistCredit::get_by_ids(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Data/Utils.pm line 155
MusicBrainz::Server::Data::Utils::load_subobjects(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Data/ArtistCredit.pm line 79
MusicBrainz::Server::Data::ArtistCredit::load(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Controller/Search.pm line 197
Catalyst::forward(?, ?) called at lib/MusicBrainz/Server/Controller/Search.pm line 61
Catalyst::dispatch(?) called at lib/MusicBrainz/Server.pm line 388
MusicBrainz::Server::__ANON__ at lib/MusicBrainz/Server.pm line 353
MusicBrainz::Server::with_translations(?, ?) called at lib/MusicBrainz/Server.pm line 389
Class::MOP::Method::Wrapped::__ANON__(?) called at lib/MusicBrainz/Server.pm line 403
Class::MOP::Method::Wrapped::__ANON__(?) called at lib/MusicBrainz/Server.pm line 488
Time: 2022-08-30T18:50:08.052Z
Host: 59e7261425cb
Interface language: en
URL: http://localhost:5000/search?query=the&type=release_group&limit=25&method=direct
Request data:
{
"body_parameters": {},
"query_parameters": {
"query": "the",
"type": "release_group",
"limit": "25",
"method": "direct"
}
}
And for http://localhost:5000/search?query=the&type=recording&limit=25&method=direct it says:
Internal Server Error
Oops, something went wrong!
Error:
DBD::Pg::st execute failed: ERROR: relation "medium_track_durations" does not exist
LINE 1: ...gth, cdtoc_track_lengths, data_track_lengths FROM medium_tra...
^ [for Statement "SELECT medium, pregap_length, cdtoc_track_lengths, data_track_lengths FROM medium_track_durations WHERE medium = any(?)" with ParamValues: 1='{{"63217","1250594","618231","1591365","1591428","1499745","281830","2568306","281835","1591427","1145969","1499744"}}'] at lib/MusicBrainz/Server/Connector.pm line 50
Sql::select_list_of_hashes(?, ?, ?) called at lib/MusicBrainz/Server/Data/Medium.pm line 77
MusicBrainz::Server::Data::Medium::load_track_durations(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Data/Medium.pm line 113
MusicBrainz::Server::Data::Medium::load_for_releases(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Controller/Search.pm line 160
Catalyst::forward(?, ?) called at lib/MusicBrainz/Server/Controller/Search.pm line 61
Catalyst::dispatch(?) called at lib/MusicBrainz/Server.pm line 388
MusicBrainz::Server::__ANON__ at lib/MusicBrainz/Server.pm line 353
MusicBrainz::Server::with_translations(?, ?) called at lib/MusicBrainz/Server.pm line 389
Class::MOP::Method::Wrapped::__ANON__(?) called at lib/MusicBrainz/Server.pm line 403
Class::MOP::Method::Wrapped::__ANON__(?) called at lib/MusicBrainz/Server.pm line 488
Time: 2022-08-30T18:49:28.817Z
Host: 59e7261425cb
Interface language: en
URL: http://localhost:5000/search?query=the&type=recording&limit=25&method=direct
Request data:
{
"body_parameters": {},
"query_parameters": {
"method": "direct",
"limit": "25",
"type": "recording",
"query": "the"
}
}