Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Incorrect alias when lookUpTable=>alias_field is longer than 256 characters #533

Open
MikeVanDeeAvrotros opened this issue Sep 20, 2017 · 2 comments

Comments

@MikeVanDeeAvrotros
Copy link

Url is incorrect when the lookUpTable=>alias_field value is longer than 256(Max mysql alias length) characters.
See UrlEncoder.php line 418.
$aliasValue = $this->tsfe->csConvObj->substr('utf-8', $row[$configuration['alias_field']], 0, $maxAliasLengthLength);
The first index in $row is only 256 characters long. So $aliasValue is empty string.

https://dev.mysql.com/doc/refman/5.7/en/identifiers.html

@dmitryd
Copy link
Owner

dmitryd commented Oct 5, 2017

Yes, that's right. 256 characters limit. Make your aliases smaller :)

@MikeVanDeeAvrotros
Copy link
Author

I can't make my alias shorter.
Is it possible to add AS alias_value in the query? So I can make my lookUpTable=>alias_field value longer than 256.

Mikevandee pushed a commit to Mikevandee/typo3-realurl that referenced this issue Jan 10, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants