Bug #81157

Typoscript SELECT: orderBy = rand() fails

Added by Oliver Hübner over 2 years ago. Updated 12 days ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
TypoScript
Target version:
-
Start date:
2017-05-06
Due date:
% Done:

0%

TYPO3 Version:
8
PHP Version:
7.1
Tags:
Typoscript, rand, rand(), select
Complexity:
Is Regression:
Sprint Focus:

Description

A Database-Query via Typoscript e.g.

...
table = pages
select {
pidInList = this
orderBy = rand()
}
...

ends with an error, because the ts get rendered the rand() in quoutes

... ORDER BY `rand()` ASC': Unknown column 'rand()' in 'order clause'

History

#1 Updated by Paul Hansen about 2 years ago

Try this:

select.orderBy = rand()
select.selectFields = pages.*,rand()

#2 Updated by Steffen Müller about 1 year ago

#3 Updated by Chris W 11 months ago

In TYPO3 9 this seems to be okay.

#4 Updated by Benni Mack 12 days ago

  • Status changed from New to Closed

I will close this now, as we won't fix this edge case for v8 anymore (already in Priority Bugfix / Security Bugfix mode). If you have any further questions, reach out to me so I can re-open the issue.

Also available in: Atom PDF