Sorting errors occurred for some fields

Problem/Motivation

After sorting some fields
The website encountered an unexpected error. Try again later.

Drupal\Core\Database\DatabaseExceptionWrapper: Exception in Frontpage[frontpage]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unknown' in 'ORDER BY': SELECT "node_field_data"."langcode" AS "node_field_data_langcode", "node_field_data"."nid" AS "nid" FROM "node_field_data" "node_field_data" ORDER BY "unknown" ASC LIMIT 20 OFFSET 0; Array ( ) in main() (line 19 of index.php).

Check all descriptions of the error in the attached photo.

Steps to reproduce

1. Create a View and set the Format to "FooTable".
2. Add a non-database field to the View (e.g., "Global: View result counter").
3. Go to the FooTable Format Settings and enable sorting for this specific column.
4. Save the View and navigate to the View page.
5. Click on the column header to sort.
6. The fatal DatabaseExceptionWrapper error is thrown.

Proposed resolution

The FooTable style plugin should check if a field is actually a sortable database column before attempting to alter the SQL query.
Non-database fields should either be disabled from being selected for sorting in the plugin settings form to prevent fatal errors.

Remaining tasks

None.

User interface changes

None.

API changes

None.

Data model changes

None.