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 Unknown column 'socials' in 'SET'

More
11 months 23 hours ago #233480 by micker
Replied by micker on topic Unknown column 'socials' in 'SET'
hi
6.3.10
2025-03-14

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

More
11 months 2 hours ago #233485 by rich
Replied by rich on topic Unknown column 'socials' in 'SET'
Quote from you:

 | qq | social |

Please go to your K6.3.10 database and check whether these two columns “qq” and “social” actually exist or whether it is a column called qqsocial.
Important! Always create a backup before you make any changes to your website!

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

More
10 months 4 weeks ago - 10 months 4 weeks ago #233489 by Pinkeltje
Replied by Pinkeltje on topic Unknown column 'socials' in 'SET'
For your Joomla 4 site with Kunena 6.3.10 running this query on your database should fix the problems (replace #__ with your own prefix)
Code:
ALTER TABLE `#__kunena_users` DROP `friendfeed`; ALTER TABLE `#__kunena_users` ADD `bsky_app` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL AFTER `reddit`; ALTER TABLE `#__kunena_users` CHANGE `twitter` `x_social` VARCHAR(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `#__kunena_users` DROP `icq`;
As always: make a backup first!
And I think that because of the fact that your other site had a corrupt user table as well before you updated Kunena from 6.3.10 to 6.4.2, is the reason for the error. So if possible return to the backup you've made from your site with Kunena 6.3.10, run the same query and then update to Kunena 6.4.2.
Last edit: 10 months 4 weeks ago by Pinkeltje.

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

More
10 months 3 weeks ago #233499 by micker
Replied by micker on topic Unknown column 'socials' in 'SET'
ok cool
i update my database all is good
i update my other site to 6.4.3 that solved !
thanks for all

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

Time to create page: 0.273 seconds