SQL monster in 4.0.0

Author Message

Piotrek Karaƛ

Tuesday 09 March 2010 6:58:28 am

Does anyone have any idea where could an SQL monster like this come from?

SELECT e0.id AS e0_id, e0.link AS e0_link, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.is_alias AS e0_is_alias (...) e174.text_md5 AS e174_text_md5, e174.is_alias AS e174_is_alias, e175.id AS e175_id, e175.link AS e175_link, e175.text AS e175_text, e175.text_md5 AS e175_text_md5, e175.action AS e175_action, e175.is_alias AS e175_is_alias
FROM ezurlalias_ml e0, ezurlalias_ml e1, ezurlalias_ml e2, ezurlalias_ml e3, ezurlalias_ml e4, ezurlalias_ml e5, ezurlalias_ml e6, ezurlalias_ml e7, ezurlalias_ml e8, ezurlalias_ml e9, ezurlalias_ml e10, ezurlalias_ml e11, ezurlalias_ml e12, ezurlalias_ml e13, ezurlalias_ml e14, ezurlalias_ml e15 (...) ezurlalias_ml e168, ezurlalias_ml e169, ezurlalias_ml e170, ezurlalias_ml e171, ezurlalias_ml e172, ezurlalias_ml e173, ezurlalias_ml e174, ezurlalias_ml e175
WHERE e0.parent = 0 AND (e0.lang_mask & 3 > 0) AND e0.text_md5 =  MD5( 'layout' ) 
AND e1.parent = e0.link AND (e1.lang_mask & 3 > 0) AND e1.text_md5 =  MD5( 'set' ) 
AND e2.parent = e1.link AND (e2.lang_mask & 3 > 0) AND e2.text_md5 =  MD5( 'print' ) 
AND e3.parent = e2.link AND (e3.lang_mask & 3 > 0) AND e3.text_md5 =  MD5( 'layout' ) 
 (...) 
AND e172.parent = e171.link AND (e172.lang_mask & 3 > 0) AND e172.text_md5 =  MD5( 'set' ) 
AND e173.parent = e172.link AND (e173.lang_mask & 3 > 0) AND e173.text_md5 =  MD5( 'print' ) 
AND e174.parent = e173.link AND (e174.lang_mask & 3 > 0) AND e174.text_md5 =  MD5( 'ezinfo' ) 
AND e175.parent = e174.link AND (e175.lang_mask & 3 > 0) AND e175.text_md5 =  MD5( 'about' ) 
LIMIT 0, 1

Please mind, that I cut most of it out... look at the numbers ;) Is that something related to the infamous multilingual URL alias problem?

Thanks for any thoughts,
Piotrek

--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu

Jean-Luc Nguyen

Wednesday 17 March 2010 7:11:35 am

Hello,

I guess you're right, it is related to the "infamous multilingual URL alias issue". I had this error once, but never had this huge SQL query...

http://www.acidre.com

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.