Kunena 6.4.8 Released

The Kunena team has announce the arrival of Kunena 6.4.8 [K 6.4.8] in stable which is now available for download as a native Joomla extension for J! 5.0.x/5.1.x/5.2.x/5.3.x/5.4.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 6.4
Important note: Go to the Kunena Dashboard after an upgrade so that the Kunena database tables are also updated. This is particularly necessary for major version jumps so that the table changes are adapted.

Solved Error when editing user profile

More
1 year 7 months ago - 1 year 7 months ago #1 by Pinkeltje
Error when editing user profile was created by Pinkeltje
When editing user profile and trying to save, this error appears:

Unknown column 'bsky_app' in 'field list'Error on saving profile

I guess there is an error in line 264 of kunena.install.upgrade.xml
Code:
 ALTER TABLE `#__kunena_users` ADD `bsky_app` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL AFTER `reddit`
I think it should be
Code:
 ALTER TABLE `#__kunena_users` ADD `bsky_app` VARCHAR(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `reddit`;
Last edit: 1 year 7 months ago by Pinkeltje.

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

More
1 year 7 months ago #2 by Gindi
Replied by Gindi on topic Error when editing user profile
Are you editing your own profile or a user profile?
I have edited my own profile and saved it without an error message.
The entries for 'bsky_app' are OK in the database.

 

Gindi
The following user(s) said Thank You: mrivner

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

More
1 year 7 months ago #3 by Pinkeltje
Replied by Pinkeltje on topic Error when editing user profile
It was my own profile. Added the record manually to the database and now it's ok.

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

More
1 year 7 months ago #4 by xillibit
Replied by xillibit on topic Error when editing user profile
The query had been tested on phpmyadmin before but sometimes there are diffrences between Mysql and MariaDB
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
1 year 7 months ago - 1 year 7 months ago #5 by Pinkeltje
Replied by Pinkeltje on topic Error when editing user profile
I have MariaDB. Query didn't work either, so added the field manually. This was on my testsite. Then I ran the recorded query in phpmyadmin on my live site.
And yes, i used my own table prefix when running the query.
Last edit: 1 year 7 months ago by Pinkeltje.

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

More
1 year 7 months ago - 1 year 7 months ago #6 by xillibit
Replied by xillibit on topic Error when editing user profile
I have tested the query on Phpmyadmin on MariaDB 11.3.2 :
Code:
ALTER TABLE `nxah1_kunena_users` ADD `bsky_app` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL AFTER `reddit`;
, i haven't encountered issues

After the updrade to Kunena 6.3.0, did-you have opened the Kunena dashboard ?
I don't provide support by PM, because this can be useful for someone else.
Last edit: 1 year 7 months ago by xillibit.

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

More
1 year 7 months ago #7 by Pinkeltje
Replied by Pinkeltje on topic Error when editing user profile
I didn't open the dashboard,  allways forget as it doesn't make sense to me. But if I'm the only one consider it solved.

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

More
1 year 7 months ago #8 by Gindi
Replied by Gindi on topic Error when editing user profile
It makes sense to open the kunena dashboard after an update, because this will update the manifest version of the Kunena Forum in the database.

gindi
 

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

More
1 year 6 months ago #9 by cybersalt
Replied by cybersalt on topic Error when editing user profile
Thanks for posting this - it worked for me. I made this video to help others finding this deploy the fix.

Tim Davis
Basic Joomla Tutorials YouTube Channel:
Cybersalt Consulting:

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

More
1 year 6 months ago #10 by mrivner
Replied by mrivner on topic Error when editing user profile
I had the same issue with MariaDB. This fix worked for me. Thank you for posting it.
Michael

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

Time to create page: 0.279 seconds