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

Server Error when a user has no limitation in news category roots #157

Closed
Webstylerin opened this issue Mar 22, 2019 · 4 comments
Closed
Assignees
Labels

Comments

@Webstylerin
Copy link
Sponsor

Contao: 4.4.35
codefog/contao-news_categories: 3.1.0

I have a user group that I will grant access to all news categories. These users are allowed to edit, create and delete categories.

In the user group settings the "news category roots" is empty. The tool tip says: "Here you can limit the news category roots the user has access to. Note that the subcategories will included automatically!" I did not set a limit because I don't want a limit.

But when the user tries to open the categories or wants to set a category for a news item a internal server error shows up:

An exception occurred while executing 'SELECT DISTINCT hideInList FROM tl_news_category WHERE id IN()': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

When I set a limit to every category, no error appears. But I want unlimited access. :)

Is this a bug or are my settings/is my understanding wrong?

User groups › Edit group ID 1 - Contao Open Source CMS 2019-03-22 10-27-13

@bibib
Copy link

bibib commented Mar 25, 2019

Same problem here -
Contao: 4.4.35
codefog/contao-news_categories: 3.1.0

In Contao 3.5.34 no news categories permissions are set at all, but the user can choose one or more categories without a problem. After the update to Contao 4.4 I get the same error when trying to choose a category.
In the admin account, no error shows up.

@mdriverch
Copy link

Same problem here -
Contao: 4.7.1
codefog/contao-news_categories: 3.1.0

@qzminski qzminski added the bug label May 20, 2019
@qzminski qzminski self-assigned this May 20, 2019
@qzminski
Copy link
Member

Sorry for the late reply, it is now fixed in 3.1.1.

@mdriverch
Copy link

great, thank you

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Development

No branches or pull requests

4 participants