[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