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

Explode limitation set to 2 might be applied #1555

Closed
Jobu opened this issue Jun 11, 2018 · 3 comments
Closed

Explode limitation set to 2 might be applied #1555

Jobu opened this issue Jun 11, 2018 · 3 comments
Assignees
Labels
Milestone

Comments

@Jobu
Copy link

Jobu commented Jun 11, 2018

list($t, $f) = explode('.', $GLOBALS['TL_DCA'][$this->strTable]['fields'][$fld]['foreignKey']);

I think in this line is missing the explode limitation option set to 2!?!

@leofeyer
Copy link
Member

Why do you think that?

@Jobu
Copy link
Author

Jobu commented Jun 11, 2018

In my case I have a subquery in the concat, so multiple occurences of the dot. This lead to errors when performing search operations.

'foreignKey' => 'tl_beachcup_team.CONCAT((SELECT CONCAT(tl_beachcup_player.name, " ", tl_beachcup_player.surname, " (", tl_beachcup_player.tax_number, ")") FROM tl_beachcup_player WHERE tl_beachcup_player.id = tl_beachcup_team.player_1), " und ", (SELECT CONCAT(tl_beachcup_player.name, " ", tl_beachcup_player.surname, " (", tl_beachcup_player.tax_number, ")") FROM tl_beachcup_player WHERE tl_beachcup_player.id = tl_beachcup_team.player_2))'

@leofeyer leofeyer added the bug label Jun 11, 2018
@leofeyer leofeyer added this to the 4.4.19 milestone Jun 11, 2018
@leofeyer leofeyer self-assigned this Jun 14, 2018
@leofeyer
Copy link
Member

Fixed in f52fc13. Thank you @Jobu.

@leofeyer leofeyer modified the milestones: 4.4.19, 4.4 May 14, 2019
leofeyer added a commit that referenced this issue Mar 26, 2020
Description
-----------

| Q                | A
| -----------------| ---
| Fixed issues     | Fixes #784
| Docs PR or issue | -

Commits
-------

37083b72 Allow to compare against any template if a prefix is unknown
0f7f004f Run the CS fixer
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants