Kunena 7.0.11 & Kunena 6.4.16 – Security Updates Released and K7.1 in RC1 2

The Kunena team has announce the arrival of three simultaneous security release : K6.4.16, K7.0.11 and K7.1 RC2. Just a reminder K6.4.16 receives only securities fixes untill end of 2026, so it's advised for users to upgrade to K7.0.11. K7.0.11 is the last release of the K7.0 because it's replaced by K7.1 branch with the stable release in the corner. The translations for K7.1 on crowdin.com/project/kunena-forum-7-1 needs to be checked or improved becasue it has been generated by TM (Translation Machine).

Solved Unknown column 'x_social' in 'field list' while save use profile

More
1 year 11 months ago #232537 by martinsai
Unknown column 'x_social' in 'field list' while save use profile was created by martinsai
Hi Team, I have Joomla 4.4.9 and Kunena 6.3.6. but still the issue "Unknown column 'x_social' in 'field list' while save use profile" is happening...? 
What to do?
thnx, martinsai

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

More
1 year 11 months ago #232538 by Pinkeltje
Replied by Pinkeltje on topic Unknown column 'x_social' in 'field list' while save use profile
Do you open Kunena Dashboard after installing update? This change was already made in (i think) K 6.3.3.
You could try repairing the table with this query (replace #__ with your own prefix).
Code:
ALTER TABLE `#__kunena_users` CHANGE `twitter` `x_social` VARCHAR(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

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

More
1 year 11 months ago #232541 by martinsai
Replied by martinsai on topic Unknown column 'x_social' in 'field list' while save use profile
Dear Pinkeltje,
thnx but what do u mean by I "opened Kunena Dashboard after installing update" There were so many updates over the years and sometimes maybe I opened the dashboard afterwords...
Code: I know how to open the table, but u mean I should embedd the above where? see also attachment
Should I go to the "SQL" tab and emed the code there? ok did that and pressed ok, now the table seems to be changed but still I cannot save the user. Under tab "user information" I see only "X" and no twitter anymore but still error message comes...aaaaah now error message is "Unknown column 'bsky_app' in 'field list' " ?????

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

More
1 year 11 months ago #232542 by 9themestore
Replied by 9themestore on topic Unknown column 'x_social' in 'field list' while save use profile
Hi @martinsai,
Go to the #__kunena_users table and check the bsky_app column is present. If not, use bellow SQL command to add the bsky_app field to the #__kunena_users table. (instead of #__ add your prefix.)
Code:
ALTER TABLE *__kunena_users ADD bsky_app VARCHAR(75) NULL AFTER reddit;
- Please provide your site url if it has been lived.
- Please share tip if it worked fine with you.
- Don't be shy about using the "Thanks" button below if you found my comment helpful :)
The following user(s) said Thank You: martinsai

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

More
1 year 11 months ago #232544 by martinsai
Replied by martinsai on topic Unknown column 'x_social' in 'field list' while save use profile
seems it worked! Don't understand why I had to fix this manually...cant show u live for it a registered area on the website, sorry

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

Time to create page: 0.144 seconds