October: Column not found: 1054 Unknown column 'any_template' in 'order clause'

Created on 9 Jul 2019 · 3Comments · Source: octobercms/october

OctoberCMS Build: 455
PHP Version: 7
Database Engine: MySQL

Description & steps:

1) Log settings -> Log theme changes ENABLED
2) LOGS -> Theme log (/backend/cms/themelogs)
3) Try sort column "Template"

4) Result error:

p.s.:
list setup

How to cancel the sorting settings? I can't get into theme logs anymore.

Completed Bug

Source

plyusninva

All 3 comments

How to cancel the sorting settings? I can't get into theme logs anymore.

You can log out with your back-end user to restore sorting to defaults.

NathanBastiaans on 9 Jul 2019

👍1

How to cancel the sorting settings? I can't get into theme logs anymore.

You can log out with your back-end user to restore sorting to defaults.

Thank you very much! :-)

plyusninva on 9 Jul 2019

@NathanBastiaans @plyusninva Note that in Build 457 that will no longer work as sorting will be saved as a user preference instead of a session variable. To fix it in the future temporarily (before an official fix is released) just add sortable: false to the offending column definition.