[TYPO3-mvc] Query causes "lost connection to database"

[Patrick Schriner]

That's easy - it's described here:

http://forge.typo3.org/projects/typo3v4-mvc/wiki/Default_Orderings_and_Query_Settings_in_Repository

Basically you use can use the repositories (implicit) initializeObject  
method to enforce such settings for all calls using that repository.

Patrick

On Tue, 09 Jul 2013 13:16:20 +0200, Johannes C. Schulz - EnzephaloN  
IT-Solutions <info at enzephalon.de> wrote:

> Again me...
>
> In more detail: is there a way to set
> "$setting->setRespectSysLanguage(false); globaly for the whole extension?
>
> Best regards
> Johannes
>
> „Programmer - n. [proh-gram-er] an organism that turns caffeine and pizza
> into software“
>
> -----Ursprüngliche Nachricht-----
> Von: typo3-project-typo3v4mvc-bounces at lists.typo3.org
> [mailto:typo3-project-typo3v4mvc-bounces at lists.typo3.org] Im Auftrag von
> Johannes C. Schulz - EnzephaloN IT-Solutions
> Gesendet: Dienstag, 9. Juli 2013 12:54
> An: 'TYPO3 v4 MVC project'
> Betreff: [TYPO3-mvc] Query causes "lost connection to database"
>
> 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
>
> _______________________________________________
> TYPO3-project-typo3v4mvc mailing list
> TYPO3-project-typo3v4mvc at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-typo3v4mvc
>
>


-- 
Patrick Schriner