Skip to main content

#202 Error 1064

Posted in ‘Calendar Filter’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information (available for public)

PHP version
8.3

Latest post by b2z on Saturday, 01 November 2025 15:53 EET

cacoadmin
After activation the error occurred
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/

sulpher
Hi Joaquin,
Please provide screenshot of your current module settings. Thank you.

cacoadmin

Sorry, but I don't know how.

b2z

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

b2z

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

cacoadmin

https://ukraine-hilfe-kassel.de/error1064/screenshot.jpg

sulpher

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?

b2z

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

cacoadmin

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

 
 
 

 

 
 
 

cacoadmin

Credentials removed by moderator

b2z

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

sulpher

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.

sulpher

izobrazenie

Whej you edit the 1st message - there are hidden fields for the credentials. The're available for moderators only. Please fill out themand remove the credentials from the message itself.

b2z

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.

System Task
system
The ticket information has been edited by Joaquin Olea Catalán (cacoadmin).

b2z

Your credentials does not work, cannot login to admin. It is almost a night, we will continue tomorrow.

b2z

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

cacoadmin

Hello again, the module still isn't working. I've tried different settings. Could you please check again?

Thanks

b2z

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

System Task
system
The ticket information has been edited by Joaquin Olea Catalán (cacoadmin).

b2z

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

cacoadmin

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

b2z

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

cacoadmin

Everything worked out now. Thank you so much!

b2z

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

Support information

Support hours: You can get our help: Monday - Friday / 09:00 to 17:00 (GMT+3), but not limited. Our staff is pleased to provide Premium support to every paid subscriber asap, but sometimes you should be ready to wait for our reply for up to 3 days.


Our time: / Your time:

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. We also ask you to remove temporary credentials at your site after the problem is resolved. Thank you.

Support of free extensions is not provided on this forum. Please submit your questions or report issues via Github tracker. See link on the product page.