Question Error - Unknown column 'a.rankId' in 'field list'

Hello,
after the Update from Joomla 3 to Joomla 4 and Kunea 5 to Kunea 6, i become Error messages.

In top of a topic and next to an Admin-User this error message appears:
Warning: Undefined property: stdClass::$rankImage in /var/www/html/libraries/kunena/src/User/KunenaUser.php on line 1720
and/or
Warning: Undefined property: stdClass::$rankId in /var/www/html/libraries/vendor/joomla/database/src/DatabaseDriver.php on line 1382

And if I click in the backend (components -> kunea Forum)  to the menue item "ranks" I get the message:
An error has occurred. Unknown column 'a.rankId' in 'field list' Unknown column 'a.rankId' in 'field list'
Button: Back to the dashboard

Can anyone help me?

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: 30 seconds | Max execution memory: 128M | Max file upload:

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path	In trash
721	Forum	kunenamenu	view=home&defaultmenu=722	forum	No
723	Aktuell	kunenamenu	view=topics&mode=replies	forum/aktuell	No
724	Neues Thema	kunenamenu	view=topic&layout=create	forum/neuesthema	No
725	Ohne Antwort	kunenamenu	view=topics&mode=noreplies	forum/ohneantwort	No
726	Meine Themen	kunenamenu	view=topics&layout=user&mode=default	forum/meinethemen	No
727	Profil	kunenamenu	view=user	forum/profil	No
728	Hilfe	kunenamenu	view=misc	forum/hilfe	No
729	Suche	kunenamenu	view=search	forum/suche	No
875	forum	kunenamenu	view=home&defaultmenu=870	forum-en	No
870	index	kunenamenu	view=category&layout=list&catid=4	forum-en/index	No
868	current	kunenamenu	view=topics&mode=replies	forum-en/current	No
869	new topic	kunenamenu	view=topic&layout=create&catid=4	forum-en/new-topic	No
871	without reply	kunenamenu	view=topics&mode=noreplies	forum-en/without-reply	No
872	my topics	kunenamenu	view=topics&layout=user&mode=default	forum-en/my-topics	No
873	user profile	kunenamenu	view=user	forum-en/user-profile	No
1007	help	kunenamenu	view=misc	forum-en/help	Yes
867	support	kunenamenu	view=misc	forum-en/support	No
874	search	kunenamenu	view=search	forum-en/search	No
3109	Anwender-forum-header	kunenamenu	view=category&layout=list&catid=0	anwender-forum-header	No

Joomla default template details : YOOtheme | author: YOOtheme | version: 4.3.11 | creationdate: April 2024

