Hi,
Do graph groups make a difference when the error reported is a syntax error?
The last three words of the line you highlighted (SELECT RGGM_MEMBER_IID FROM
DB.DBA.RDF_GRAPH_GROUP_MEMBER WHERE RGGM_GROUP_IID = _G UNION SELECT _G),
"UNION SELECT _G" seem rather wrong in SQL. It looks incorrect there (but maybe
I'm missing some special capabilities of SQL here) and I don't really get what
it is supposed to do. Removing it doesn't give the syntax error in the ISQL
terminal anymore.
Denis
From: lukovni...@outlook.com
To: jimk...@gmail.com
CC: dbpedia-develop...@lists.sourceforge.net;
virtuoso-users@lists.sourceforge.net
Subject: RE: Building VAD
Date: Wed, 24 Jul 2013 11:13:09 +0200
Hi,
I've executed the commands. Now I have three entries for
DB.DBA.RDF_GRAPH_GROUP_MEMBER, all together with "http://dbpedia.org";. But
viewing an entity still gives the same mistake.
Greetings,
Denis
From: jimk...@gmail.com
Date: Wed, 24 Jul 2013 09:38:49 +0300
Subject: Re: Building VAD
To: lukovni...@outlook.com
CC: dbpedia-develop...@lists.sourceforge.net;
virtuoso-users@lists.sourceforge.net
Hi Denis,
Adding the dbpedia developers and the Virtuoso mailing list since this might
affect others too
The reason for this must be this part of line 272:
select RGGM_MEMBER_IID FROM DB.DBA.RDF_GRAPH_GROUP_MEMBER where RGGM_GROUP_IID
= _G UNION select _G
https://github.com/dbpedia/dbpedia-vad-i18n/blob/master/dbpedia/vsp/description.vsp#L272
This is done to help us use the same code for DBpedia Live.
In Live we store data in different graphs and use a single graph group for a
single point of access.
The code should be working even if you don't have graph groups defined
(defaults to _G if RDF_GRAPH_GROUP_MEMBER is empty) but maybe something needs
to be initialized first
Can you try running the following commands and check again?
DB.DBA.RDF_GRAPH_GROUP_CREATE ('http://dbpedia.org',1);
DB.DBA.RDF_GRAPH_GROUP_INS ('http://dbpedia.org','http://live.dbpedia.org');
DB.DBA.RDF_GRAPH_GROUP_INS ('http://dbpedia.org','http://static.dbpedia.org');
DB.DBA.RDF_GRAPH_GROUP_INS
('http://dbpedia.org','http://dbpedia.org/resource/classes#');
Cheers,
Dimitris
On Wed, Jul 24, 2013 at 12:41 AM, Denis Lukovnikov <lukovni...@outlook.com>
wrote:
Hi,
Just got back from holiday today (beautiful beaches in Croatia).
I've managed to build VOS and DBpedia plugin, the steps are concisely described
at:
http://dbpv.wordpress.com/building-the-dbpedia-virtuoso-plugin/
However, when I deploy the fresh DBpedia plugin in my running VOS instance
(version 06.01.3127), either by downloading the plugin file directly from the
DBpedia github or by building it from source together with VOS (as described in
the blogpost), it doesn't work, giving:
Execution of "/DAV/VAD/dbpedia/description.vsp" failed.SQL Error: 37000 SQ074:
Line 272: syntax error at ')' before 'order'
when navigating to any http://localhost:8890/page/<Entity>
Is this normal or is it just my installation? I'll further look into this
tomorrow.
Greetings,
Denis
From: lukovni...@outlook.com
To: jimk...@gmail.com
Subject: RE: Building VAD
Date: Mon, 15 Jul 2013 19:17:56 +0200
Hi,
Thanks for enlighting me :). Is it realistic OpenLink could release a VAD
compiling script in the coming weeks if we ask? It seems like it's pretty deep
in VOS.
Tomorrow I'm leaving on holiday for one week. I'll try to test build this thing
today if there is time after preparing for next week.
Greetings,
Denis
From: jimk...@gmail.com
Date: Mon, 15 Jul 2013 11:19:24 +0300
Subject: Re: Building VAD
To: lukovni...@outlook.com
Hi Denis,
currently there are no such scripts :) Maybe you could make an extra request to
the VOS mailing list for that
What I do to get this done is to download the latest 6.X version of Virtuoso
and replace the contents of the dbpedia_vad folder with our folder
then I run $configure & $make to build it. The building script compiles the vad
packages too
After every change a single $make should build only the latest changes
If you have a VOS running at localhost, make sure the DB server (not the http)
doesn't run on the same port (default 1111)
For simpler tasks I do it manually
e.g. to update SQL procedures, I re-run the sql file from console to update the
definitions
to change the contents of a VSP page I upload the new version from the VOS
webdav browser
Cheers,
Dimitris
On Sat, Jul 13, 2013 at 1:22 AM, Denis Lukovnikov <lukovni...@outlook.com>
wrote:
Hi,
I've been searching the web and mailing lists for hours, but didn't find any
clear explanation on how to build VAD from source. In your emails to OpenLink,
you mentioned "VOS compilation scripts".
What am I missing? Could you enlighten me?
Greetings,
Denis
--
Kontokostas Dimitris
--
Kontokostas Dimitris
------------------------------------------------------------------------------
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
