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

SQL error when searching in for tags in CP #23

Open
joostwaaijer opened this issue Mar 21, 2022 · 0 comments
Open

SQL error when searching in for tags in CP #23

joostwaaijer opened this issue Mar 21, 2022 · 0 comments

Comments

@joostwaaijer
Copy link

We are experiencing difficulties with searching in the Tags table on the Control Panel, when the 'enableUsage' setting is enabled.

First of all, this line throws an error when trying to search: TagQuery.php#L41
Which can be fixed by replacing strtoupper($this->query->select[0]) to strtoupper(array_values($this->query)->select[0])

But after fixing that, we get an SQL error, that the subquery has more selects than it should have. This mainly comes down to the fact that when searching, the parent query is selecting from de searchindexes table and not the elements table, which is now the subquery.

In the meantime we have disabled the usage setting, so we can search in the table.

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

1 participant