Question From Kunena 6.3.10 straight to Kunena 6.4.3

I am prior to 6.4.3 and can now upload 6.4.3 via the regular Joomla upload function after the DB modifications.

Does it mean I should not change the column twitter in the DB and leave it as it is?

Sould I nevertheless query this as well, even 6.4.3 has been not installed, yet?
INSERT INTO `#__kunena_version` (`id`, `version`, `versiondate`, `installdate`, `build`, `versionname`, `sampleData`, `state`) VALUES (NULL, '6.4.0-BETA1-DEV', '2024-10-12', '2024-10-12', '6.4.0-BETA1-DEV', 'INTERNAL', '1', '');

Thank you.

You should apply the query to #__kunena_version to the update process to start a bit forward, because the others queries are previous steps of update and i want to know if the queries pass or fail into phpmyadmin

Hi all,

finally I was able to update to K6.4.3 together with your support! It seems that Kunena is running flawless.
I want to share quickly what I have done:

1) Starting Point: I had K6.4.3 installed, but still the 6.3.10 database

2) I have applied the follwing changes to my 6.3.10 DB (only those):
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`; --> is the key change
ALTER TABLE `#__kunena_users` CHANGE `bsky_app` `bluesky_app` VARCHAR(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; --> this is a critical one, because you need also the bsky_app column. After I had exchanged the name, I had to reinsert a bsky_app column for saving reasons in the backend of Kunena; therefore I had the column bluesky_app and bsky_app now!

3) I have re-Installed the Kunena 6.3.4 package via Joomla, without deleting the previous 6.3.4 install before

4) I went to the Kunena Dashboard and the green lines of changes have been shown now & 6.4.3 version as well, which was not the case before

Only remaining point:
In my DB #__kunena_users all the social columns are gone now, beside the bsky_app column, which I had to reinstall (see above) --> Question: is it possbible to delete it now with: ALTER TABLE `#__kunena_users` DROP `bsky_app`;?
I believe yes, but I want to have your advice.

Thanks again for all your support and I hope this thread will also help others.

Chris

In my DB #__kunena_users all the social columns are gone now, beside the bsky_app column, which I had to reinstall (see above) --> Question: is it possbible to delete it now with: ALTER TABLE `#__kunena_users` DROP `bsky_app`;?
I believe yes, but I want to have your advice.

Don't understand why you think you had to add this column again. .

He is asking to delete the column bsky_app now, so yes you can delete this colunm directly with phpmyadmin or via the query in your message