I'm trying to implement pagination on sqlite query results but i'm getting the error below. When i use the example given in flask-paginate everything works fine but i trying to simulate a full text search so i'm using UNION in my query and everything seems to work in command line but when i do this in flask flask-paginate returns an exception.
Traceback (most recent call last):
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\venv\lib\site-packages\flask\app.py", line 1836, in __call__
return self.wsgi_app(environ, start_response)
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\venv\lib\site-packages\flask\app.py", line 1820, in wsgi_app
response = self.make_response(self.handle_exception(e))
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\venv\lib\site-packages\flask\app.py", line 1403, in handle_exception
reraise(exc_type, exc_value, tb)
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\venv\lib\site-packages\flask\app.py", line 1817, in wsgi_app
response = self.full_dispatch_request()
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\venv\lib\site-packages\flask\app.py", line 1477, in full_dispatch_request
rv = self.handle_user_exception(e)
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\venv\lib\site-packages\flask\app.py", line 1381, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\venv\lib\site-packages\flask\app.py", line 1475, in full_dispatch_request
rv = self.dispatch_request()
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\venv\lib\site-packages\flask\app.py", line 1461, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\routes.py", line 263, in search_results
pagination=pagination,
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\venv\lib\site-packages\flask\templating.py", line 128, in render_template
context, ctx.app)
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\venv\lib\site-packages\flask\templating.py", line 110, in _render
rv = template.render(context)
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\venv\lib\site-packages\jinja2\environment.py", line 989, in render
return self.environment.handle_exception(exc_info, True)
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\venv\lib\site-packages\jinja2\environment.py", line 754, in handle_exception
reraise(exc_type, exc_value, tb)
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\templates\searchResults.html", line 1, in top-level template code
{% extends 'base.html' %}
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\templates\base.html", line 51, in top-level template code
{% block body %}{% endblock %}
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\templates\searchResults.html", line 21, in block "body"
{{ pagination.links }}
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\venv\lib\site-packages\jinja2\environment.py", line 408, in getattr
return getattr(obj, attribute)
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\venv\lib\site-packages\flask_paginate\__init__.py", line 340, in links
if self.total_pages <= 1:
File "C:\Users\mundia\OneDrive\101Python\popFlaskPaginate\popFlaskPaginate\venv\lib\site-packages\flask_paginate\__init__.py", line 206, in total_pages
pages = divmod(current_total, self.per_page)
TypeError: unsupported operand type(s) for divmod(): 'unicode' and 'int'