W3C home > Mailing lists > Public > public-lod@w3.org > March 2011

Re: Problems with SPARQL on WWW4 server

From: Richard Cyganiak <richard@cyganiak.de>
Date: Mon, 21 Mar 2011 12:11:40 +0000
Cc: public-lod@w3.org
Message-Id: <F1B6EDCF-52C4-4AF4-85B3-DE0013286B0F@cyganiak.de>
To: Danny Ayers <danny.ayers@gmail.com>
Hi Danny,

I helped set up the Factbook SPARQL endpoint in 2007 when I was still in Berlin. The service was set up as a demo for D2R Server and its new linked data capabilities. AFAIK it's been just sitting there ever since, and the data probably has never been updated.

The error message looks like something is wrong with the D2R mapping. I'm not sure if anyone still feels responsible for fixing it.

You can probably get better data from DBpedia or Freebase.

Best,
Richard


On 20 Mar 2011, at 13:59, Danny Ayers wrote:

> (Not sure which list is most appropriate - please advise)
> 
> I'm getting a lot of errors querying against:
> 
> http://www4.wiwiss.fu-berlin.de/factbook/sparql
> 
> while some queries work, e.g.
> 
> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
> 
> SELECT DISTINCT ?s WHERE {
> ?s rdfs:label ?label .
> FILTER REGEX(?label, "libya", "i")
> }
> 
> many others fail, e.g.
> 
> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
> 
> SELECT DISTINCT * WHERE {
> <http://www4.wiwiss.fu-berlin.de/factbook/resource/Libya> ?p ?o
> }
> 
> =>
> 
> ...
> <h2>HTTP ERROR: 500</h2><pre>rethrew:
> de.fuberlin.wiwiss.d2rq.D2RQException: Table 'factbook.neighbors'
> doesn't exist: SELECT DISTINCT `T0_neighbors`.`name_encoded` FROM
> `bordercountries` AS `T0_bordercountries`, `neighbors` AS
> `T0_neighbors`, `countries` AS `T0_countries` WHERE
> `T0_bordercountries`.`Landboundaries_bordercountries_title` =
> `T0_neighbors`.`Name` AND `T0_bordercountries`.`Name` =
> `T0_countries`.`Name` AND `T0_countries`.`name_encoded` = 'Libya'
> (E0)</pre>
> <p>RequestURI=/sparql</p><p><i><small><a
> href="http://jetty.mortbay.org/">Powered by Jetty://</a>
> ...
> 
> Cheers,
> Danny.
> 
> -- 
> http://danny.ayers.name
> 
Received on Monday, 21 March 2011 12:12:15 UTC

This archive was generated by hypermail 2.3.1 : Sunday, 31 March 2013 14:24:32 UTC