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).

Question From Kunena 6.3.10 straight to Kunena 6.4.3

More
1 year 3 months ago #233640 by Pinkeltje
Hard to say. The change from twitter to x_social already was in version 6.3.3, so it depends on the structure of your actual table. If you can post a screenshot, It will be easier to provide you with the right query.

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

More
1 year 3 months ago #233641 by xillibit
The query to apply in your case on your Kunena 6.4.3 :
Code:
ALTER TABLE `#__kunena_users` ADD `socials` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL AFTER `ip`;

Can you put here the content of table #__kunena_verion ?

It seems in your case that the update process has stopped just before the 6.4.0-BETA1-DEV step, to confirm that can-you check in your table #__kunena_users if you have still the column delicious ?

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 3 months ago #233642 by chris87
Thanks for you great support:
The 6.4.3 DB showed the following in #_kunena_version:
 

should I query:

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`;
ALTER TABLE `#__kunena_users` ADD `socials` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL AFTER `ip`;

or only:
ALTER TABLE `#__kunena_users` ADD `socials` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL AFTER `ip`;

in my 6.3.10 DB?

Chris
 

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

More
1 year 3 months ago - 1 year 3 months ago #233643 by xillibit
You can try first to remove the line 45 in the table #_kunena_version, then open the kunena dashboard and check if you update steps showed. Make a screenshot of this page to see which steps has been done and it in your reply

I don't provide support by PM, because this can be useful for someone else.
Last edit: 1 year 3 months ago by xillibit.

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

More
1 year 3 months ago #233644 by chris87
Hi,
should have know earlier that I can potentially modify also the 6.4.3 DB with your query from above.
I have already set everything back to 6.3.10 (Joomla 5.3.1) status - my last version is line 43 now.
Can you please tell me what I should query now in the 6.3.10 DB in order to modify the DB prior to the 6.4.3 update?

Thank you.

Chris

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

More
1 year 3 months ago #233645 by Pinkeltje

can-you check in your table #__kunena_users if you have still the column delicious ?

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

Time to create page: 0.136 seconds