Sorry, I still got some questions.. > drop database test > create database test /initialdb.xml
The database you're creating seems to be called "test"; what's "initialdb.xml"? > 14:00:00.710 [127.0.0.1:49788] QUERY(4) declare variable $DB > external; insert node <audit QID='80C18E9A-46DD-4B3E-89E9-967DAFD79A0B' > UID='i1' guid='0EEDDB47-726E-49F8-B1EF-0F73ED848969' > sessionID='48090b7f0e3a62a42a0457a3e88301ca' mode='active' > date='2012-04-02T13:00:00+00:00'/> into doc($DB)/root/auditlog OK > 0.09 ms > 14:00:00.710 [127.0.0.1:49788] QUERY(4) OK 0.05 ms > 14:00:00.710 [127.0.0.1:49788] BIND(4) DB WYP OK > 0.05 ms The log info implies you're having "root" and "auditlog" nodes, and the addressed database is called "WYP", is that right? Could you pass us on the missing snippets? Christian > On 2 Apr 2012, at 14:11, Christian Grün wrote: > >> Hi Mike, >> >> thanks for your report. It would be great if you could provide us with >> a small example that allows us to reproduce the issue (an export of >> your original database with the namespace (which is being added to the >> new node) may suffice). >> >> Best, >> Christian >> ____________________________ >> >> On Mon, Apr 2, 2012 at 2:44 PM, Mike Hawkes <mikehaw...@me.com> wrote: >>> Hi >>> >>> I have a weird problem ... I'm running a query via the PHP interface and >>> run the following query: >>> >>> declare variable $DB external; >>> >>> insert node >>> <audit QID='C54B14ED-C748-4DF0-87F2-91F505BE207B' >>> UID='i1' >>> guid='CC9D4D2B-B380-494B-B0F6-4D72471557B0' >>> sessionID='48090b7f0e3a62a42a0457a3e88301ca' >>> mode='active' >>> date='2012-04-02T12:21:05+00:00'/> >>> into doc($DB)/root/auditlog >>> >>> -- >>> BaseX log shows that it gets the query as-is. >>> >>> When I look at the data within the database by running the XQuery >>> >>> /root/auditlog >>> >>> I find that BaseX has inserted a namespace attribute as follows: >>> >>> <audit xmlns="http://www.w3.org/1999/xhtml"; >>> QID="C54B14ED-C748-4DF0-87F2-91F505BE207B" >>> UID="i1" guid="CC9D4D2B-B380-494B-B0F6-4D72471557B0" >>> sessionID="48090b7f0e3a62a42a0457a3e88301ca" mode="active" >>> date="2012-04-02T12:21:05+00:00"/> >>> >>> How do I stop this occurring? It only does it on the audit components, not >>> on anything else inserted by the PHP script. So, if I run two insert node >>> queries, the first will run normally, the audit update causes the xmlns >>> attribute to appear, effectively putting it in a different namespace to the >>> other data inserted by the PHP. >>> >>> The PHP script is as follows: >>> >>> $audit = "declare variable \$DB external; " . >>> "insert node <audit QID='$queryID' UID='$userID' " . >>> "guid='$guid' sessionID='" . session_id() . "' " . >>> "mode='active' " . >>> "date='$dateTime'/> into doc(\$DB)/root/auditlog"; >>> >>> $query = $session->query( $audit ); >>> $query->bind( 'DB', $DB); >>> $query->bind( 'SYSDATA', $SYSDATA ); >>> $query->execute(); >>> $query->close(); >>> >>> >>> Thanks in advance for any suggestions. >>> >>> Mike >>> _______________________________________________ >>> BaseX-Talk mailing list >>> BaseX-Talk@mailman.uni-konstanz.de >>> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk > _______________________________________________ BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk
