Re: [Virtuoso-users] Fwd: Re: Problems using +backup-dump from Virtuoso 6 to Virtuoso 7 with +restore-crash-dump

Hugh, new information : same type error when copying V6 virtuoso.db in a clean "row store original" V7 , we lost XMLLiteral present in V6 datas : select ?titre (DATATYPE(?titre ))from where {

Re: [Virtuoso-users] Fwd: Re: Problems using +backup-dump from Virtuoso 6 to Virtuoso 7 with +restore-crash-dump

Le 08/12/2015 14:03, Hugh Williams a écrit : Hi Thomas, Don’t know what you mean by " pbs on datas” ??? I assume this spurious chars at the beginning of the strings ? yes (triple count is ok in V7/V7, no RDF data loss) Are you saying this string values where XMLLiteral in vs but are now X

Re: [Virtuoso-users] Subquery error when using Virtuoso7/ODBC/PHP

Hi Hugh, Thanks, please let me know what you find. Separately from the error (does the query optimiser do something different for remote queries?), can you give me any information about building odbc drivers from v7stable? Particularly to be installed on a separate server talking to the DB bo

Re: [Virtuoso-users] SQL Error on insert with virtuoso 7.2.1

Hi Piret, Yes, you should just need the new Virtuoso server binary ie the virtuoso-t executable … Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.

Re: [Virtuoso-users] Virtuoso SPARQL Query Editor errors

Hi Walter, Please send a private email to me confirming the current version of Virtuoso being by providing the output of running the following command from the “bin” directory of your Virtuoso installation: virtuoso-iodbc-t -? and we can schedule a build for your testing … Best Regar

Re: [Virtuoso-users] Fwd: Re: Problems using +backup-dump from Virtuoso 6 to Virtuoso 7 with +restore-crash-dump

Hi Thomas, Don’t know what you mean by " pbs on datas” ??? I assume this spurious chars at the beginning of the strings ? Are you saying this string values where XMLLiteral in vs but are now XMLSchema#string in v7 , which may be the cause ? Did you convert the RDF_QUAD table to column store mo

Re: [Virtuoso-users] SQL Error on insert with virtuoso 7.2.1

Hi, Hugh. Thank you for your answer. Will it be sufficient for the fix to just remove installed stable version of virtuoso and install the newest version 7.2.2 after it has been released with using the same .db file or do we need to make a quad dump and import the data to clean newer version

Re: [Virtuoso-users] SQL Error on insert with virtuoso 7.2.1

Hi Piret, A fix for this error was made after the late stable/7 branch release in June 2015 and thus is in the develop/7 branch, which is to become the 7.2.2 stable/7 release scheduled for this week. So I would suggest testing with develop/7 or wait for the new stable/7 to be made … Best Regar

[Virtuoso-users] SQL Error on insert with virtuoso 7.2.1

Hi, We recently upgraded our virtuoso to latest stable version 7.2.1. We made a quad dump of the previous database and imported all the data to new virtuoso. When we started our process against the new database got an error on insert after about 1000 named graphs were added, with approximately

[Virtuoso-users] Fwd: Re: Problems using +backup-dump from Virtuoso 6 to Virtuoso 7 with +restore-crash-dump

when we compare the datatypes from V6 and v7 it seems we'd lost the "strong" typing in V6 to a "generic" V7 type http://www.w3.org/2001/XMLSchema#string : SELECT DB.DBA.RDF_DATATYPE_OF_OBJ( "s_1_1_t0"."O") AS "titre_datatype", DB.DBA.RDF_LANGUAGE_OF_OBJ( "s_1_1_t0"."O") AS "titre_langage" FR

Re: [Virtuoso-users] Problems using +backup-dump from Virtuoso 6 to Virtuoso 7 with +restore-crash-dump

Important precision, we have focused this problems on a specific type of literals : Je dois préciser que le pb concerne des données de type Littéraux XML (http://www.w3.org/TR/REC-rdf-syntax/#section-Syntax-XML-literals) :

Re: [Virtuoso-users] Problems using +backup-dump from Virtuoso 6 to Virtuoso 7 with +restore-crash-dump

Hello, Thanks Hugh, we performed as explained in http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/UpgradingToVOS610#Upgrading%20from%20Release%206.x%20to%20Release%207.x ( convert the RDF_QUAD table to Column Store ) and it worked... except now we have pbs on datas (which was corre