Error creating docbook bibliography
"Dr. Martin Goik" <[email protected]> Fri, 03 Apr 2009 20:02:44 +0200
| Newsgroups | gmane.text.refdb.general |
|---|---|
| Message-ID | <[email protected]> |
I've tried to follow the instructions given in
http://refdb.sourceforge.net/tutorial/x1442.html to generate a docbook
bibliograpy for the following docbook5 document test instance mydoc.xml:
<?xml version="1.0" encoding="UTF-8"?>
<book version="5.0" xmlns="http://docbook.org/ns/docbook"
xmlns:xlink="http://www.w3.org/1999/xlink"
xmlns:xi="http://www.w3.org/2001/XInclude"
xmlns:svg="http://www.w3.org/2000/svg"
xmlns:m="http://www.w3.org/1998/Math/MathML"
xmlns:html="http://www.w3.org/1999/xhtml"
xmlns:db="http://docbook.org/ns/docbook">
<chapter>
<title>Test</title>
<section>
<title>A citation</title>
<para>We only need <citation role="REFDB">date83</citation>.</para>
</section>
</chapter>
<xi:include href="mydoc.bib.xml">
<xi:fallback>mydoc.bib.xml appears to be missing</xi:fallback>
</xi:include>
</book>
Now the runbib execution on behalf of the generated Makefile fails. The
command actually reads:
>runbib -u goik -w XXX -d mi -G raw.css -r -t db50x -E utf-8 mydoc.xml
>select failed
The List of citations gets extracted correctly:
> cat mydoc.id.xml
<?xml version="1.0"?>
<!DOCTYPE citationlist PUBLIC "-//Markus Hoenicka//DTD CitationList//EN"
"http://refdb.sourceforge.net/dtd/citationlistx.dtd">
<citationlist>
<citation>date83</citation>
</citationlist>
The only problem here is the inexistence of
http://refdb.sourceforge.net/dtd/citationlistx.dtd.
On the refdb server side I find the following incorrect SQL statement:
...
SELECT meta_app,meta_type,meta_dbversion FROM t_meta WHERE meta_type='risx'
connected to database server using database:
mi
no character encoding conversion required
output encoding is:
UTF-8
chunk added successfully
finished transferring data
chunk added successfully
SELECT DISTINCT t_refdb.refdb_id, t_refdb.refdb_type,
t_refdb.refdb_pubyear, t_refdb.refdb_startpage, t_refdb.refdb_endpage,
t_refdb.refdb_abstract, t_refdb.refdb_title, t_refdb.refdb_volume,
t_refdb.refdb_issue, t_refdb.refdb_booktitle, t_refdb.refdb_city,
t_refdb.refdb_publisher, t_refdb.refdb_title_series,
t_refdb.refdb_address, t_refdb.refdb_issn, t_refdb.refdb_periodical_id,
t_refdb.refdb_pyother_info, t_refdb.refdb_secyear,
t_refdb.refdb_secother_info, t_refdb.refdb_user1, t_refdb.refdb_user2,
t_refdb.refdb_user3, t_refdb.refdb_user4, t_refdb.refdb_user5,
t_refdb.refdb_typeofwork, t_refdb.refdb_area, t_refdb.refdb_ostype,
t_refdb.refdb_degree, t_refdb.refdb_runningtime,
t_refdb.refdb_classcodeintl, t_refdb.refdb_classcodeus,
t_refdb.refdb_senderemail, t_refdb.refdb_recipientemail,
t_refdb.refdb_mediatype, t_refdb.refdb_numvolumes,
t_refdb.refdb_edition, t_refdb.refdb_computer,
t_refdb.refdb_conferencelocation, t_refdb.refdb_registrynum,
t_refdb.refdb_classification, t_refdb.refdb_section,
t_refdb.refdb_pamphletnum, t_refdb.refdb_chapternum,
t_refdb.refdb_citekey FROM t_refdb WHERE refdb_type!='DUMMY' AND
t_refdb.refdb_citekey IN () ORDER BY t_refdb.refdb_id
1064: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near ') ORDER BY t_refdb.refdb_id' at line 1
select failed
...
Of courcse this statement is ill-formed since it contains "... AND
t_refdb.refdb_citekey IN () ...". I suspect the key "date83" (which is
present in the database in question) is missing here e.g. "... AND
t_refdb.refdb_citekey IN ('date83') ..."?
My System: Linux, Fedora core 10, refdb 0.9.9-1, built according to the
installation instructions
I've also tried the latest SVN version with exactly the same result.
--
Martin Goik Tel. +49-711-8923-2164 http://www.HdM-Stuttgart.de/~goik
GnuPG public key: https://www.hdm-stuttgart.de/~goik/goik.asc
Der Wohlstand ist das Durchgangsstadium von der Armut
zur Unzufriedenheit (Paul Spree)
------------------------------------------------------------------------------