#93496RecordsXmlSitemapDataProvider Unknown column 'sorting'
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’;
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.