advanced search error

[Andei]

Describe the bug/problem
advanced search error

Logfile
Traceback (most recent call last):
File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2073, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1518, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1516, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1502, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
File "/app/calibre-web/cps/usermanagement.py", line 38, in decorated_view
return login_required(func)(*args, **kwargs)
File "/usr/local/lib/python3.8/dist-packages/flask_login/utils.py", line 272, in decorated_view
return func(*args, **kwargs)
File "/app/calibre-web/cps/web.py", line 753, in books_list
return render_books_list(data, sort_param, book_id, page)
File "/app/calibre-web/cps/web.py", line 375, in render_books_list
return render_adv_search_results(term, offset, order, config.config_books_per_page)
File "/app/calibre-web/cps/web.py", line 1277, in render_adv_search_results
read_column = cc[config.config_read_column]
IndexError: list index out of range

Environment (please complete the following information):

• OS: Windows 10
• Python version:python2.7.18
• Calibre-Web version: 0.6.17
• Docker container: Synology NAS
• Browser: Firefox 98.0.1

[OzzieIsaacs]

Calibre-Web is configured to have linked a custom calibre column to the read status. (?).
Looks the linked column is no longer in the database present. (?)
Please go to basic UI configuration and check the value of "Link Read/Unread Status to Calibre Column".
It's possible that entering this menu and just clicking save will resolve the issue.

[Andei]

It was set correctly. Nevertheless I saved it again, but the error still happens

[OzzieIsaacs]

In calibre itself it‘s possible to mark a column as inactive or deleted or something like this, could you please doublecheck this?

[OzzieIsaacs]

In the newest nightly version the error is catched and should lead to a log entry but no longer to an exception.
If you don't find the problem I need the metadata.db and the app.db file and I can have a look why this is happening if everything is set up correct

[Andei]

Sorry for the late reply.
There wasn't any column inactive or deleted. Maybe it's because of my 20k entries in the DB? My metadata.db is 40MB,
Where do I find the app.db, please?

[OzzieIsaacs]

Found it. Epic fail

[Andei]

Thx for you time!

[OzzieIsaacs]

Please check the newest nightly version, the error should disappear now. The reason was that the custom columns were wrongly linked to the search query in case of a configured read column

[Andei]

Any column? I don’t think so but it could be possible, I have to check it at the evening Ozzie Isaacs ***@***.***> schrieb am So. 20. März 2022 um 11:27:

In calibre itself it‘s possible to mark a column as inactive or deleted or something like this, could you please doublecheck this? — Reply to this email directly, view it on GitHub <#2341 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABYCWMXA5EB4XNGDC2XYYE3VA34SHANCNFSM5REICJ2A> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you authored the thread.Message ID: ***@***.***>

-- Sent from Gmail Mobile