[TYPO3-english] Typo3 4.5.4 update kills CoolUri

[Felix Heller]

Hello everybody,


it seems to me that the whole <uriparts> section is ignored. I don't think  
that the problem is limited to parameters that execute a SQL query because  
even this part doesn't work any more:

<part>
	<parameter>tx_ttnews[pointer]</parameter>
</part>

I will investigate this issue and inform you if I find something useful.


Greetings
Felix Heller
_____________________

TYPO3-Agentur München
TYPO3 agency Munich
http://www.aimcom.de


> Hi J. Schaller, Hi list,
>
> I can confirm the problem mit TYPO3 4.5.4, Cooluri and tt_news.
>
> In 4.5.4 I get the URL
>
>
> http://www.my-domain.de/home/news.html?tx_ttnews[tt_news]=74
>
> In 4.5.3 I have the correct URL
>
> http://www.my-domain.de/home/news/my-site.html
>
>
>
> In my CoolUri config I use these simple lines:
>
> <uriparts>
> <part>
> <parameter>tx_ttnews[tt_news]</parameter>
> <lookindb>
> <to>SELECT title FROM tt_news WHERE (uid=$1 or l18n_parent=$1) AND
> sys_language_uid={L=0}</to>
> <translatetoif>
> <match>^[0-9]+$</match>
> </translatetoif>
> <t3conv>1</t3conv>
> </lookindb>
> </part>
> </uriparts>
>
>
> <predefinedparts>
> <part>
> <parameter>tx_ttnews[backPid]</parameter>
> </part>
> <part>
> <parameter>cHash</parameter>
> </part>
> </predefinedparts>
>
>
>
> Regards Joe
>
>
> ---------------------------------------
>
> Hello list,
>
> I've just a had a not so nice couple of hours troubleshooting why
> suddenly my speaking URLs were gone. It looks like the latest Typo3
> update somehow filters SQL in my CoolUri config file. With 4.5.3
> everything works fine, I've switched versions at least 5 times,
> cleared caches, the whole works, to be sure.
>
> (One of) The offending part in my CoolUri config seems to be this one:
>
>   <uriparts>
>     <part>
>       <parameter>tx_ttnews[tt_news]</parameter>
>       <lookindb>
> 	<to>SELECT concat( CAST( DATE_FORMAT( FROM_UNIXTIME( datetime
> ) , GET_FORMAT( DATE, 'ISO' ) ) AS char( 10 ) ) , '_', title ) FROM
> tt_news WHERE uid =$1</to>
>         <translatetoif>
>         	<match>^[0-9]+$</match>
>         </translatetoif>
>         <sanitize>1</sanitize>
>       </lookindb>
>     </part>
>
> In 4.5.3 I get a correct URL like
> http://www.mypage.com/2011-03-15_newstitle/
>
> whereas in 4.5.4 I get
> http://www.mypage.com/?tx_ttnews[tt_news]=999
>
> meaning, the SQL statement and consequently URL conversion is
> completely ignored. Any ideas?
>
> Cheers,
> J. Schaller
>