Hi again,
I’m trying to setup WebSubmit, it’s not that easy with the incomplete
documentation (e.g. what’s the meaning of the functions and their params?); my
current state gives an error on submit, and even the demo installation isn’t
better, just gives other errors…
While submitting a DEMO THESIS or DEMO PICTURE, the error is "Unknown column
'brbd.docname'"; the relevant parts of the traceback are:
"""
Frame execute in /usr/lib/python2.7/dist-packages/MySQLdb/cursors.py at line 174
-------------------------------------------------------------------------------
171 exc, value, tb = sys.exc_info()
172 del tb
173 self.messages.append((exc, value))
----> 174 self.errorhandler(self, exc, value)
175 self._executed = query
176 if not self._defer_warnings: self._warning_check()
177 return r
-------------------------------------------------------------------------------
charset = "'utf8'"
exc = "<class '_mysql_exceptions.OperationalError'>"
self = '<MySQLdb.cursors.Cursor object at
0x7f5b741bec10>'
args = '(108,)'
db = '<weakproxy at 0x7f5b741cd5d0 to Connection at
0x7f5b740189e0>'
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"'
Frame run_sql in /usr/local/lib/python2.7/dist-packages/invenio/dbquery.py at
line 222
-------------------------------------------------------------------------------
219 rc = cur.execute(sql, param)
220 gc.enable()
221 except (OperationalError, InterfaceError): # unexpected
disconnect, bad malloc error, etc
----> 222 raise
223
224 if string.upper(string.split(sql)[0]) in ("SELECT", "SHOW",
"DESC", "DESCRIBE"):
225 if n:
-------------------------------------------------------------------------------
cur = '<MySQLdb.cursors.Cursor object at
0x7f5b741bec10>'
with_desc = 'False'
dbhost = "'localhost'"
db = "<_mysql.connection open to 'localhost' at
7f5b740189e0>"
param = '(108,)'
n = '0'
sql = '"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=%s AND\\n
bd.status<>\'DELETED\' ORDER BY brbd.docname ASC"'
with_dict = 'False'
run_on_slave = 'False'
"""
With my own UCA BOOK type, the error is in Report_Number_Generation; I get:
"""
* 2013-10-22 08:44:02 -> IOError: [Errno 2] No such file or directory:
'/opt/invenio/var/data/submit/storage/running/UCA_BOOK/1382424018_19858/auto'
(Report_Number_Generation.py:101:Report_Number_Generation)
...
** Stack frame details
Frame Report_Number_Generation in
/opt/invenio/lib/python/invenio/websubmit_functions/Report_Number_Generation.py
at line 101
-------------------------------------------------------------------------------
98 else :
99 # If yeargen != auto then the contents of the file named
'yeargen' is used
100 # Assumes file uses DD-MM-YYYY format
----> 101 fp = open("%s/%s" % (curdir, parameters['yeargen']), "r")
102 mydate = fp.read()
103 fp.close()
104 yy = re.sub("^......", "", mydate)
-------------------------------------------------------------------------------
user_info = "{'uid': 1, 'agent': 'Mozilla/5.0 (Macintosh;
Intel Mac OS X 10_8_5) AppleWebKit/536.30.1 (KHTML, like Gecko) Version/6.0.5
Safari/536.30.1', 'precached_viewclaimlink': False, 'session':
'c93fc594c139522a3d4cec7ca309a08d', 'precached_useadmin': True, 'group': [],
'guest': '0', 'precached_usepaperattribution': True, 'precached_usepaperclaim':
True, 'precached_viewsubmissions': True, 'precached_usegroups': True, 'email':
'[email protected]', 'precached_usealerts': True, 'precached_usestats': Tr
[...]
parameters = "{'initialvalue': '', 'nblength': '', 'edsrn':
'UCABOOK_RN', 'rnin': 'comboUCABOOK', 'counterpath':
'lastid_UCABOOK_<PA>yyyy</PA>', 'autorngen': 'Y', 'rnformat':
'UCA-BOOK-<PA>yyyy</PA>', 'yeargen': 'auto'}"
form = '{\'UCA__FILE\': [Field(\'UCA__FILE\',
\'%PDF-1.5\\r%\\xe2\\xe3\\xcf\\xd3\\r\\n1 0 obj\\r<</Metadata 2205 0 R/Pages 2
0 R/OCProperties<</D<</RBGroups[]/ON[23 0 R 27 0 R 31 0 R 35 0 R 292 0 R 320 0
R 345 0 R 376 0 R 393 0 R 410 0 R 431 0 R 470 0 R 474 0 R 478 0 R 494 0 R 550 0
R 574 0 R 581 0 R 586 0 R 624 0 R 632 0 R 637 0 R 690 0 R 697 0 R 810 0 R 866 0
R 907 0 R 948 0 R 952 0 R 1125 0 R 1129 0 R 1133 0 R 1137 0 R 1394 0 R 1422 0 R
1447 0 R 1478 0 R 1495 0 R 1512 0 R 1533 0 R 1572 0 R 1576 0 R [...]
nb_length = '3'
curdir =
"'/opt/invenio/var/data/submit/storage/running/UCA_BOOK/1382424018_19858'"
Frame <module> in <string> at line 1
fcntl = "<module 'fcntl' (built-in)>"
last_step = '1'
uid = '1'
__websubmit_in_jail__ = 'True'
mymkdir = '<function mymkdir at 0x2b57851e7f50>'
action_score = '-1'
Report_Number_Generation = '<function Report_Number_Generation at
0x2b5786e31c08>'
Create_Recid = '<function Create_Recid at 0x2b5774be3e60>'
__revision__ = "'$Id$'"
parameters = "{'initialvalue': '', 'nblength': '', 'edsrn':
'UCABOOK_RN', 'rnin': 'comboUCABOOK', 'counterpath':
'lastid_UCABOOK_<PA>yyyy</PA>', 'autorngen': 'Y', 'rnformat':
'UCA-BOOK-<PA>yyyy</PA>', 'yeargen': 'auto'}"
re = "<module 're' from '/usr/lib/python2.6/re.pyc'>"
ln = "'en'"
errno = "<module 'errno' (built-in)>"
sysno = '1L'
access = "'1382424018_19858'"
user_info = "{'uid': 1, 'agent': 'Mozilla/5.0 (Macintosh;
Intel Mac OS X 10_8_5) AppleWebKit/536.30.1 (KHTML, like Gecko) Version/6.0.5
Safari/536.30.1', 'precached_viewclaimlink': False, 'session':
'c93fc594c139522a3d4cec7ca309a08d', 'precached_useadmin': True, 'group': [],
'guest': '0', 'precached_usepaperattribution': True, 'precached_usepaperclaim':
True, 'precached_viewsubmissions': True, 'precached_usegroups': True, 'email':
'[email protected]', 'precached_usealerts': True, 'precached_usestats': Tr
[...]
curdir =
"'/opt/invenio/var/data/submit/storage/running/UCA_BOOK/1382424018_19858'"
InvenioWebSubmitFunctionError = "<class
'invenio.websubmit_config.InvenioWebSubmitFunctionError'>"
rn = "''"
__doc__ = "'Description: function
Report_Number_Generation\\n This function creates a reference
for the submitted\\n document and saves it in the specified
file.\\n Author: T.Baron'"
uid_email = "'[email protected]'"
function = '<function Report_Number_Generation at
0x2b5786e31c08>'
form = '{\'UCA__FILE\': [Field(\'UCA__FILE\',
\'%PDF-1.5\\r%\\xe2\\xe3\\xcf\\xd3\\r\\n1 0 obj\\r<</Metadata 2205 0 R/Pages 2
0 R/OCProperties<</D<</RBGroups[]/ON[23 0 R 27 0 R 31 0 R 35 0 R 292 0 R 320 0
R 345 0 R 376 0 R 393 0 R 410 0 R 431 0 R 470 0 R 474 0 R 478 0 R 494 0 R 550 0
R 574 0 R 581 0 R 586 0 R 624 0 R 632 0 R 637 0 R 690 0 R 697 0 R 810 0 R 866 0
R 907 0 R 948 0 R 952 0 R 1125 0 R 1129 0 R 1133 0 R 1137 0 R 1394 0 R 1422 0 R
1447 0 R 1478 0 R 1495 0 R 1512 0 R 1533 0 R 1572 0 R 1576 0 R [...]
__builtins__ = '{\'bytearray\': <type \'bytearray\'>,
\'IndexError\': <type \'exceptions.IndexError\'>, \'all\': <built-in function
all>, \'help\': Type help() for interactive help, or help(object) for help
about object., \'vars\': <built-in function vars>, \'SyntaxError\': <type
\'exceptions.SyntaxError\'>, \'unicode\': <type \'unicode\'>,
\'UnicodeDecodeError\': <type \'exceptions.UnicodeDecodeError\'>,
\'isinstance\': <built-in function isinstance>, \'copyright\': Copyright (c)
2001-2010 Python Software Fou [...]
run_sql = '<function run_sql at 0x2b5785011938>'
time = "<module 'time' (built-in)>"
step = "'1'"
CFG_WEBSUBMIT_COUNTERSDIR = "'/opt/invenio/var/data/submit/counters'"
Request_Print = '<function Request_Print at 0x2b5786b30d70>'
create_reference = '<function create_reference at 0x2b5786e31de8>'
doctype = "'UCA_BOOK'"
act = "'SBI'"
action = "'SBI'"
os = "<module 'os' from '/usr/lib/python2.6/os.pyc'>"
"""
Can you give me a hint?
Greetlings, Hraban
