[TYPO3-mvc] Query causes "lost connection to database"
Johannes C. Schulz - EnzephaloN IT-Solutions
info at enzephalon.de
Tue Jul 9 12:54:25 CEST 2013
Hello
I've some trouble with an extbase-extension and typo3 6.0.6.
The extension only uses german data, also shown on English, French and Dutch
sites.
There is a COUNT-statement, which causes a internal server error (lost
connection to database).
The query looks like:
SELECT COUNT(*) FROM tx_wrmevents_domain_model_date
WHERE tx_wrmevents_domain_model_date.deleted=0
AND tx_wrmevents_domain_model_date.t3ver_state<=0
AND tx_wrmevents_domain_model_date.pid<>-1
AND tx_wrmevents_domain_model_date.hidden=0
AND (tx_wrmevents_domain_model_date.sys_language_uid IN (2,-1)
OR (tx_wrmevents_domain_model_date.sys_language_uid=0
AND tx_wrmevents_domain_model_date.uid NOT IN (
SELECT tx_wrmevents_domain_model_date.l18n_parent FROM
tx_wrmevents_domain_model_date
WHERE tx_wrmevents_domain_model_date.l18n_parent>0
AND tx_wrmevents_domain_model_date.sys_language_uid>0
AND tx_wrmevents_domain_model_date.deleted=0
)
)
) AND tx_wrmevents_domain_model_date.pid IN (47, 54, 55, 49)
If I delete all the language-stuff and run:
SELECT COUNT(*) FROM tx_wrmevents_domain_model_date
WHERE tx_wrmevents_domain_model_date.deleted=0
AND tx_wrmevents_domain_model_date.t3ver_state<=0
AND tx_wrmevents_domain_model_date.pid<>-1
AND tx_wrmevents_domain_model_date.hidden=0
AND tx_wrmevents_domain_model_date.pid IN (47, 54, 55, 49)
All looks fine - no errors or something like that.
Is there a way to force extbase NOT using ANY language-queries?! Cause I
think these are the ones how break the query.
Thanks a lot.
Johannes
More information about the TYPO3-project-typo3v4mvc
mailing list