Question Unable to update to Kunena 6.4.9

Gindi wrote:

You have misunderstood something.

 

Thank you.
There are indeed many things I may not understand.
For example, in your last post, I do not understand which Russian and English versions you are referring to.
I will attempt to briefly describe my perspective.
I posted a file from my Russian website here in jpa format and  configuration reports.  
The  jpa file contains a database with information about 
a) posts, pictures, etc. of forum participants. This information is always in one language.  So what “the same prefixes” are we talking about?
b) information about the structure of the current version of the Kunen forum. I changed the Russian language of the Joomla backend and, accordingly, Kunen to English for the convenience of moderators. But isn't there more than one current language stored in the database at any given moment? I really don't understand the phrase “more recent version in English and an older version in Russian.”  Or is some rudimentary information about languages stored (it's not clear why)? 
But if I understand correctly, you are analyzing configuration reports. Obviously, they reflect the state of the database. If the scripts for compiling configuration reports are working correctly (and they must be), then somewhere in the tables there is incorrect (outdated) information. Is it possible to find and fix it?  

To move from “theory” to practice, I will post a configuration report from my working German website below. It has the same problem with updating to K6.4.9. It has been running in German for 20 years and the language on it (neither in the admin nor in the frontend) has never changed. 
I hope there will be no confusion with languages here and you will be able to understand the problems with the Kunen update without being distracted by languages. If it helps, I will provide the German jpa file in Google Docs.
Thanks again for your help.

Database collation check: The collation of your table fields are correct
        

Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |
        

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 120 seconds | Max execution memory: 256M | Max file upload:  

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path	In trash
1305	Forum	kunenamenu	view=home&defaultmenu=1307	forum	No
1306	Index	kunenamenu	view=category&layout=list	forum/index	No
1307	Aktuell	kunenamenu	view=topics&mode=replies	forum/aktuell	No
1308	Ungelesen	kunenamenu	view=topics&layout=unread	forum/ungelesen	No
1309	Neues Thema	kunenamenu	view=topic&layout=create	forum/neuesthema	No
1310	Ohne Antwort	kunenamenu	view=topics&mode=noreplies	forum/ohneantwort	No
1311	Meine Themen	kunenamenu	view=topics&layout=user&mode=default	forum/meinethemen	No
1312	Meine Aktivität	kunenamenu	view=user	forum/profil	No
1837	Mein Profil	kunenamenu	view=user	forum/mein-profil	Yes
1773	Profil und Unterschrift	kunenamenu	view=user&layout=edit	forum/ihr-profil-und-ihre-unterschrift-ihr-aktivitaet	No
1313	Hilfe	kunenamenu	view=misc	forum/hilfe	No
1314	Suche	kunenamenu	view=search	forum/suche	No
2485	Moderated	kunenamenu	view=topics&mode=deleted	forum/moderated	No

Joomla default template details : GiCh_site_template | author: lr | version: 1.0.2 | creationdate: 2025-04-20

Kunena default template details : Aurelia | author: Kunena Team | version: 6.3.10 | creationdate: 2025-03-14

Kunena template params:

Warning: Spoiler!

DefaultCategoryicon
profileIconset	default
DefaultIconset	default
editorIconset	default
bootstrap	1
borderless	1
tooltips	1
SubjectLengthMessage	80
fullactions	1
quick	0
displayMenu	1
displayDropdownMenu	1
displayDropdownContent	1
displayModule	1
displayBreadcrumb	1
displayAnnouncement	1
displayFooter	1
avatarPosition	left
formRecover	0
labels	0
whoisonlineName	default
avatarType	rounded
topicicontype	svg
fontawesome	0
socialshare	0
socialsharetag
socialtheme	classic
optional_username	0
writeaccess	0
localstorage	0
moduleIdWebauthn	0
IconColor	inherit
IconColorNew	#48a348
editorType	ckeditor
Bold	1
Italic	1
Underline	1
Strike	1
Subscript	1
Smiley	1
Superscript	1
RemoveFormat	1
BulletedList	1
NumberedList	1
Blockquote	1
JustifyLeft	1
JustifyCenter	1
JustifyRight	1
JustifyBlock	1
Link_Unlink	1
Image	1
Confidential	1
Hidetext	1
Spoiler	1
Code	1
Ebay	1
X_Social	1
Instagram	1
Soundcloud	1
FontSize	1
TextColor	1
Maximize	1
Map	1
Video	1
editorButtons
nameskinckeditor
ckeditorcustomprefixconfigfile
avatarSizeX	40
avatarSizeY	90
avatarSizeXThumb	36
avatarSizeYThumb	36
avatarSizeXWelcome	72
avatarSizeYWelcome	72
avatarSizeXList	36
avatarSizeYList	36
avatarSizeXPost	144
avatarSizeYPost	144
avatarSizeXProfile	200
avatarSizeYProfile	200
templatebyText
templatebyName
templatebyLink

Kunena version detailed: Kunena 6.3.10 | 2025-03-14 [ Git Repository ]
        | Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
boardOffline	0
enableRss	1
threadsPerPage	20
messagesPerPage	10
messagesPerPageSearch	15
showHistory	1
historyLimit	6
showNew	1
disableEmoticons	0
template	aurelia
showAnnouncement	1
avatarOnCategory	0
showChildCatIcon	1
rteWidth	450
rteHeight	300
enableForumJump	1
reportMsg	1
username	1
askEmail	0
showEmail	0
showUserStats	1
showKarma	1
userEdit	1
userEditTime	0
userEditTimeGrace	600
editMarkup	0
allowSubscriptions	1
subscriptionsChecked	1
allowFavorites	1
maxSig	300
regOnly	0
pubWrite	0
floodProtection	0
mailModerators	0
mailAdministrators	0
captcha	1
mailFull	1
allowAvatarUpload	1
allowAvatarGallery	1
avatarQuality	75
avatarSize	2048
imageHeight	800
imageWidth	800
imageSize	1000
fileTypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
fileSize	120
showRanking	1
rankImages	1
userlistRows	30
userlistOnline	1
userlistAvatar	1
userlistPosts	1
userlistKarma	1
userlistEmail	0
userlistJoinDate	1
userlistLastVisitDate	1
userlistUserHits	1
latestCategory	0
showStats	1
showWhoIsOnline	1
showGenStats	1
showPopUserStats	1
popUserCount	5
showPopSubjectStats	1
popSubjectCount	5
showSpoilerTag	1
showVideoTag	1
showEbayTag	1
trimLongUrls	1
trimLongUrlsFront	40
trimLongUrlsBack	20
autoEmbedYoutube	1
autoEmbedEbay	1
ebayLanguageCode	en-us
sessionTimeOut	1800
highlightCode	0
rssType	topic
rssTimeLimit	1 month
rssLimit	100
rssIncludedCategories
rssExcludedCategories
rssSpecification	rss2.0
rssAllowHtml	1
rssAuthorFormat	name
rssAuthorInTitle	1
rssWordCount	0
rssOldTitles	1
rssCache	900
defaultPage	recent
defaultSort	asc
sef	1
showImgForGuest	1
showFileForGuest	1
pollNbOptions	4
pollAllowVoteOne	1
pollEnabled	1
popPollsCount	5
showPopPollStats	1
pollTimeBtVotes	00:15:00
pollNbVotesByUser	100
pollResultsUserslist	1
allowUserEditPoll	0
maxPersonalText	50
orderingSystem	mesid
postDateFormat	datetime
postDateFormatHover	datetime
hideIp	1
imageTypes	jpg,jpeg,gif,png,webp
checkMimeTypes	1
imageMimeTypes	image/jpeg,image/jpg,image/gif,image/png,image/webp
imageQuality	50
thumbHeight	32
thumbWidth	32
hideUserProfileInfo	put_empty
boxGhostMessage	0
userDeleteMessage	0
latestCategoryIn	1
topicIcons	1
debug	0
catsAutoSubscribed	0
showBannedReason	0
showThankYou	1
showPopThankYouStats	1
popThanksCount	5
modSeeDeleted	0
bbcodeImgSecure	text
listCatShowModerators	1
lightbox	1
showListTime	-1
showSessionType	2
showSessionStartTime	1800
userlistAllowed	1
userlistCountUsers	1
enableThreadedLayouts	0
categorySubscriptions	post
topicSubscriptions	every
pubProfile	1
thankYouMax	10
emailRecipientCount	0
emailRecipientPrivacy	bcc
captchaPostLimit	0
imageUpload	registered
fileUpload	registered
topicLayout	flat
timeToCreatePage	1
showImgFilesManageProfile	1
holdNewUsersPosts	0
holdGuestPosts	0
attachmentLimit	8
pickupCategory	0
articleDisplay	intro
sendEmails	1
fallbackEnglish	1
cache	1
cacheTime	60
ipTracking	1
rssFeedBurnerUrl
autoLink	1
accessComponent	1
statsLinkAllowed	1
superAdminUserlist	0
attachmentProtection	0
categoryIcons	1
avatarCrop	0
userReport	1
searchTime	all
teaser	0
ebayLanguage	0
ebayCertId
allowChangeSubject	0
maxLinks	6
readOnly	0
ratingEnabled	0
urlSubjectTopic	0
logModeration	0
attachStart	0
attachEnd	14
attachmentUtf8	1
autoEmbedSoundcloud	1
emailHeader	media/kunena/email/hero-wide.png
userStatus	1
signature	1
personal	1
social	1
plainEmail	0
moderatorPermDelete	0
avatarTypes	gif,jpeg,jpg,png
smartLinking	0
defaultAvatar	nophoto.png
defaultAvatarSmall	s_nophoto.png
quickReply	0
avatarEdit	0
activeMenuItem
mainMenuId
homeId
indexId
moderatorsId
topicListId
miscId
profileId
searchId
custom_id
avatarType	1
sefRedirect	1
allowEditPoll	1
useSystemEmails	0
autoEmbedInstagram	1
disableRe	0
email_sender_name
display_filename_attachment	0
new_users_prevent_post_url_images	0
minimal_user_posts_add_url_image	10
utmSource	0
emailHeaderSizeY	560
emailHeaderSizeX	560
moderator_id
profiler	0
pickup_category	1
privateMessage	1
datePickerFormat	mm/dd/yyyy
sendMailUserBanned	0
mailBodyUserBanned
twitterConsumerKey
twitterConsumerSecret
board_title	GA-Foren
board_offline	0
offline_message	Forum ist provisorisch geschlossen. Kommen Sie bitte später!
enablerss	1
threads_per_page	30
messages_per_page	30
messages_per_page_search	15
showhistory	1
historylimit	10
shownew	1
disemoticons	1
showannouncement	0
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
askemail	0
showemail	0
showuserstats	0
showkarma	0
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	120
maxsig	200
regonly	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
mailfull	0
allowavatarupload	1
allowavatargallery	0
avatarquality	65
avatarsize	2048
imageheight	800
imagewidth	800
imagesize	1000
filetypes	zip,txt,doc,gz,tgz,pdf
filesize	7000
showranking	0
rankimages	0
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_posts	1
userlist_karma	0
userlist_email	0
userlist_joindate	0
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	0
showpopuserstats	0
popusercount	50
showpopsubjectstats	1
popsubjectcount	5
showspoilertag	0
showvideotag	1
showebaytag	0
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
sessiontimeout	9000
highlightcode	0
rss_type	topic
rss_timelimit	month
rss_limit	100
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	1
rss_word_count	0
rss_old_titles	1
rss_cache	900
defaultpage	recent
default_sort	asc
showimgforguest	1
showfileforguest	1
pollnboptions	4
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	1
pollresultsuserslist	0
allow_user_edit_poll	0
maxpersotext	100
ordering_system	replyid
post_dateformat	datetime
post_dateformat_hover	datetime
hide_ip	1
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
boxghostmessage	1
userdeletetmessage	0
latestcategory_in	1
topicicons	1
catsautosubscribed	0
showbannedreason	0
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
show_list_time	8760
show_session_type	1
show_session_starttime	20
userlist_allowed	1
userlist_count_users	2
enable_threaded_layouts	1
category_subscriptions	post
topic_subscriptions	every
pubprofile	1
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
email_visible_address
captcha_post_limit	0
image_upload	registered
file_upload	admin
topic_layout	flat
time_to_create_page	0
show_imgfiles_manage_profile	0
hold_newusers_posts	0
hold_guest_posts	0
attachment_limit	8
article_display	link
send_emails	1
fallback_english	1
cache_time	300
ebay_affiliate_id
iptracking	0
rss_feedburner_url
autolink	1
access_component	1
statslink_allowed	1
superadmin_userlist	0
legacy_urls	1
attachment_protection	0
categoryicons	1
avatarresizemethod	1
avatarcrop	0
user_report	1
searchtime	all
ebay_language	77
ebay_api_key
ebay_cert_id
twitter_consumer_key
twitter_consumer_secret
allow_change_subject	1
max_links	50
read_only	0
ratingenabled	0
url_subject_topic	0
log_moderation	0
attach_start	0
attach_end	14
google_map_api_key
attachment_utf8	1
autoembedsoundcloud	0
emailheader	media/kunena/email/hero-wide.png
user_status	1
plain_email	0
moderator_permdelete	0
avatartypes	gif, jpeg, jpg, png
smartlinking	0
defaultavatar	nophoto.png
defaultavatarsmall	s_nophoto.png
stopforumspam_key
quickreply	1
avataredit	0
activemenuitem
mainmenu_id
home_id
index_id
moderators_id
topiclist_id
misc_id
profile_id
search_id
avatar_type	1
sef_redirect	1
allow_edit_poll	1
use_system_emails	0
autoembedinstagram	0
disable_re	0
recaptcha_publickey
recaptcha_privatekey
recaptcha_theme	white
keywords	0
userkeywords	0
userlist_name	0
usernamechange	0
version_check	0
userlist_usertype	0
sefutf8	0
default_view	flat
enablepdf	1
newchar	Neu!
jmambot	0
templateimagepath	default_ex
joomlastyle	0
numchildcolumn	2
annmodid	62
enablerulespage	0
poststats	0
statscolor	9
wrap	250
changename	0
imageprocessor	gd2
avatarsmallheight	40
avatarsmallwidth	40
avatarheight	80
avatarwidth	80
avatarlargeheight	250
avatarlargewidth	250
cb_profile	0
discussbot	1
userlist_username	1
userlist_group	0
showlatest	1
latestcount	200
latestcountperpage	5
latestsinglesubject	1
latestreplysubject	1
latestsubjectlength	100
latestshowdate	1
latestshowhits	1
latestshowauthor	1
rules_infb	0
rules_link	www.bestofjoomla.com/
enablehelppage	0
help_infb	0
help_link	www.bestofjoomla.com/
rsstype	thread
rsshistory	year

| Kunena integration settings:

Warning: Spoiler!

Kunena - Finder Enabled 
 Kunena - AltaUserPoints Disabled
 Kunena - Community Builder Enabled:  access=1  login=1  activity=1  avatar=1  profile=1  private=1  
 Kunena - Easyblog Disabled
 Kunena - Easyprofile Disabled
 Kunena - Easysocial Disabled
 Kunena - Gravatar Disabled
 Kunena - JomSocial Disabled
 Kunena - Joomla Enabled:  access=1  login=1  
 Kunena - Kunena Enabled:  avatar=1  profile=1  
 Kunena - UddeIm Disabled

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:
de-DE	German (Germany)
en-GB	English (United Kingdom)

Third-party components: CommunityBuilder 2.11.0

Third-party SEF components: None

Plugins: Content - Kunena Discuss 6.0.5

Modules: Kunena Latest 6.0.7

  Переведено с помощью DeepL.com (бесплатная версия) 

@rich
Excellent. Now I need to repeat the same steps you took.

So far, it hasn't worked.
I deleted my Gich template.
I deleted everything with the word Kunena in Joomla.
However, I still got: Warning
Incorrect date value: '' for column `mde`.`j5r_kunena_version`.`versiondate` at row 1
Did you get this message? 
Maybe this is important?

I reinstalled K6.3.10. - OK.

Then I installed K6.4.9 and again got:
Kunena 6.4 has not been installed, aborting!
Etension Install: Custom install routine failure.
Error installing package

The main thing is that now I can be sure that the problem is solved (and judging by your description, it's easy).
But I need to figure out what's wrong with me.

This is a premature question, but could you please clarify the statement "I removed the database column 'twitter' to fix an error message related to it." Was this already done in K7.0.2? In which table?  @rich
 

When upgrading from K6.3 to K6.4, the database is adjusted. Because Twitter no longer exists, so this column, among others, also should be removed. For some reason, this column was not removed from the #__kunena_users table. However, this does not mean that this is always the case.
Have you tried the jpa file I uploaded? I don't know if you could see the private text.

rich wrote:

Have you tried the jpa file I uploaded? I don't know if you could see the private text.
 

Hooray!
I downloaded your file, and it works perfectly on my local server. Even with my templates.
Thank you so much.
Unfortunately, I can't replicate your path on my server.
So now I have some practical questions.

Is there a way to migrate the Kunen installation to a production server without replacing the entire site? For example, should I completely uninstall Kunen 6.3.10 (including the database), import the Kunen tables from your site to the server, and install K7.0.2 (or some other order)?

It's awkward to ask you for complete technical assistance, but since I don't have a regular way to update, could you help me convert the German site as well?

For example, should I completely uninstall Kunen 6.3.10 (including the database), import the Kunen tables from your site to the server, and install K7.0.2 

This should generally work, but if you completely remove Kunena 6.0.3 (via Kunena Tools), you must first download the /media/kunena folder as a backup, otherwise you will lose the avatars and all images. After successful installation, simply copy this folder back. That's all you need to do.

I downloaded your file, and it works perfectly on my local server. Even with my templates.
Unfortunately, I can't replicate your path on my server.

If you entered the correct data (database name, database password, etc.) during the transfer with Akeeba and the path of your local installation is still being called up after the transfer to the server, you must clear the Joomla cache, as the old path is being called up from the cache.