TYPO3 Forge: Issueshttp://forge.typo3.org/http://forge.typo3.org/themes/typo3_forge/favicon/favicon.png?17058661692016-04-20T18:44:27ZTYPO3 Forge
Redmine TYPO3 Core - Bug #75824 (Closed): Doctrine: migrate ext:tstemplate/TypoScriptTemplateModuleContro...http://forge.typo3.org/issues/758242016-04-20T18:44:27ZChristoph Kratzckr@rtp.chTYPO3 Core - Bug #75822 (Closed): Wrong backticks when using a doctrine select on count(), max(),...http://forge.typo3.org/issues/758222016-04-20T18:31:37ZChristoph Kratzckr@rtp.ch
<p>While migrating the old SQL to the new doctrine I found the following issue. You will find the original query under typo3/sysext/filelist/Classes/FileList.php.</p>
<p><strong>Testcase:</strong></p>
<pre>
/** @var QueryBuilder $queryBuilder */
$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('pages','sys_template');
$result = $queryBuilder
->select('pages.uid', 'count(*)', 'max(sys_template.root)', 'min(sys_template.root)')
->from('pages')
->from('sys_template')
->where(
$queryBuilder->expr()->eq('pages.uid', 'sys_template.pid')
)
->andWhere(QueryHelper::stripLogicalOperatorPrefix(BackendUtility::deleteClause('pages')))
->andWhere(QueryHelper::stripLogicalOperatorPrefix(BackendUtility::versioningPlaceholderClause('pages')))
->andWhere(QueryHelper::stripLogicalOperatorPrefix(BackendUtility::deleteClause('sys_template')))
->andWhere(QueryHelper::stripLogicalOperatorPrefix(BackendUtility::versioningPlaceholderClause('sys_template')))
->groupBy('pages.uid')
->orderBy('pages.pid')
->addOrderBy('pages.sorting')
->setMaxResults(1)
->getSQL();
</pre>
<p><strong>Wrong result:</strong></p>
<p>SELECT `pages`.`uid`, `count(*)`, `max(sys_template`.`root)`, `min(sys_template`.`root)` FROM `pages`, `sys_template` WHERE (`pages`.`uid` = sys_template.pid) AND (pages.deleted=0) AND ((pages.t3ver_state <= 0 OR pages.t3ver_wsid = 0)) AND (sys_template.deleted=0) AND ((sys_template.t3ver_state <= 0 OR sys_template.t3ver_wsid = 0)) AND ((`pages`.`hidden` = 0) AND (`pages`.`starttime` <= 1461168600) AND ((`pages`.`endtime` = 0) OR (`pages`.`endtime` > 1461168600)) AND (`pages`.`deleted` = 0) AND (`sys_template`.`hidden` = 0) AND (`sys_template`.`starttime` <= 1461168600) AND ((`sys_template`.`endtime` = 0) OR (`sys_template`.`endtime` > 1461168600)) AND (`sys_template`.`deleted` = 0)) GROUP BY `pages`.`uid` ORDER BY `pages`.`pid` ASC, `pages`.`sorting` ASC LIMIT 1</p>
<p><strong>It should be possible to get something like:</strong></p>
<p>SELECT `pages`.`uid`, count(*), max(`sys_template`.`root`), min(`sys_template`.`root`) FROM `pages`, `sys_template` WHERE ...</p> TYPO3 Core - Bug #75761 (Closed): Create a script for finding duplicate exception codes for Travishttp://forge.typo3.org/issues/757612016-04-18T23:41:49ZChristoph Kratzckr@rtp.chTYPO3 Core - Bug #75754 (Closed): Document further options for mail post processorhttp://forge.typo3.org/issues/757542016-04-18T19:12:11ZChristoph Kratzckr@rtp.ch
<ul>
<li>As it's possible to configure the template to use for each instance of<br /> the post processor, this should be documented.</li>
<li>Also grouped options regarding part. E.g. email or frontend</li>
<li>messages.</li>
</ul> TYPO3 Core - Bug #75737 (Closed): Remove duplicate exception numbershttp://forge.typo3.org/issues/757372016-04-18T13:39:44ZChristoph Kratzckr@rtp.chTYPO3 Core - Task #75729 (Closed): Update jQuery to 2.2.3http://forge.typo3.org/issues/757292016-04-18T11:02:07ZChristoph Kratzckr@rtp.ch
<p>The current jQuery version is obsolete and must be replaced with the newest version. The target version is the version 2.2.3.</p>