Categories of tt_content element wont work

kartolo / direct_mail

it's an newsletter sending extension for the TYPO3 CMS

40 stars 115 forks source link

Categories of tt_content element wont work #116

Open opaque01 opened 6 years ago

opaque01 commented 6 years ago

TYPO3: 8.7.13 direct_mail: 5.2.2 PHP: 7

It works perfect in the backend but the rendering of the page fails with this error: Call to undefined method TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer::exec_mm_query_uidList()

Error thrown in file /typo3conf/ext/direct_mail/Classes/Container.php in line 74.

best regards opaque

djangones commented 6 years ago

I can confirm that problem in TYPO3: 8.7.17 direct_mail: 5.2.2 PHP: 7.1

Is there a solution or patch available or does anybody knows a replacement for that method?

dgnhrdt commented 5 years ago

I fixed the bug by using the SQL Query used in exec_mm_query_uidList(): Change lines 74 - 82 in EXT:direct_mail/Classes/Container.php with the following code: $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery( $select, $mmTable . ($foreignTable ? ',' . $foreignTable : ''), $mmTable . '.uid_local IN (' . $localTableUidList . ')' . ($foreignTable ? ' AND ' . $foreignTable . '.uid=' . $mmTable . '.uid_foreign' : '') . $whereClause, '', $orderBy, '');

andreas83 commented 4 years ago

I fixed the bug by using the SQL Query used in exec_mm_query_uidList():

worked for me, thanks typo3_ 8.7.26 direct_mail: 5.2.3