- Posts: 4
- Thank you received: 0
Kunena 6.4.7 Released
The Kunena team has announce the arrival of Kunena 6.4.7[K 6.4.7] in stable which is now available for download as a native Joomla extension for J! 5.0.x/5.1.x/5.2.x/5.3.x/5.4.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 6.4
Important note: Go to the Kunena Dashboard after an upgrade so that the Kunena database tables are also updated. This is particularly necessary for major version jumps so that the table changes are adapted.
Question Incorrect integer value: '' for column 'rank' at row 1
1 month 2 days ago #1
by Web-Mex
Incorrect integer value: '' for column 'rank' at row 1 was created by Web-Mex
Hi, I get an Error message after a Kunena migration fom Kunena 5 to Kunena 6.
When i add newRank to a user following error will apear:
My Configuration:
I did the Database diagnostics and checked all Tables without any issues.
When i add newRank to a user following error will apear:
Code:
Es ist ein Fehler aufgetreten.
[quote]0 Incorrect integer value: '' for column 'rank' at row 1[/quote]
Call Stack[b]#[/b][b]Function[/b][b]Location[/b]1()JROOT/libraries/kunena/src/User/KunenaUser.php:11042Kunena\Forum\Libraries\User\KunenaUser->save()JROOT/administrator/components/com_kunena/src/Controller/UserController.php:1563Kunena\Forum\Administrator\Controller\UserController->saveInternal()JROOT/administrator/components/com_kunena/src/Controller/UserController.php:2264Kunena\Forum\Administrator\Controller\UserController->applychanges()JROOT/libraries/src/MVC/Controller/BaseController.php:7305Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/libraries/src/Dispatcher/ComponentDispatcher.php:1436Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch()JROOT/libraries/src/Component/ComponentHelper.php:3617Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/AdministratorApplication.php:1508Joomla\CMS\Application\AdministratorApplication->dispatch()JROOT/libraries/src/Application/AdministratorApplication.php:2059Joomla\CMS\Application\AdministratorApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:30410Joomla\CMS\Application\CMSApplication->execute()JROOT/administrator/includes/app.php:5811require_once()JROOT/administrator/index.php:32
My Configuration:
This message contains confidential information
Database collation check: lpj7c_kunena_aliases have wrong collation of type utf8mb3_general_ci on field alias lpj7c_kunena_aliases have wrong collation of type utf8mb3_general_ci on field type lpj7c_kunena_aliases have wrong collation of type utf8mb3_general_ci on field item lpj7c_kunena_announcement have wrong collation of type utf8mb3_general_ci on field title lpj7c_kunena_announcement have wrong collation of type utf8mb3_general_ci on field sdescription lpj7c_kunena_announcement have wrong collation of type utf8mb3_general_ci on field description lpj7c_kunena_attachments have wrong collation of type utf8mb3_general_ci on field hash lpj7c_kunena_attachments have wrong collation of type utf8mb3_general_ci on field folder lpj7c_kunena_attachments have wrong collation of type utf8mb3_general_ci on field filetype lpj7c_kunena_attachments have wrong collation of type utf8mb3_general_ci on field filename lpj7c_kunena_attachments have wrong collation of type utf8mb3_general_ci on field filename_real lpj7c_kunena_attachments have wrong collation of type utf8mb3_general_ci on field caption lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field name lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field alias lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field icon lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field accesstype lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field channels lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field description lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field headerdesc lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field class_sfx lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field topicOrdering lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field iconset lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field params lpj7c_kunena_configuration have wrong collation of type utf8mb3_general_ci on field params lpj7c_kunena_keywords have wrong collation of type utf8mb3_general_ci on field name lpj7c_kunena_logs have wrong collation of type utf8mb3_general_ci on field ip lpj7c_kunena_logs have wrong collation of type utf8mb3_general_ci on field operation lpj7c_kunena_messages have wrong collation of type utf8mb3_general_ci on field name lpj7c_kunena_messages have wrong collation of type utf8mb3_general_ci on field email lpj7c_kunena_messages have wrong collation of type utf8mb3_general_ci on field subject lpj7c_kunena_messages have wrong collation of type utf8mb3_general_ci on field ip lpj7c_kunena_messages have wrong collation of type utf8mb3_general_ci on field modified_reason lpj7c_kunena_messages_text have wrong collation of type utf8mb3_general_ci on field message lpj7c_kunena_polls have wrong collation of type utf8mb3_general_ci on field title lpj7c_kunena_polls_options have wrong collation of type utf8mb3_general_ci on field text lpj7c_kunena_ranks have wrong collation of type utf8mb3_general_ci on field rankTitle lpj7c_kunena_ranks have wrong collation of type utf8mb3_general_ci on field rankImage lpj7c_kunena_sessions have wrong collation of type utf8mb3_general_ci on field allowed lpj7c_kunena_sessions have wrong collation of type utf8mb3_general_ci on field readtopics lpj7c_kunena_smileys have wrong collation of type utf8mb3_general_ci on field code lpj7c_kunena_smileys have wrong collation of type utf8mb3_general_ci on field location lpj7c_kunena_smileys have wrong collation of type utf8mb3_general_ci on field greylocation lpj7c_kunena_topics have wrong collation of type utf8mb3_general_ci on field subject lpj7c_kunena_topics have wrong collation of type utf8mb3_general_ci on field first_post_message lpj7c_kunena_topics have wrong collation of type utf8mb3_general_ci on field first_post_guest_name lpj7c_kunena_topics have wrong collation of type utf8mb3_general_ci on field last_post_message lpj7c_kunena_topics have wrong collation of type utf8mb3_general_ci on field last_post_guest_name lpj7c_kunena_topics have wrong collation of type utf8mb3_general_ci on field params lpj7c_kunena_user_categories have wrong collation of type utf8mb3_general_ci on field params lpj7c_kunena_user_topics have wrong collation of type utf8mb3_general_ci on field params lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field status_text lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field view lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field signature lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field avatar lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field personalText lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field location lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field websitename lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field websiteurl lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field ip lpj7c_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field ip lpj7c_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field reason_private lpj7c_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field reason_public lpj7c_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field comments lpj7c_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field params
Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |
This message contains confidential informationhtaccess: Exists | PHP environment: Max execution time: 50000 seconds | Max execution memory: -1 | Max file upload:
Kunena menu details:
Warning: Spoiler!
ID Name Menutype Link Path In trash 638 Online-Selbsthilfe-Forum mainmenu view=home&defaultmenu=299 verein/selbsthilfeangebot/forum-und-erfahrungsaustausch No 1077 Inkontinenz Forum - Unterstützung durch Gemeinschaft erleben kunenamenu view=home&defaultmenu=283 forum No 1079 Aktuell (NEU) kunenamenu view=topics&mode=replies forum/aktuelle-beitraege No 1081 Beitrag schreiben kunenamenu view=topic&layout=create forum/neuen-beitrag-schreiben No 1083 Meine Beiträge kunenamenu view=topics&layout=user&mode=default forum/meine-beitraege No 1085 Profil bearbeiten kunenamenu view=user forum/profil No 1084 Suche kunenamenu view=search forum/suchen No
Joomla default template details : tp_master | author: joomlaPlates | version: 2.5 | creationdate: 2025-09-02
Kunena default template details : Aurelia | author: Kunena Team | version: 6.4.6 | creationdate: 2025-09-30
Kunena template params:
Warning: Spoiler!
DefaultCategoryicon profileIconset default DefaultIconset default editorIconset default bootstrap 1 borderless 1 tooltips 1 SubjectLengthMessage 80 fullactions 1 quick 1 displayMenu 1 displayDropdownMenu 1 displayDropdownContent 1 displayModule 1 displayBreadcrumb 1 displayAnnouncement 1 displayFooter 1 avatarPosition left formRecover 0 labels 1 whoisonlineName default avatarType rounded topicicontype image fontawesome 1 optional_username 0 writeaccess 0 localstorage 0 moduleIdWebauthn 0 IconColor inherit IconColorNew #48a348 editorType sceditor 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 0 X_Social 0 0 Soundcloud 0 FontSize 1 TextColor 1 Maximize 0 Map 0 Video 1 editorButtons bold,italic,underline,strike,superscript,subscript,right,left,justify,center,removeFormat,font,size,color,Image,Video,link,unlink,bulletedList,orderedlist,Code 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.4.6 | 2025-09-30 [ Git Repository ]
| Kunena detailed configuration:| Kunena integration settings:Warning: Spoiler!
Kunena config settings: boardOffline 0 enableRss 1 threadsPerPage 10 messagesPerPage 10 messagesPerPageSearch 15 showHistory 1 historyLimit 10 showNew 1 disableEmoticons 0 template aurelia showAnnouncement 1 avatarOnCategory 1 showChildCatIcon 1 rteWidth 450 rteHeight 300 enableForumJump 1 reportMsg 1 username 1 askEmail 0 showEmail 0 showUserStats 1 showKarma 0 userEdit 0 userEditTime 600 userEditTimeGrace 600 editMarkup 1 allowSubscriptions 1 subscriptionsChecked 1 allowFavorites 1 maxSig 300 regOnly 0 pubWrite 0 floodProtection 0 mailModerators 0 mailAdministrators 0 captcha 0 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 0 rssExcludedCategories 0 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,webp,avif checkMimeTypes 1 imageMimeTypes image/jpeg,image/jpg,image/gif,image/png,image/webp,image/avif 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 0 lightbox 1 showListTime 720 showSessionType 2 showSessionStartTime 1800 userlistAllowed 1 userlistCountUsers 0 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 1 articleDisplay full sendEmails 1 fallbackEnglish 1 cache 1 cacheTime 60 ipTracking 1 rssFeedBurnerUrl autoLink 1 accessComponent 1 statsLinkAllowed 1 superAdminUserlist 0 attachmentProtection 0 categoryIcons 1 avatarCrop 1 userReport 1 searchTime 365 teaser 0 ebayLanguage 77 ebayCertId allowChangeSubject 1 maxLinks 6 readOnly 0 ratingEnabled 0 urlSubjectTopic 1 logModeration 0 attachStart 0 attachEnd 14 attachmentUtf8 1 autoEmbedSoundcloud 1 emailHeader media/kunena/email/hero-wide.png userStatus 1 signature 1 personal 1 plainEmail 0 moderatorPermDelete 0 avatarTypes gif,jpeg,jpg,png smartLinking 0 defaultAvatar nophoto.png defaultAvatarSmall s_nophoto.png quickReply 1 avatarEdit 1 activeMenuItem mainMenuId homeId indexId moderatorsId topicListId miscId profileId searchId custom_id avatarType 0 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 profiler 0 privateMessage 0 datePickerFormat mm/dd/yyyy sendMailUserBanned 0 mailBodyUserBanned mailBodyUserUnBanned board_title 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 15 shownew 1 disemoticons 0 showannouncement 1 avataroncat 1 catimagepath category_images showchildcaticon 1 rtewidth 450 rteheight 300 enableforumjump 1 reportmsg 1 askemail 0 showemail 0 showuserstats 1 showkarma 0 useredit 1 useredittime 6000 useredittimegrace 6000 editmarkup 0 allowsubscriptions 1 subscriptionschecked 1 allowfavorites 1 maxsubject 50 maxsig 300 regonly 0 pubwrite 0 floodprotection 0 mailmod 0 mailadmin 0 mailfull 0 allowavatarupload 1 allowavatargallery 1 avatarquality 75 avatarsize 2048 imageheight 800 imagewidth 800 imagesize 1500 filetypes txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2 filesize 2000 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 1 latestcategory showstats 1 showwhoisonline 1 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 asc showimgforguest 1 showfileforguest 1 pollnboptions 10 pollallowvoteone 1 pollenabled 1 poppollscount 5 showpoppollstats 1 polltimebtvotes 00:15:00 pollnbvotesbyuser 100 pollresultsuserslist 1 maxpersotext 50 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,image/gd-jpeg 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 image listcat_show_moderators 0 show_list_time 720 show_session_type 1 show_session_starttime 1800 userlist_allowed 0 userlist_count_users 1 enable_threaded_layouts 0 category_subscriptions post topic_subscriptions first pubprofile 1 thankyou_max 15 email_recipient_count 0 email_recipient_privacy bcc email_visible_address captcha_post_limit 0 image_upload registered file_upload registered topic_layout flat time_to_create_page 1 show_imgfiles_manage_profile 1 hold_newusers_posts 0 hold_guest_posts 0 attachment_limit 8 pickup_category 1 article_display intro send_emails 1 fallback_english 1 cache_time 60 ebay_affiliate_id 5337089937 iptracking 1 stopforumspam_key rss_feedburner_url autolink 1 access_component 0 statslink_allowed 1 superadmin_userlist 0 legacy_urls 1 attachment_protection 0 categoryicons 1 avatarresizemethod 1 avatarcrop 0 user_report 1 searchtime 365 ebay_language 77 ebay_api_key twitter_consumer_key twitter_consumer_secret allow_change_subject 0 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 0 emailheader /media/kunena/email/hero-wide.png user_status 1 plain_email 1 | Joomla! detailed language files installed:Warning: Spoiler!Kunena - Finder 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
Warning: Spoiler!
Joomla! languages installed: en-GB English (United Kingdom) de-DE German (Germany)
Third-party components: None
Third-party SEF components: None
Plugins: None
Modules: Kunena Latest 6.1.0 | Kunena Stats 6.1.0
I did the Database diagnostics and checked all Tables without any issues.
Please Log in or Create an account to join the conversation.
1 month 2 days ago #2
by rich
Important! Always create a backup before you make any changes to your website!
Replied by rich on topic Incorrect integer value: '' for column 'rank' at row 1
Which version of Kunena did you update Kunena from? There are lots of versions in the Kunena 5 series.
You also need to update your database, including the columns. Kunena and Joomla use utf8mb4_unicode or utf8mb4_general.
Incidentally, you also have an incorrect menu item in your main menu (see image). Links in other menus that lead to the forum must be of the alias menu type ( see here ).
.
You also need to update your database, including the columns. Kunena and Joomla use utf8mb4_unicode or utf8mb4_general.
Incidentally, you also have an incorrect menu item in your main menu (see image). Links in other menus that lead to the forum must be of the alias menu type ( see here ).
.
Important! Always create a backup before you make any changes to your website!
Please Log in or Create an account to join the conversation.
Time to create page: 0.492 seconds