Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Closed
plyusninva opened this issue Jul 9, 2019 · 3 comments
Closed

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

plyusninva opened this issue Jul 9, 2019 · 3 comments
Labels
Status: Completed Type: Bug
Milestone
v1.0.457

Comments

@plyusninva
Copy link

plyusninva commented Jul 9, 2019 •
edited
Loading

  • 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"
    image
  4. Result error:
    image

p.s.:
list setup
image

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

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.

@plyusninva
Copy link
Author

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! :-)

@LukeTowers
Copy link
Contributor

@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.

@LukeTowers LukeTowers added this to the v1.0.457 milestone Jul 9, 2019
LukeTowers added a commit that referenced this issue Jul 9, 2019
Disable searching and sorting on any_template
e0e951d 
Fixes #4441. Make the new template and old template columns visible and sort by them instead if you need to sort by that column.
@summercms summercms mentioned this issue Oct 24, 2020
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Status: Completed Type: Bug
Milestone
v1.0.457
Development

No branches or pull requests
3 participants
@LukeTowers @NathanBastiaans @plyusninva