Project

General

Profile

Actions
Copy link

Task #93496

closed

RecordsXmlSitemapDataProvider Unknown column 'sorting'

Added by Mayer Patrick almost 4 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Richard Haeser
Category:
SEO
Target version:
-
Start date:
2021-02-12
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
10
PHP Version:
7.3
Tags:
Complexity:
Sprint Focus:

Description

If you want to create a sitemap of data records, you do this (according to the instructions) with the RecordsXmlSitemapDataProvider.
If the table of the data does not have the field 'sorting', an error is generated.
(There are actually tables that don't need sorting)

Fri, 12 Feb 2021 14:16:09 +0100 [ALERT] request="bb09da45742eb" component="TYPO3.CMS.Frontend.ContentObject.Exception.ProductionExceptionHandler": Oops, an error occurred! Code: 20210212141609f5e95aac - {"exception":"Doctrine\\DBAL\\Driver\\Mysqli\\MysqliException: Unknown column 'sorting' in 'order clause' in /home/xxx/www/xxx/typo3_src-10.4.12/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:87

public function generateItems()
$sortField = $this->config['sortField'] ?? 'sorting';

Files

stacktrace.txt (1.94 KB) stacktrace.txt Mayer Patrick, 2021-02-12 14:17
Actions
Copy link

Also available in: Atom PDF