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

[Johannes C. Schulz - EnzephaloN IT-Solutions]

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