I am working on a film knowledge exploration site (based on a Protege-frames developed ontology), and am excited about implementing RDFX, SPARQL, and SPARQL Views to pull in and display external data from Wikipedia (DBpedia) to complement my internally available data.

I have been following "Using Views to Query and Visualize Remote Data, part 1". I have apparently been successful setting up a SPARQL Endpoints Registry: Kasabi DBpedia - http://api.kasabi.com/dataset/dbpedia-core/apis/sparql; however, when I enter the SPARQL Views resource type information, after clicking on save, nothing happens - it just puts me back where I started.

I have tried disabling/uninstalling and also removing/recopying/updating the RDFX, SPARQL, and SPARQL Views modules, restoring a previous database, as well as simply removing/re-entering the SPARQL endpoint, but no luck thus far. I am not an application developer/PHP coder - I use Drupal configurations and Views and can code code in straight HTML/CSS. Has anyone experienced this previously or can anyone make an educated guess as to what I can try? Thanks.

Drupal core 7.10
(ARC2 library in sites/all/libraries/ARC2/arc)
Chaos tool suite (ctools) 7.x-1.x-dev
Entity API 7.x-1.0-rc1
Libraries API 7.x-1.0
RDF Extensions 7.x-2.x-dev
SPARQL 7.x-2.0-alpha4
SPARQL Views 7.x-2.x-dev
Views 7.x-3.0

Comments

Anonymous’s picture

Anonymous (not verified) commented
Status: Active » Postponed (maintainer needs more info)

Are you still having this problem? Please check in the SPARQL Resource screen again to ensure that your resource isn't there.

jdube’s picture

jdube commented

Thanks for looking at this. Yes, the problem still exists (SPARQL Views resource types shows "None.").

Since then I installed the Schema module, and its database comparison report displays this message:
"sparql_views_resource.svid is part of the primary key but is not specified to be 'not null'."

Schema comparison also indicates:
Match (119)
Mismatch (4) - One of which is SPARQL Views - column svid - difference on: not null
declared: array('description' => 'TODO: please describe this field!', 'type' => 'serial', 'unsigned' => TRUE)
actual: array('description' => 'The Unique ID of the sparql_views_resource.', 'type' => 'serial', 'unsigned' => TRUE, 'not null' => TRUE)
Extra (6) - which are: "Tables in the database that are not present in the schema. This indicates previously installed modules that are disabled but not un-installed or modules that do not use the Schema API.

sparql_store_site_endpoint_g2t
sparql_store_site_endpoint_id2val
sparql_store_site_endpoint_o2val
sparql_store_site_endpoint_s2val
sparql_store_site_endpoint_setting
sparql_store_site_endpoint_triple"

I do not understand what all this means, but I am posting it in the hope that it might help. At this point, I don't know if this problem is due to my user-error or what, so if you know what I need to do to "start over" with possibly compatible versions of Entity/RDFX/SPARQL/SPARQL Views, I will be glad to do so.

Anonymous’s picture

Anonymous (not verified) commented

Thanks for posting that, but that shouldn't be causing this issue.

I just tried this with the development releases of all of the modules and can't reproduce the problem, so I can't figure out what's going wrong. I haven't heard anyone else say this is an issue, so I don't have anyone to compare your setup to, either.

Try downloading the development releases of all of those modules and trying again. Unfortunately, if that doesn't work I don't have any other suggestions.

Anonymous’s picture

Anonymous (not verified) commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

No response.