×
Kunena 5.1.12.1 Released - Security release (22 Apr 2019)

The Kunena team has announce the arrival of Kunena 5.1.12.1 [K 5.1.12.1] which is now available for download as a native Joomla extension for J! 3.9.x. This version addresses most of the issues that were discovered in K 5.1 and issues discovered during the development stages of K 5.1. This is a security release.

Question Editing the profile

More
6 months 3 days ago #1 by Luchen6
Editing the profile was created by Luchen6
When editing the profile and hit <save> I get the following error message:

DateTime::__construct(): Failed to parse time string (11/30/-0001) at position 5 (/): Unexpected character

This is true for version 5.1.6.1 and 5.1.7

When I empty the field for my birthday saving the profile works.

The default date of birth showing is: 11/30/-0001

Please Log in or Create an account to join the conversation.

More
6 months 2 days ago - 6 months 2 days ago #2 by rich
Replied by rich on topic Editing the profile
This should be already fixed. Maybe some files aren't overwritten or the database is not upgraded. Please check in the database table *_kunena_users the column birthdate. It should be the default value 01-01-1001, if the user have no entered another birthdate.
Last edit: 6 months 2 days ago by rich.

Please Log in or Create an account to join the conversation.

More
6 months 2 days ago #3 by ssh
Replied by ssh on topic Editing the profile
Also,
If you want
You can use the following query to fix the problem with existing accounts causing the problem:
UPDATE `#_kunena_users` SET `birthdate` = '01-01-1001' WHERE `birthdate` = '0000-00-00'

Please Log in or Create an account to join the conversation.

More
6 months 1 day ago #4 by Luchen6
Replied by Luchen6 on topic Editing the profile
If I do a count in the user table I get following results (apart from valid birthdates)

date count
0000-00-00 8459
0001-00-00 1
0001-01-01 3492

Changing the date to '01-01-1001' solves the issue, but I still find this strange. In the profile I get as date of birth 01-01-1001.

As far as I remember the initial date changed recently in Kunena. Can this be the cause?

For now I will use your query to update the date.

Please Log in or Create an account to join the conversation.

More
4 months 1 week ago #5 by Tom01
Replied by Tom01 on topic Editing the profile
Hi,

in my case I have the issue that long-term users have the date of birth: 11/30/-0001
newer ones have 00/00/0000
did try: UPDATE `j17_kunena_users` SET `birthdate` = '01-01-1001' WHERE `birthdate` = '0000-00-00' and also
UPDATE `j17_kunena_users` SET `birthdate` = '01-01-1001' WHERE `birthdate` = 11/30/-0001'
but this didnt work.

Any hints for me? ;-) Ive got the datetime error than I wanted to change some user settings in backend.

Thank you
tom

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.073 seconds