Hi,
This is perfectly valid syntax, just see "_G" as a value (the graph ID)
What I did here was to enable graph group search in raw VOS SQL.
If _G is the group graph (http://dbpedia.org in this case) the query
searches in all group members of _G, otherwise just _G
Which VOS version are you working with? 06.01.3127 is the conductor version
did you checkout the stable/develop - 6/7 branch?.
This worked fine in stable/6 (well, in 6.1.6, 6.1.7 was released a few days
ago and didn't test it)
Cheers,
Dimitris
On Wed, Jul 24, 2013 at 1:26 PM, Denis Lukovnikov <lukovni...@outlook.com>wrote:
> Hi,
>
> Maybe I have a wrong version of something but changing the "UNION select
> _G" in the highlighted line and 5 other later occurences of "UNION select
> _G" by "SELECT RGGM_GROUP_IID FROM DB.DBA.RDF_GRAPH_GROUP_MEMBER WHERE
> RGGM_GROUP_IID = _G" makes it work.
> This solution is really stupid but I'm not sure why "select _G" gives a
> syntax error for me. Do you have an idea?
>
> 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:49:47 +0200
>
>
> 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
>
--
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
