Kunena 6.3.3 released

The Kunena team has announce the arrival of Kunena 6.3.3 [K 6.3.3] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 and issues discovered during the last development stages of K 6.3
Note: Please go to the Kunena Dashboard after an upgrade so that the Kunena database tables are also updated.

Solved Bug on editing posts located

More
8 months 2 weeks ago #1 by Deciman
Hi there

Located a bug in the latest kunena.
Whenever it is tried to edit posts from different users
they are not saved afterwards due to 'invalid email address'

The editing user has all needed rights (talking about super users, too)
but the error comes after trying to save the changed posting.

Postings from other users can be edited by them without problems.

And all up to now checked users where editing has been refused have the same thing common...
eMail ist located '@t-online.de'

I guess something in the validation check for emails is broken
and checked is not the email from the editing user, but the email from the original posting user

Deci

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

More
8 months 2 weeks ago #2 by Leen
Replied by Leen on topic Bug on editing posts located
If it is this bug then it has already been reported
github.com/Kunena/Kunena-Forum/issues/9556

L.v.d.A

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

More
8 months 2 weeks ago #3 by xillibit
Hello,

Did-you had done an update to Kunena 6.2.0 from a previous Kunena version ? From which one ?

I don't provide support by PM, because this can be useful for someone else.

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

More
8 months 2 weeks ago #4 by rich
Replied by rich on topic Bug on editing posts located
If you have database access, please open the table #__kunena_messages and sort this list by "emails". Do you have posts where the value in the email column is empty (see image)?
.
 

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

More
8 months 2 weeks ago #5 by Deciman
Most of them are empty, the rest is NULL

Deci

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

More
8 months 2 weeks ago #6 by Deciman

Hello,

Did-you had done an update to Kunena 6.2.0 from a previous Kunena version ? From which one ?
 
We had several updates.
The oldest database stored (and available) is from Joomla 2.5.5
And there are also lots of empty email fields.

Guess that's the reason...
Set them all to NULL???

Deci

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

More
8 months 2 weeks ago #7 by rich
Replied by rich on topic Bug on editing posts located

Set them all to NULL???

Yes, the NULL must be entered. This command with phpMyAdmin should solve the problem, but important! Create a database backup first!
Replace #__ with your database prefix
Code:
UPDATE #__kunena_messages SET email = NULL;

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

More
8 months 2 weeks ago #8 by Deciman
Did a short check by editing that particular posting id in the database.
After replacing the empty field with NULL it can be edited.

So now backing up and replacing all.

BTW: Only in messages or anywhere else, too?

Thanks

Deci

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

More
8 months 2 weeks ago #9 by rich
Replied by rich on topic Bug on editing posts located
It seems that some columns are not always filled in correctly during a migration. This then leads to errors. I don't think you need to search in other tables as well.
The following user(s) said Thank You: Deciman

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

More
8 months 2 weeks ago #10 by xillibit

Set them all to NULL???

Yes, the NULL must be entered. This command with phpMyAdmin should solve the problem, but important! Create a database backup first!
Replace #__ with your database prefix
Code:
UPDATE #__kunena_messages SET email = NULL;
 
When updating from previous kunena version (before the 6.0.4) this query on update process is already applied, it don't seems to work in some cases

I don't provide support by PM, because this can be useful for someone else.

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

Time to create page: 0.546 seconds