Advertisement
silentArtifact

Calibre-Web 500 Error

Apr 3rd, 2019
528
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.72 KB | None | 0 0
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement