On Tue, 22 Oct 2013, [email protected] wrote: > value = 'OperationalError(1054, "Unknown column > \'brbd.docname\' in \'field list\'")' > query = '"SELECT brbd.id_bibdoc, brbd.docname, > brbd.type FROM bibrec_bibdoc as brbd JOIN\\n bibdoc > as bd ON bd.id=brbd.id_bibdoc WHERE brbd.id_bibrec=108 AND\\n > bd.status<>\'DELETED\' ORDER BY brbd.docname ASC"'
Interesting, because table `bibrec_bibdoc' should contain well a column named `docname'... I guess the error may come due to a particular MySQL version that sees an SQL query using table aliases in join statement. I've seen a similar problem in the (distant) past. What happens when you run the above query manually? What MySQL version do you use? Can you send the results of: $ sudo -u www-data /opt/invenio/bin/inveniocfg --detect-system-details Best regards -- Tibor Simko
