On Thu, 14 Nov 2013, [email protected] wrote:
> Am 2013-11-14 um 09:46 schrieb Henning Hraban Ramm <[email protected]>:
>
>> The error didn’t occurr again so far.
>
> Sorry, wrong information - I didn’t try WebSubmit since then but
> concentrated on BibUpload.
You can make sure whether it runs OK and without any warnings by issuing
the problematic query manually in the DB shell:
$ echo "SELECT brbd.id_bibdoc, brbd.docname, brbd.type \
FROM bibrec_bibdoc as brbd JOIN bibdoc as bd \
ON bd.id=brbd.id_bibdoc \
WHERE brbd.id_bibrec=108 AND bd.status<>'DELETED' \
ORDER BY brbd.docname ASC" | /opt/invenio/bin/dbexec
and also in Python REPL:
$ ipython
In [1]: from invenio.dbquery import run_sql
In [2]: run_sql("SELECT brbd.id_bibdoc, brbd.docname, brbd.type \
FROM bibrec_bibdoc as brbd JOIN bibdoc as bd \
ON bd.id=brbd.id_bibdoc \
WHERE brbd.id_bibrec=108 AND bd.status<>'DELETED' \
ORDER BY brbd.docname ASC")
Out[2]: ()
Best regards
--
Tibor Simko
