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

Reply via email to