SHARE
TWEET

Calibre-Web 500 Error

silentArtifact Apr 3rd, 2019 162 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [2019-04-03 20:40:54,076] ERROR in app: Exception on /series [GET]
  2.  
  3. Traceback (most recent call last):
  4.  
  5.   File "/usr/lib/python2.7/site-packages/flask/app.py", line 2292, in wsgi_app
  6.  
  7.     response = self.full_dispatch_request()
  8.  
  9.   File "/usr/lib/python2.7/site-packages/flask/app.py", line 1815, in full_dispatch_request
  10.  
  11.     rv = self.handle_user_exception(e)
  12.  
  13.   File "/usr/lib/python2.7/site-packages/flask/app.py", line 1718, in handle_user_exception
  14.  
  15.     reraise(exc_type, exc_value, tb)
  16.  
  17.   File "/usr/lib/python2.7/site-packages/flask/app.py", line 1813, in full_dispatch_request
  18.  
  19.     rv = self.dispatch_request()
  20.  
  21.   File "/usr/lib/python2.7/site-packages/flask/app.py", line 1799, in dispatch_request
  22.  
  23.     return self.view_functions[rule.endpoint](**req.view_args)
  24.  
  25.   File "/app/calibre-web/cps/web.py", line 344, in decorated_view
  26.  
  27.     return login_required(func)(*args, **kwargs)
  28.  
  29.   File "/usr/lib/python2.7/site-packages/flask_login/utils.py", line 261, in decorated_view
  30.  
  31.     return func(*args, **kwargs)
  32.  
  33.   File "/app/calibre-web/cps/web.py", line 1413, in series_list
  34.  
  35.     .group_by('books_series_link.series').order_by(db.Series.sort).all()
  36.  
  37.   File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3160, in all
  38.  
  39.     return list(self)
  40.  
  41.   File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3316, in __iter__
  42.  
  43.     return self._execute_and_instances(context)
  44.  
  45.   File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3341, in _execute_and_instances
  46.  
  47.     result = conn.execute(querycontext.statement, self._params)
  48.  
  49.   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute
  50.  
  51.     return meth(self, multiparams, params)
  52.  
  53.   File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
  54.  
  55.     return connection._execute_clauseelement(self, multiparams, params)
  56.  
  57.   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1098, in _execute_clauseelement
  58.  
  59.     else None,
  60.  
  61.   File "<string>", line 1, in <lambda>
  62.  
  63.   File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 462, in compile
  64.  
  65.     return self._compiler(dialect, bind=bind, **kw)
  66.  
  67.   File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 468, in _compiler
  68.  
  69.     return dialect.statement_compiler(dialect, self, **kw)
  70.  
  71.   File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 562, in __init__
  72.  
  73.     Compiled.__init__(self, dialect, statement, **kwargs)
  74.  
  75.   File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 319, in __init__
  76.  
  77.     self.string = self.process(self.statement, **compile_kwargs)
  78.  
  79.   File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 350, in process
  80.  
  81.     return obj._compiler_dispatch(self, **kwargs)
  82.  
  83.   File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 91, in _compiler_dispatch
  84.  
  85.     return meth(self, **kw)
  86.  
  87.   File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 2115, in visit_select
  88.  
  89.     text, select, inner_columns, froms, byfrom, kwargs
  90.  
  91.   File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 2219, in _compose_select_body
  92.  
  93.     text += self.group_by_clause(select, **kwargs)
  94.  
  95.   File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 2277, in group_by_clause
  96.  
  97.     group_by = select._group_by_clause._compiler_dispatch(self, **kw)
  98.  
  99.   File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 104, in _compiler_dispatch
  100.  
  101.     return meth(self, **kw)
  102.  
  103.   File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 970, in visit_clauselist
  104.  
  105.     c._compiler_dispatch(self, **kw) for c in clauselist.clauses
  106.  
  107.   File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 968, in <genexpr>
  108.  
  109.     s
  110.  
  111.   File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 970, in <genexpr>
  112.  
  113.     c._compiler_dispatch(self, **kw) for c in clauselist.clauses
  114.  
  115.   File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 104, in _compiler_dispatch
  116.  
  117.     return meth(self, **kw)
  118.  
  119.   File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 772, in visit_textual_label_reference
  120.  
  121.     "Can't resolve label reference for ORDER BY / GROUP BY.",
  122.  
  123.   File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 4501, in _no_text_coercion
  124.  
  125.     "extra": "%s " % extra if extra else "",
  126.  
  127. CompileError: Can't resolve label reference for ORDER BY / GROUP BY. Textual SQL expression 'books_series_link.series' should be explicitly declared as text('books_series_link.series')
  128.  
  129. ::ffff:172.17.0.1 - - [2019-04-03 20:40:54] "GET /series HTTP/1.1" 500 412 0.053049
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top