Kunena default template details : Aurelia | author: Kunena Team | version: 6.2.6 | creationdate: 2024-04-16

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
Superscript	1
RemoveFormat	1
BulletedList	1
NumberedList	1
Blockquote	1
JustifyLeft	1
JustifyCenter	1
JustifyRight	1
JustifyBlock	1
Link_Unlink	1
Image	1
Smiley	1
Confidential	1
Hidetext	1
Spoiler	1
Code	1
Ebay	1
Twitter	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.2.6 | 2024-04-16 [ Git Repository ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
boardOffline	0
enableRss	1
threadsPerPage	20
messagesPerPage	6
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	1
allowSubscriptions	1
subscriptionsChecked	1
allowFavorites	1
maxSig	300
regOnly	1
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	150
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	desc
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	ago
postDateFormatHover	datetime
hideIp	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	0
userDeleteMessage	0
latestCategoryIn	1
topicIcons	1
debug	1
catsAutoSubscribed	0
showBannedReason	0
showThankYou	1
showPopThankYouStats	1
popThanksCount	5
modSeeDeleted	0
bbcodeImgSecure	text
listCatShowModerators	1
lightbox	2
showListTime	720
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	0
rssFeedBurnerUrl
autoLink	1
accessComponent	1
statsLinkAllowed	1
superAdminUserlist	0
attachmentProtection	0
categoryIcons	1
avatarCrop	0
userReport	1
searchTime	365
teaser	1
ebayLanguage	0
ebayCertId
allowChangeSubject	1
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	1
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
board_title	Anwender Forum
board_offline	0
offline_message	The Forum is currently offline for maintenance. Check back soon!
enablerss	1
threads_per_page	20
messages_per_page	10
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
disemoticons	0
showannouncement	1
avataroncat	0
catimagepath	category_images
showchildcaticon	1
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
askemail	1
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	0
allowfavorites	1
maxsubject	80
maxsig	300
regonly	0
pubwrite	0
floodprotection	0
mailmod	1
mailadmin	-1
mailfull	1
allowavatarupload	1
allowavatargallery	1
avatarquality	75
avatarsize	2048
imageheight	2048
imagewidth	3840
imagesize	2000
filetypes	s12,txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	10000
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_posts	1
userlist_karma	0
userlist_email	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	0
latestcategory	0
showstats	1
showwhoisonline	0
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
showspoilertag	1
showvideotag	1
showebaytag	0
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
sessiontimeout	1800
highlightcode	1
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	desc
showimgforguest	1
showfileforguest	1
pollnboptions	4
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
allow_user_edit_poll	0
maxpersotext	100
ordering_system	mesid
post_dateformat	ago
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	0
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	720
show_session_type	2
show_session_starttime	1800
userlist_allowed	0
userlist_count_users	2
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	0
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
email_visible_address
captcha_post_limit
image_upload	registered
file_upload	registered
topic_layout	flat
time_to_create_page	0
show_imgfiles_manage_profile	1
hold_newusers_posts	0
hold_guest_posts	0
attachment_limit	8
article_display	intro
send_emails	1
fallback_english	1
cache_time	60
ebay_affiliate_id
iptracking	0
rss_feedburner_url
autolink	1
access_component	0
statslink_allowed	0
superadmin_userlist	1
legacy_urls	0
attachment_protection	1
categoryicons	1
avatarresizemethod	1
avatarcrop	0
user_report	1
searchtime	365
ebay_language	0
ebay_api_key
ebay_cert_id
twitter_consumer_key
twitter_consumer_secret
allow_change_subject	1
max_links	6
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	1
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	1
disable_re	0
recaptcha_publickey	6LcUyAATAAAAANKCvIZH1JiAwmUAKOdJxAR2IH4I
recaptcha_privatekey	6LcUyAATAAAAAJzNoKlYc24ArvGMUAAw4uNhwPpF
recaptcha_theme	white
keywords	0
userkeywords	0
userlist_name	1
usernamechange	0
version_check	1

| Kunena integration settings:

Warning: Spoiler!

Kunena - Finder Disabled
Kunena - AltaUserPoints Disabled
Kunena - Community Builder Disabled
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: None

Third-party SEF components: None

Plugins: None

Modules: None

Hello,

The Kunena tables hasn't been updated during the update from K5.x to K6.x

Did-you have opened the kunena dashboard just after the update ? Is-that showed some alert about updates ?

Hello,
no i don't opend it just after the update. There were some other errors after the Update, but they are fixed now.
So I don't konow if the Update actually is the reason of this Error.

There are no alerts about updates. I have Kunena Version 6.2.6 .

This two Errors are left (I think they are related):

If I click in the backend (components -> kunea Forum)  to the menue item "ranks" I get the message:
An error has occurred. Unknown column 'a.rankId' in 'field list' Unknown column 'a.rankId' in 'field list'
Button: Back to the dashboard

In the Frontend over a topic this message appears:
Warning: Undefined property: stdClass::$rankId in /var/www/html/libraries/vendor/joomla/database/src/DatabaseDriver.php on line 1382

 

Have you already updated to K 6.3?

Yes, I just did the update to K 6.3. It didn't change anything about the error messages.

When clicking on "System / Maintenance / Database" in the Joomla backend, which manifest version is displayed?