New with Sparql endpoint and RDF

Posted by alejandrodf on June 26, 2011 at 7:37pm

Hello folks,

I'm learning how to create my first semantic website. I have created a content type with RDF mappings and I would like to try the Sparql queries in my site. I have installed the module http://drupal.org/project/sparql and I have enabled it. Now I have an endpoint enabled, but I don't the know the url of my site where I have to execute the queries.

Any ideas?

I'm a noob with this!

Comments

If you have "SPARQL Endpoint"

Posted by Remon on June 27, 2011 at 12:16am

If you have "SPARQL Endpoint" module enabled, you should find a link called "SPARQL endpoint" that will lead you to [yoursite]/sparql/.
Hope this helps.

How to get Sparql endpoint

Posted by brucewhealtonjr on September 14, 2011 at 6:44pm

Hello,
I tried to go to http://mydrupalsite.com/sparql/ and nothing was found. I did install sparql and refs and this is d7.
What am i missing?
Thanks,
Bruce

support request

Posted by scor on September 14, 2011 at 6:56pm

please file a support request at http://drupal.org/project/issues/sparql so we can see what's going on on your site.

Hi Remon, I have see an

Posted by alejandrodf on June 27, 2011 at 8:29pm

Hi Remon,

I have see an option called "Sparql Settings" where I have enabled the endpoint and I gave permissions to Select, Ask, Construct, and Describe. Then I went to Structure >> Sparql Endpoints Registry. I created an endpoint with the parameters title=Sparql Endpoint 1, Endpoint=sparql_endpoint and I didn't fill in the Dataset textbox.

I thought the endpoint was ready, but when I try to open [mysite]/sparlql/ or [mysite]/sparql_endpoint I got a 404 error. Any ideas? Maybe I forgot something :s

Thanks for your help :)

You don't need to enable the

Posted by scor on June 27, 2011 at 8:41pm

You don't need to enable the SPARQL endpoints registry if you just want to use the SPARQL endpoint module. after enabling the SPARQL endpoint module, and provided you have downloaded the ARC2 library, you should see a form at the /sparql/ page on your site. Otherwise please file a support request at http://drupal.org/project/issues/sparql

Hi Scor, I have created a new

Posted by alejandrodf on June 28, 2011 at 12:21pm

Hi Scor,

I have created a new Drupal 7 without content to test it. I have install RDF, SPARQL and ARC2 but I'm still having the same problem. I'm going to open a support request.

Thanks for your help :)

I have found my problem. I

Posted by alejandrodf on June 29, 2011 at 5:05pm

I have found my problem.

I was using 7.x-2.0-alpha1 version. In modules It only has SPARQL API and SPARQL Endpoints Registry, but there isn't any SPARQL Endpoint. I have installed 7.x-2.x-dev and now I have the Sparql Endpoint ready to use :)

I hope this topic will help others with my same problem!

Thanks scor and Remon for your help.

I have a probke

Posted by datorres on August 4, 2011 at 9:31pm

Hi alejandrodf:

Thank you for your information I have the same problem with SPARQL, I did what you mention but after doing that I get an error in the database I can do:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sr.uri' in 'field list': SELECT sr.srid AS srid, sr.title AS title, sr.uri AS uri, sr.dataset AS dataset FROM {sparql_registry} sr ORDER BY sr.title ASC LIMIT 20 OFFSET 0; Array ( ) in PagerDefault->execute() (line 79 of C:\xampp\htdocs\nuevo\includes\pager.inc).

PDOException SQLSTATE[42522]:

Posted by WhiplashInfo on August 12, 2011 at 4:50pm

I have also a PDOEXception:

Error:
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'n.type' in 'where clause': SELECT COUNT(*) AS expression FROM {comment} c WHERE (c.nid = :db_condition_placeholder_0) AND (c.status = :db_condition_placeholder_1) AND (n.type <> :db_condition_placeholder_2) ; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => biblio ) i PagerDefault->execute()(rad 74 av/home/web25518/domains/fmedk.se/public_html/d/includes/pager.inc).

The Web site encountered a unepected error. Pleasae try again later

The log reported:

TYPE php
DATE Friday, August 12, 2011 - 18:37
USER Anonymous (not verified)
LOCATION http://www.mydomain.se/d/?q=admin/reports/status/run-cron&destination=ad...
REFERRER http://www.mydomain.se/d/?q=admin/modules
MESSAGE PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'n.type' in 'where clause': SELECT COUNT(*) AS expression FROM {comment} c WHERE (c.nid = :db_condition_placeholder_0) AND (c.status = :db_condition_placeholder_1) AND (n.type <> :db_condition_placeholder_2) ; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => biblio ) in PagerDefault->execute() (line 74 of /home/myaccount/domains/mydomain.se/public_html/d/includes/pager.inc).
SEVERITY error
HOSTNAME xxxxxxx
OPERATIONS

Looking at the log it dispaly many similar error. Every actions at the site seems to produce an PDOException:

TYPE
DATE
MESSAGE
USER
OPERATIONS
php 08/12/2011 - 18:44 PDOException: SQLSTATE[42S22]: Column not found: 1054... Anonymous (not verified)
php 08/12/2011 - 18:44 PDOException: SQLSTATE[42S22]: Column not found: 1054... Anonymous (not verified)
locale 08/12/2011 - 18:44 Updated JavaScript translation file for the language... admin
php 08/12/2011 - 18:44 PDOException: SQLSTATE[42S22]: Column not found: 1054... Anonymous (not verified)
php 08/12/2011 - 18:44 PDOException: SQLSTATE[42S22]: Column not found: 1054... Anonymous (not verified)
php 08/12/2011 - 18:44 PDOException: SQLSTATE[42S22]: Column not found: 1054... Anonymous (not verified)
php 08/12/2011 - 18:43 PDOException: SQLSTATE[42S22]: Column not found: 1054... Anonymous (not verified)
php 08/12/2011 - 18:37 PDOException: SQLSTATE[42S22]: Column not found: 1054... Anonymous (not verified)

Thanks / Tomas

I would suggest posting this

Posted by linclark.research on August 12, 2011 at 4:54pm

I would suggest posting this as a support request in the issue queue for whichever module you are using.

OK, I turn to Biblio module

Posted by WhiplashInfo on August 13, 2011 at 6:51am

OK, I turn to Biblio module issues