and it says "By default, these 'inc=' arguments will only load relationship for the requested entity.”, which I don’t understand. I think that’s related to the recording-level-rels etc item
2015-05-07 12748, 2015
alastairp
"inc= arguments which affect subqueries” doesn’t say specifically for which entities they’re valid. You can only work it out from the description afterwards (I think)
2015-05-07 12702, 2015
bitmap
yeah, we don't restrict the inc params based on whether link types actually exist between two entity types or anything, so all are valid
2015-05-07 12704, 2015
alastairp
(If you answer these, I can make the wiki changes)
2015-05-07 12747, 2015
bitmap
by 'will only load relationship for the requested entity' I think it means for the requested resource, so if it's a direct lookup it'll only load them for that entity, if it's a browse request it'll load them for all the returned entities of whatever type you requested, but not any entities linked to those
2015-05-07 12713, 2015
Gentlecat joined the channel
2015-05-07 12713, 2015
_Dave_ joined the channel
2015-05-07 12725, 2015
Gentlecat
ruaok: yes, same length
2015-05-07 12729, 2015
alastairp
why does release browse not support tag and rating includes, but get does?
2015-05-07 12720, 2015
bitmap
I have no idea, tbh
2015-05-07 12731, 2015
alastairp
:)
2015-05-07 12749, 2015
ijabz2 joined the channel
2015-05-07 12706, 2015
alastairp
OK. I always wanted to rewrite that docs page. Maybe I’ll do that
2015-05-07 12719, 2015
alastairp
thanks again for your help. Now I can go and implement stuff!
2015-05-07 12722, 2015
alastairp
(sigh)
2015-05-07 12740, 2015
bitmap
oh and for the subqueries, the first 3 are for release (though isrcs should only work if inc=media is included), artist-credits is valid on /ws/2/{artist,label,recording,release,release-group} if they have any of inc={recordings,releases,release-groups} from the above section
2015-05-07 12743, 2015
bitmap
and various-artists says the only place it's used in the description
2015-05-07 12734, 2015
bitmap
actually, isrcs should also work on /ws/2/artist with inc=recordings
alastairp, if you help me get my head around the subject, I'm happy to do the drudgery of editing the wiki
2015-05-07 12705, 2015
alastairp
CallerNo6: thanks for the offer
2015-05-07 12714, 2015
alastairp
I’m not sure what the best way to reshuffle is
2015-05-07 12738, 2015
alastairp
I think maybe the clearer way is to duplicate information - e.g. have a subsection per entity, which lists all its options
2015-05-07 12755, 2015
alastairp
(and maybe another set of subsections that list what the options mean)
2015-05-07 12715, 2015
alastairp
because to me the most common usecase is “I want to get a recording entity, what other things can I include with it"
2015-05-07 12724, 2015
alastairp
which is really difficult at the moment
2015-05-07 12759, 2015
alastairp
the opposite, which may be useful, is “what are all of the things which have areas"
2015-05-07 12705, 2015
alastairp
but I think that’s less useful
2015-05-07 12724, 2015
bitmap
duplicating the info would be clearer I think, yeah, so people don't have to cross-reference as much
2015-05-07 12749, 2015
bitmap
there's too many "oh and btw this inc param is valid in this scenario" paragraphs that are easy to miss
2015-05-07 12750, 2015
CallerNo6
iiuc, I agree. A set of reference tables is most important. But also maybe a few examples based on common questions, like "I have an artist name, how do I get a list of albums?"
2015-05-07 12713, 2015
ujjwal joined the channel
2015-05-07 12737, 2015
bitmap
yeah, a few common examples at the end of each section would be nice
Anything else I need to consider before upgrading postres?
2015-05-07 12756, 2015
adhawkins
Are there some modules that mbserver uses?
2015-05-07 12730, 2015
Gentlecat joined the channel
2015-05-07 12732, 2015
adhawkins
musicbrainz_collate.
2015-05-07 12734, 2015
bitmap
after upgrading I think you'll need to recompile the postgresql-musicbrainz-collate and postgresql-musicbrainz-unaccent extensions in the mbserver checkout
Ok, I appear to have hosed my database, so starting from scratch.
2015-05-07 12717, 2015
adhawkins
InitDB throwing an error with extensions
2015-05-07 12725, 2015
adhawkins
Thu May 7 22:30:41 2015 : psql:/home/mbserver/musicbrainz-server/admin/sql/Extensions.sql:4: ERROR: could not open extension control file "/usr/share/postgresql/9.4/extension/cube.control": No such file or directory
2015-05-07 12703, 2015
adhawkins
That file doesn't exist, should it?
2015-05-07 12702, 2015
luks
if you are on debian/ubuntu, you need the package with contrib modules
2015-05-07 12729, 2015
luks
postgresql-contrib
2015-05-07 12741, 2015
adhawkins
Ok, got that, thanks. How can I drop the database?
2015-05-07 12752, 2015
ruaok
rvedotrc:oh yes.
2015-05-07 12758, 2015
ruaok pulls up the news.
2015-05-07 12704, 2015
luks
sudo -s postgres dropdb musicbrainz
2015-05-07 12717, 2015
luks
sudo -u postgres
2015-05-07 12719, 2015
luks
sorry
2015-05-07 12733, 2015
rvedotrc
I'm not really involved tonight (at work) - just being available /just in case/ something goes wonky,
2015-05-07 12738, 2015
adhawkins
Thu May 7 22:37:21 2015 : psql:/home/mbserver/musicbrainz-server/admin/sql/Extensions.sql:5: ERROR: could not open extension control file "/usr/share/postgresql/9.4/extension/musicbrainz_unaccent.control": No such file or directory
2015-05-07 12754, 2015
ruaok
oh ffs.
2015-05-07 12706, 2015
ruaok
all i need to do is read the bbc headline.
2015-05-07 12709, 2015
ruaok
close tab.
2015-05-07 12710, 2015
ruaok
close tab
2015-05-07 12716, 2015
ruaok
get more booze.
2015-05-07 12720, 2015
derwin
(bbc headline?)
2015-05-07 12730, 2015
rvedotrc
Extrapolation from zero results so far.
2015-05-07 12736, 2015
ruaok
> Election 2015: Exit poll puts Tories close to majority
derwin: sadly there is no acceptable outcome of this election.
2015-05-07 12732, 2015
ruaok
and mind you I don't even live there!
2015-05-07 12745, 2015
luks
adhawkins: have you installed the musicbrainz extensions?
2015-05-07 12757, 2015
adhawkins
I dud.
2015-05-07 12758, 2015
adhawkins
did.
2015-05-07 12703, 2015
adhawkins
Ah, but then I purged postgres.
2015-05-07 12704, 2015
adhawkins
One sec.
2015-05-07 12758, 2015
adhawkins
That's better.
2015-05-07 12706, 2015
adhawkins
Now to do the database import :)
2015-05-07 12718, 2015
LordSputnik goes to sleep for 4 hours before the interesting part of the election results at 3am
2015-05-07 12711, 2015
LordSputnik
btw, if anyone has a few minutes spare, please try out http://bookbrainz.mbsandbox.org/ - we're beta testing the next release ;)
2015-05-07 12732, 2015
LordSputnik has left the channel
2015-05-07 12712, 2015
adhawkins
Any suggestions on this error importing?
2015-05-07 12714, 2015
adhawkins
cover_art_archive.art_type 0 0% 0Error loading /tmp/MBImport-KTIwo4M5/mbdump/cover_art_archive.art_type: DBD::Pg::db pg_putcopydata failed: no COPY in progress at /home/mbserver/musicbrainz-server/admin/MBImport.pl line 289, <LOAD> line 183.
