in2code-de / in2publish_core

in2publish Community Version
https://www.in2code.de/produkte/content-publisher/
GNU General Public License v3.0
40 stars 23 forks source link

Unknown column 'COUNT(uid)' in 'field list' #81

Closed paysafewebdev closed 4 years ago

paysafewebdev commented 4 years ago

After upgrading to in2publish_core 9.2.0, tests always fail with error in backend: An exception occurred while executing 'SELECTCOUNT(uid)FROMsys_domainWHEREpid= ?' with params [1090]: Unknown column 'COUNT(uid)' in 'field list'

Error seems to come from file typo3conf\ext\in2publish_core\Classes\Testing\Tests\Application\AbstractDomainTest.php line 227 where we should use count instead of select: https://docs.typo3.org/m/typo3/reference-coreapi/master/en-us/ApiOverview/Database/QueryBuilder/Index.html#count