search

in2code-de / lux

Living User eXperience - LUX - the Marketing Automation tool for TYPO3.
https://www.in2code.de/produkte/lux-typo3-marketing-automation/
18 stars 11 forks source link

OrderBy categoryscorings.scoring causes SQL error in lead list #60

Open ffellbaum opened 3 hours ago

ffellbaum commented 3 hours ago

Selecting a categoryScoring in Lead list causes SQL error "Expression #2 of ORDER BY clause is not in SELECT list, references column 'hydac.tx_lux_domain_model_categoryscoring.scoring' which is not in SELECT list; this is incompatible with DISTINCT"

Class: In2code\Lux\Domain\Repository\VisitorRepository

Functions: findAllWithIdentifiedFirst() / getOrderingsArrayByFilterDto()

einpraegsam commented 2 hours ago

Thx for reporting. Can you pls report some more information like TYPO3 version, LUX version, MySQL version, SQL mode and where I exactly have to click in backend to reproduce this error?