Dear colleagues,
I use Invenio 1.1.6 version. I need help from you for the following problem:
2017-06-01 12:01:36 -> OperationalError: (1052, "Column 'docname' in order
clause is ambiguous") (connections.py:36:defaulterrorhandler)
As far as I see from below there may be something wrong with a column name in
one of my database
tables but I cannot see where and how I can manage it.
I can see my records in short format but can access neither to their detailed
format nor the files attached to them through my browser. The only way is if I
download and edit the records one by one through the wget command only.
I have tried several methods such as full reindexing, updating etc. but this
problem won't go away.
The invenio.err file says the following:
Traceback (most recent call last):
File
"/usr/local/lib/python2.7/site-packages/<*****>/webinterface_handler.py", line
424, in _handler
return root._traverse(req, path, False, guest_p)
File
"/usr/local/lib/python2.7/site-packages/<*****>/webinterface_handler.py", line
239, in _traverse
return obj._traverse(req, path, do_head, guest_p)
File
"/usr/local/lib/python2.7/site-packages/<*****>/webinterface_handler.py", line
239, in _traverse
return obj._traverse(req, path, do_head, guest_p)
File
"/usr/local/lib/python2.7/site-packages/<*****>/webinterface_handler.py", line
252, in _traverse
result = _check_result(req, obj(req, form))
File
"/usr/local/lib/python2.7/site-packages/<*****>/bibdocfile_webinterface.py",
line 133, in getfile
bibarchive = BibRecDocs(self.recid)
File "/usr/local/lib/python2.7/site-packages/<*****>/bibdocfile.py", line
607, in __init__
self.build_bibdoc_list()
File "/usr/local/lib/python2.7/site-packages/<*****>/bibdocfile.py", line
722, in build_bibdoc_list
status<>'DELETED' ORDER BY docname ASC""", (self.id,))
File "/usr/local/lib/python2.7/site-packages/<*****>/dbquery.py", line 215,
in run_sql
rc = cur.execute(sql, param)
File "/usr/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205,
in execute
self.errorhandler(self, exc, value)
File "/usr/local/lib/python2.7/site-packages/MySQLdb/connections.py", line
36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1052, "Column 'docname' in order clause is ambiguous")
** Stack frame details
Frame defaulterrorhandler in
/usr/local/lib/python2.7/site-packages/MySQLdb/connections.py at line 36
-------------------------------------------------------------------------------
33 connection.messages.append(error)
34 del cursor
35 del connection
----> 36 raise errorclass, errorvalue
37
38 re_numeric_part = re.compile(r"^(\d+)")
39
-------------------------------------------------------------------------------
errorclass = "<class '_mysql_exceptions.OperationalError'>"
errorvalue = 'OperationalError(1052, "Column \'docname\' in
order clause is ambiguous")'
error = '(<class
\'_mysql_exceptions.OperationalError\'>, OperationalError(1052, "Column
\'docname\' in order clause is ambiguous"))'
Thank you.
György Váradi
Librarian
Centre for Economic and Regional Studies
Hungarian Academy of Sciences
Pécs, Hungary
