http://forge.typo3.org/http://forge.typo3.org/themes/typo3_forge/favicon/favicon.png?17058661692018-03-15T17:37:40ZTYPO3 ForgeTYPO3 Core - Bug #84303: Uncaught exception while executing query on Microsoft SQL Serverhttp://forge.typo3.org/issues/84303?journal_id=3608422018-03-15T17:37:40ZStephan Großberndt
<ul></ul><pre>
Column "pages.pid" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause
</pre> TYPO3 Core - Bug #84303: Uncaught exception while executing query on Microsoft SQL Serverhttp://forge.typo3.org/issues/84303?journal_id=3629302018-04-05T17:31:06ZGerrit Code Review
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Under Review</i></li></ul><p>Patch set 1 for branch <strong>master</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="https://review.typo3.org/56571">https://review.typo3.org/56571</a></p> TYPO3 Core - Bug #84303: Uncaught exception while executing query on Microsoft SQL Serverhttp://forge.typo3.org/issues/84303?journal_id=3629952018-04-06T12:41:03ZAndrej K
<ul></ul><p>After applying changeset, there is this error:</p>
<p>Oops, an error occurred!</p>
<p>An exception occurred while executing 'SELECT [pages].[uid], [pages].[pid], <abbr title="*">COUNT</abbr> AS [count], <abbr title="[sys_template].[root]">MAX</abbr> AS [root_max_val], <abbr title="[sys_template].[root]">MIN</abbr> AS [root_min_val] FROM [pages], [sys_template] WHERE ([pages].[uid] = [sys_template].[pid]) AND ((([pages].[deleted] = 0) AND ([sys_template].[deleted] = 0)) AND ((([pages].[t3ver_wsid] = 0) OR ([pages].[t3ver_state] <= 0)) AND (([sys_template].[t3ver_wsid] = 0) OR ([sys_template].[t3ver_state] <= 0)))) GROUP BY [pages].[uid] ORDER BY [pages].[pid] ASC, [pages].[sorting] ASC': SQLSTATE [42000, 8120]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Column 'pages.pid' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. SQLSTATE [42000, 8180]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Statement(s) could not be prepared.</p> TYPO3 Core - Bug #84303: Uncaught exception while executing query on Microsoft SQL Serverhttp://forge.typo3.org/issues/84303?journal_id=3634262018-04-12T18:01:24ZGerrit Code Review
<ul></ul><p>Patch set 2 for branch <strong>master</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="https://review.typo3.org/56571">https://review.typo3.org/56571</a></p> TYPO3 Core - Bug #84303: Uncaught exception while executing query on Microsoft SQL Serverhttp://forge.typo3.org/issues/84303?journal_id=3634302018-04-12T21:14:19ZGerrit Code Review
<ul></ul><p>Patch set 3 for branch <strong>master</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="https://review.typo3.org/56571">https://review.typo3.org/56571</a></p> TYPO3 Core - Bug #84303: Uncaught exception while executing query on Microsoft SQL Serverhttp://forge.typo3.org/issues/84303?journal_id=3634322018-04-12T22:27:12ZGerrit Code Review
<ul></ul><p>Patch set 4 for branch <strong>master</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="https://review.typo3.org/56571">https://review.typo3.org/56571</a></p> TYPO3 Core - Bug #84303: Uncaught exception while executing query on Microsoft SQL Serverhttp://forge.typo3.org/issues/84303?journal_id=3634672018-04-14T15:14:53ZGerrit Code Review
<ul></ul><p>Patch set 1 for branch <strong>TYPO3_8-7</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="https://review.typo3.org/56656">https://review.typo3.org/56656</a></p> TYPO3 Core - Bug #84303: Uncaught exception while executing query on Microsoft SQL Serverhttp://forge.typo3.org/issues/84303?journal_id=3634702018-04-14T15:30:04ZGeorg Ringer
<ul><li><strong>Status</strong> changed from <i>Under Review</i> to <i>Resolved</i></li><li><strong>% Done</strong> changed from <i>0</i> to <i>100</i></li></ul><p>Applied in changeset <a class="changeset" title="[BUGFIX] Add missing column in database query To avoid exceptions on certain database systems th..." href="http://forge.typo3.org/projects/typo3cms-core/repository/1749/revisions/a3828a4d4eea0c7dccb035a930ebc24393b5fd06">a3828a4d4eea0c7dccb035a930ebc24393b5fd06</a>.</p> TYPO3 Core - Bug #84303: Uncaught exception while executing query on Microsoft SQL Serverhttp://forge.typo3.org/issues/84303?journal_id=3766922018-10-02T10:50:00ZBenni Mackbenni@typo3.org
<ul><li><strong>Status</strong> changed from <i>Resolved</i> to <i>Closed</i></li></ul>