Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.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 7.0

Solved Error when editing user profile

More
1 year 11 months ago - 1 year 11 months ago #231258 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 11 months ago by Pinkeltje.

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

More
1 year 11 months ago #231263 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 11 months ago #231264 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 11 months ago #231268 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 11 months ago - 1 year 11 months ago #231269 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 11 months ago by Pinkeltje.

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

More
1 year 11 months ago - 1 year 11 months ago #231271 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 11 months ago by xillibit.

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

Time to create page: 0.231 seconds