Skip to content

Instantly share code, notes, and snippets.

@ocharles
Created January 12, 2012 21:30
Show Gist options
  • Save ocharles/1603258 to your computer and use it in GitHub Desktop.
Save ocharles/1603258 to your computer and use it in GitHub Desktop.
2012-01-12 21:29:04.425080500 [error] Caught exception in MusicBrainz::Server::Controller::ReleaseEditor::Add->add "Failed query:
2012-01-12 21:29:04.425084500 '
2012-01-12 21:29:04.425086500 SELECT DISTINCT
2012-01-12 21:29:04.425087500 entity.id,
2012-01-12 21:29:04.425089500 entity.gid,
2012-01-12 21:29:04.425090500 entity.comment,
2012-01-12 21:29:04.425092500 entity.artist_credit AS artist_credit_id,
2012-01-12 21:29:04.425093500 entity.language, entity.script, entity.country, entity.barcode,
2012-01-12 21:29:04.425125500 entity.date_year, entity.date_month, entity.date_day,
2012-01-12 21:29:04.425127500 r.name,
2012-01-12 21:29:04.425128500 r.rank
2012-01-12 21:29:04.425129500 FROM
2012-01-12 21:29:04.425131500 (
2012-01-12 21:29:04.425132500 SELECT id, name, ts_rank_cd(to_tsvector('mb_simple', name), query, 2) AS rank
2012-01-12 21:29:04.425134500 FROM release_name, plainto_tsquery('mb_simple', ?) AS query
2012-01-12 21:29:04.425142500 WHERE to_tsvector('mb_simple', name) @@ query OR name = ?
2012-01-12 21:29:04.425144500 ORDER BY rank DESC
2012-01-12 21:29:04.425145500 LIMIT ?
2012-01-12 21:29:04.425147500 ) AS r
2012-01-12 21:29:04.425148500 JOIN release entity ON r.id = entity.name
2012-01-12 21:29:04.425150500
2012-01-12 21:29:04.425151500 ORDER BY
2012-01-12 21:29:04.425159500 r.rank DESC, r.name, entity.artist_credit
2012-01-12 21:29:04.425161500 OFFSET
2012-01-12 21:29:04.425162500 ?
2012-01-12 21:29:04.425177500 '
2012-01-12 21:29:04.425178500 (Kõige pikem päev Kõige pikem päev 150 0)
2012-01-12 21:29:04.425180500 DBD::Pg::st execute failed: ERROR: could not access file "$libdir/unaccent": No such file or directory at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 79.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment