Posted by Z4N8r on Mon, Nov 27, 2023 - 8:50pm

Hello community
just arrived here looking for help...

I'm trying to build a birthday calendar, using a view that should render the (birth)date field which is part of a node type "person". For the date field im using the "Repeating Dates"-module (repeating_dates).

When saving a person an error occurs:
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'field_person_birth_dtstart' at row 17

Nevertheless, the date is saved and shows up properly in the node. I can pick the field for the view, apply the "Full Calendar NG" formatter... but the dates aren't rendernd on the view page.

Any idea what I'm missing or doing wrong?

Thank you and best regards

Accepted answer

Hi again ;-),

and it is only displayed once

Can you check the "Multiple field settings" in your view for that field?

Is it set to "Display all values in the same row" (a checkbox in a collapsed fieldset)

If that's not what you want, uncheck that setting and save the views field and view. Then the values should show up individually.

And also make sure, there's no filter criterion set for the repeating dates field to limit the time span.

Comments

Mon, Nov 27, 2023 - 9:20pm by argiepiano

Hello, Z4N8r, and welcome to the Forum! 

I'm not familiar with the Repeating Dates module, but its maintainer is very active in the community. I suggest you either post an issue in the module's issue queue, or perhaps in the Zulip chat. Good luck!

indigoxela's picture

Tue, Nov 28, 2023 - 1:17am by indigoxela

Hi Z4N8r and welcome,

what you describe seems like a bug in the module's database schema.

Are the dates of such a birthday before 1902?

I don't think, such a date could get saved properly, though. Especially, as an Exception is thrown. Are you sure the date is saved?

Just some basic infos: which type and version is your database (MariaDB / MySQL), and what's your PHP version? You can get both info's from your site's status page on /admin/reports/status.

Oh, and also important: your system's architecture. Is it 32bit or 64bit?

Tue, Nov 28, 2023 - 8:19am by Z4N8r

Hello
and many thanks for your fast reaction!

My system:
– PHP 8.1.6 and MariaDB 10.3.38 on Ubuntu0.20.04.1 64bit
– a fresh Backdrop installation, latest version
– the "Repeated Dates"-module installed from the site backend
– A repeated-date field added without problem to the standard node-type "Page"
– Entered values: start 30.11.2023, end 31.12.2023, yearly repeats

I did some testing:
– The errors ONLY occur when choosing "monthly" or "weekly" repetition:
– yearly:  SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'field_dater_dtstart' at row 16
– monthly: 'field_dater_dtstart' at row 171
– in both cases, the entered values are NOT saved (didn't realize this at first).

Please let me know if I can provide more information.

Best regards

 

indigoxela's picture

Tue, Nov 28, 2023 - 9:10am by indigoxela

Hi Z4N8r,

no more infos necessary, I have everything, I need. :-)

If you start 2023, and add as many repetitions, as currently possible, you end up in year 2389 when repeating yearly.

With monthly it's year 2054.

There's now an issue open in the module's issue queue: https://github.com/backdrop-contrib/repeating_dates/issues/41

A pull request, that fixes it is also available, not sure if you're familiar with git.

I'll try to release the fixed version soon.

Tue, Nov 28, 2023 - 12:58pm by Z4N8r

Fantastic answer, indigoxela!

Just tried it with less repetitions, to stay below 2038, and it works perfectly – not only in the node but in the view, too. Great, thank you so much!

And even better if this limitation will be lifted in a future module version.

Best regards

 

 

Tue, Nov 28, 2023 - 1:37pm by Z4N8r

...sorry, I'm back again.

There is another "difficulty". I just noticed that displaying a yearly recurring event with a view only works for future dates (e.g. 05.05.2024 is displayed, 05.05.2023 is not) and it is only displayed once (in this example: 2024 yes, but not 2025 ff). On the node, the upcoming years are displayed properly (until 2038 ;-)

Maybe this is just a wrong view configuration? I haven't been able solve this so far... if you have another hint... happy to read it

Again thank you and best regards

indigoxela's picture

Tue, Nov 28, 2023 - 9:56pm by indigoxela

Hi again ;-),

and it is only displayed once

Can you check the "Multiple field settings" in your view for that field?

Is it set to "Display all values in the same row" (a checkbox in a collapsed fieldset)

If that's not what you want, uncheck that setting and save the views field and view. Then the values should show up individually.

And also make sure, there's no filter criterion set for the repeating dates field to limit the time span.

Wed, Nov 29, 2023 - 6:16am by Z4N8r

Awesome, I've unchecked the multifiled settings and now everthings works like a charm! Great work, again thank you very much!