Hi Andreas, I'll combine your two e-mails.
Andreas Tille <andr...@an3as.eu> writes: > There are no such fields Upstream-Bugs in any of the upstream files: > > $ grep Upstream-Bugs /srv/udd/mirrors/machine-readable/*/*.upstream > > So what exactly are you missing? You inserted into website/webtools/blendstasktools into statement "PREPARE query_pkgs text[],text[],text) AS SELECT * FROM blends_query_packages($1,$2,$3) AS (...)" the fields "upstream_bugs" text, "upstream_repository" text, "edam_topics" text[] (325155e9 2016-02-21 08:32:34 +0100). at the end, and these I referred to here. Andreas Tille <andr...@an3as.eu> writes: > On Fri, Mar 04, 2016 at 01:46:46PM +0100, Ole Streicher wrote: >> Something is not completely working here: I get no upstream_repository >> entry, and also only a few upstream_bugs entries, although I have quite >> many packages with d/u/metadata conteining them. Somehow they don't pass >> via UDD. > > udd=> select key, count(*) from upstream_metadata group by key order by key; > key | count > -------------------+------- > ASCL-Id | 3 > Bug-Database | 683 > Bug-Submit | 34 > Repository | 538 > Repository-Browse | 583 That sounds reasonable. However, in the in the "upstream_bugs" column stated above (which should match to the "Bug-Database" in upstream_metadata), there are just a few entries. And the "upstream_repository" column in the prepared statement on top, there are no entries at all (for debian-astro), while the fields are there. Best regards Ole