search

dmitryd / typo3-realurl

**Vintage** RealURL extension for TYPO3 CMS. Read the wiki if you have questions!
110 stars 127 forks source link

Problem when "-" is used two or more times in the page name... #621

Closed Fuchur84 closed 6 years ago

Fuchur84 commented 6 years ago

I am really not sure why this is happening, but here is a strange thing going on. The system creates a strange link to a page with a "�" in it. (yes, questionmark character here). But there is no special char or something like that. It is just a "-" (minus) in the name of the page.

And of cause it will have a problem with the special char then. I can access the page, if I change the "par�le" to "par-le" again in the uri. The really strange thing is, that if I am on a higher level, I can access that and "par-le" is created as it should and linked to as it should. Any idea?

Just to mention it: The spaceCharacter of lookUpTable is "-" too. But it really does not make a big difference if I for instance change it to "_" or something.

I get this error-message: array(4 items) caller => 'TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery' (60 chars) ERROR => 'Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci, COERCIBLE) for operation '='' (104 chars) lastBuiltQuery => 'SELECT * FROM tx_realurl_pathdata WHERE rootpage_id=1 AND pagepath='suedbade n/arbeitbeschaeftigung/integrationsunternehmen/par�le-ggmbh/neuigkeitenueb ersicht/neuigkeiten-archiv' AND language_id=0 ORDER BY expire LIMIT 1' (221 chars) debug_backtrace => '{closure}#34 // TYPO3\CMS\Frontend\Http\Application->run#33 // TYPO3\CMS\ Core\Core\Bootstrap->handleRequest#78 // TYPO3\CMS\Frontend\Http\RequestH andler->handleRequest#302 // TYPO3\CMS\Frontend\Controller\TypoScriptFron tendController->checkAlternativeIdMethods#138 // TYPO3\CMS\Core\Utility\G eneralUtility::callUserFunction#1177 // call_user_func_array#4377 // DmitryD ulepov\Realurl\Decoder\UrlDecoder->decodeUrl# // DmitryDulepov\Realurl\De coder\UrlDecoder->runDecoding#157 // DmitryDulepov\Realurl\Decoder\UrlDec oder->doDecoding#1276 // DmitryDulepov\Realurl\Decoder\UrlDecoder->dec odePath#838 // DmitryDulepov\Realurl\Decoder\UrlDecoder->searchPathInCach e#426 // DmitryDulepov\Realurl\Cache\DatabaseCache->getPathFromCacheByPag ePath#1418 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTgetS ingleRow#300 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTqu ery#416 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#314' (940 chars)

The link looks like this in firefox: http://domain.tld/2016/suedbaden/arbeitbeschaeftigung/integrationsunternehmen/par%EF%BF%BDle-ggmbh/neuigkeitenuebersicht/neuigkeiten-archiv/ when copied from the link I created with the RTE. I'd say it is trying to convert the "-" to something and a later action does kill that converting, but I really do not get why this is not happing at the next "-" too.

dmitryd commented 6 years ago

Why don't use ask for help as described in the "Getting help" section of the wiki?

Fuchur84 commented 6 years ago

Thought this would be a bug which would need to go here... Sorry for asking here if it is not. I'll do as suggested now. Thanks for your answer anyway :).