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 'GROUP BY year,month' at line 5
joomla 6.0
MySQL 8.0
https://ukraine-hilfe-kassel.de/
Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Latest post by b2z on Saturday, 01 November 2025 15:53 EET
Sorry, but I don't know how.
Hello!
To insert image, please use external image hosting like https://postimages.org/ and just paste image URL to your message above.
Kind regards,
Dmitrijs
Or other way - provide credentials to your website admin to check everything. You can update your first post and write your credentials there - under Credentials.
Kind regards,
Dmitrijs
https://ukraine-hilfe-kassel.de/error1064/screenshot.jpg
I also have an assumption that there might be problem with the content. E.g. emoji in title or wrong date of publishing/creation. Could you check it out?
Thank you for a screenshot. Just checked on our test site the same settings as you have, there is no SQL error.
We will need to debug the code on your website, because we cannot reproduce an error. Can you provide credentials?
Kind regards,
Dmitrijs
Everything is fine, and I've tried different settings. For example:
https://ukraine-hilfe-kassel.de/error1064/screenshot2.jpg
error 0
NorrNext\Module\CalendarFilter\Site\Helper\CalendarFilterHelper::getActiveDates(): Argument #3 ($catid) must be of type int, null given, called in /var/www/vhosts/fufh5pb2.web147.alfahosting-server.de/ukraine-hilfe-kassel.de/modules/mod_calendarfilter/src/Helper/CalendarFilterHelper.php on line 153
Credentials removed by moderator
It is hard to understand what is going on. CalendarFilterHelper::getActiveDates() returns active dates for calendar. For some reason it fails on your webiste. Please provide credentials to check everything.
Kind regards,
Dmitrijs
You made your credentials available to public by publishing it in the message. Please do not do it. Just edit the 1st message and remove credentials in the previous message.
I think I know where the problem is - please publish the module inside the Content menu item, like category blog. If you publish it outside the Content it cannot read category id.
Your credentials does not work, cannot login to admin. It is almost a night, we will continue tomorrow.
Hello Joaquin,
We need to understand why category id is not working in your case. Something is wrong, but without access is hard to analyze what is the cause.
Please provide credentials to control panel of your website.
Thank you.
Kind regards,
Dmitrijs
Hello again, the module still isn't working. I've tried different settings. Could you please check again?
Thanks
Hello!
Settings won't help. Something is wrong, but without access is hard to analyze what is the cause. Please provide Administrator Login.
Thank you.
Kind regards,
Dmitrijs
Now I have access and understand where the problem is.
The module can work only inside some category (normally in the blog layout). It cannot work outside of the category, because it simply will not find any articles. In the calendar it displays article dates with the link to the current category. When you click on the date the module redirects you to a category and displays the artilces filtered by this date.
Hope you understand the idea.
Kind regards,
Dmitrijs
I understand the idea, but I don't know what I did wrong.
Category: Tagebuch
Article: Seminare
Article - Category: Tagebuch
Menu: Tagebuch
Menu Item Type: Category Blog
Choose a Category: Tagebuch
Regards
Joaquín
Hi!
Then you need to assign module to Tagebuch menu item only. And now it works. Please check.
The problem is that your homepage is a Single Article view that does not have a category in the URL, so the module is failing without category.
But I think I have an idea how to make the module work without a category in the URL. I will add an additional parameter to the module settings - Default Category. This will be the category to which the module will switch if no category will be found in URL. This will eliminate the error of missing catid and wrong SQL.
Kind regards,
Dmitrijs
Everything worked out now. Thank you so much!
Hi!
Released version 1.1.1 with default category parameter.
Please update and set you category. After that it should be possible to publish the calendar on your home page also.
Should you still experience problems, please open a new support thread.
If you are happy with our support and our extension, we would be grateful if you took the time for a small review or just a vote on Trustpilot. https://www.trustpilot.com/review/norrnext.com
Or leave a review about our extension at the JED https://extensions.joomla.org/extension/calendar-filter
Kind regards,
Dmitrijs