[Refdb-users] Error creating docbook bibliography

[Dr. M. G. <go...@Hd...>]

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)