search

visol-forks / ext-roq_newsevent

This repository is no longer maintained. Conside switching to EXT:newsevent. Contact us if you need support with migration - we'll gladly provide scripts.
1 stars 2 forks source link

Unknown column 'tx_news_domain_model_news.tx_roqnewsevent_enddate + tx_roqnewsevent_endtime' in 'where clause' #6

Open Georgyge opened 5 years ago

Georgyge commented 5 years ago

In List view, on debugging it is throwing an error as 'Unknown column 'tx_news_domain_model_news.tx_roqnewsevent_enddate + tx_roqnewsevent_endtime' in 'where clause'

Do I need to change the query?

jrenggli commented 5 years ago

@Georgyge what version of TYPO3 are you using?

Looks like it's no longer supported to use arbitrary field calculations in field name.

https://github.com/visol/ext-roq_newsevent/blob/master/Classes/Domain/Repository/EventRepository.php#L44

$query->greaterThan('tx_roqnewsevent_enddate + tx_roqnewsevent_endtime', $timestamp)
Georgyge commented 5 years ago

I am using typo3 8.7.19. So do I need to rewrite the query?

jrenggli commented 5 years ago

@Georgyge: Yes, would be great if you could rewrite this and create a PR