Am 2013-11-13 um 22:41 schrieb Tibor Simko <[email protected]>:
> 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
# sudo -u www-data /opt/invenio/bin/inveniocfg --detect-system-details
>>> Going to detect system details...
* Hostname: ###
* Invenio version: 1.1.2.684-296ff-dirty
* Python version: 2.6.6 (r266:84292, Dec 26 2010, 22:31:48) [GCC 4.4.5]
* Apache version:
* MySQLdb version: 1.2.2
* MySQL version:
- version: 5.1.72-2-log
- character_set_client: utf8
- character_set_connection: utf8
- character_set_database: utf8
- character_set_results: utf8
- character_set_server: latin1
- character_set_system: utf8
- collation_connection: utf8_general_ci
- collation_database: utf8_general_ci
- collation_server: latin1_swedish_ci
>>> System details detected successfully.
Does that help?
The error didn’t occurr again so far.
Greetlings, Hraban
---
http://www.fiee.net
https://www.cacert.org (I'm an assurer)
