You should update to a newer version, 6.1.3 is too old.
As a temp hack you can remove the union part and replace "G in (...)" with
"G = _G" but you will have to work with the latest version eventually.
As for the prefixes you'll probably have to do it manually in js.
Cheers,
Dimitris
On Thu, Jul 25, 2013 at 5:26 PM, Denis Lukovnikov <[email protected]>wrote:
> Hi,
>
> I think I have the 6.1.3 version (from Ubuntu repositories).
>
> An unrelated question:
> How do you get the prefix of a graph from a URL to shorten entity text (
> http://dbpedia.org/resource/Lena_Soderberg => dbpedia:Lena_Soderberg) in
> the plugin? As far as I've looked this happens in dbp_ldd_split_url in
> description.sql. I need to do the same in JavaScript, should I just
> manually make a table of mappings (like you would specify with PREFIX in a
> SPARQL query)?
>
> Greetings,
>
> Denis
>
> ------------------------------
> From: [email protected]
> Date: Wed, 24 Jul 2013 15:28:31 +0300
>
> Subject: Re: Building VAD
> To: [email protected]
> CC: [email protected];
> [email protected]
>
> 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
> <[email protected]>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: [email protected]
> To: [email protected]
> CC: [email protected];
> [email protected]
> 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: [email protected]
> To: [email protected]
> CC: [email protected];
> [email protected]
> 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: [email protected]
> Date: Wed, 24 Jul 2013 09:38:49 +0300
> Subject: Re: Building VAD
> To: [email protected]
> CC: [email protected];
> [email protected]
>
> 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 <[email protected]
> > 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: [email protected]
> To: [email protected]
> 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: [email protected]
> Date: Mon, 15 Jul 2013 11:19:24 +0300
> Subject: Re: Building VAD
> To: [email protected]
>
> 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
> <[email protected]>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
>
--
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
_______________________________________________
Dbpedia-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-developers
