- Posts: 12
- Thank you received: 0
Kunena 6.3.0 released
The Kunena team has announce the arrival of Kunena 6.3.0 [K 6.3.0] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 and issues discovered during the last development stages of K 6.3
Question have wrong collation of type utf8mb3_general_ci
11 months 2 weeks ago - 11 months 2 weeks ago #1
by adriendf
have wrong collation of type utf8mb3_general_ci was created by adriendf
I notice some malfunctions since my migration to Joomla4.
The forum works but not the statistics, nor the "UNREAD" button
When I edit Kunena's configuration: I have this: have wrong collation of type utf8mb3_general_ci
as a new member i cannot put URL or picture
In a post, Rich said:
How can i do ?
A - i have admintool and i did not have Change Database Collation"
But i have that "Repair & Optimise Tables".
(my version is update, i have click on it but nothing change)
B : how can i do using phpmyadmin ?
best regards
best regards
The forum works but not the statistics, nor the "UNREAD" button
When I edit Kunena's configuration: I have this: have wrong collation of type utf8mb3_general_ci
This message contains confidential information
Database collation check: N_kunena_aliases have wrong collation of type utf8mb3_general_ci on field alias N_kunena_aliases have wrong collation of type utf8mb3_general_ci on field type N_kunena_aliases have wrong collation of type utf8mb3_general_ci on field item N_kunena_announcement have wrong collation of type utf8mb3_general_ci on field title N_kunena_announcement have wrong collation of type utf8mb3_general_ci on field sdescription N_kunena_announcement have wrong collation of type utf8mb3_general_ci on field description N_kunena_attachments have wrong collation of type utf8mb3_general_ci on field hash N_kunena_attachments have wrong collation of type utf8mb3_general_ci on field folder N_kunena_attachments have wrong collation of type utf8mb3_general_ci on field filename N_kunena_attachments have wrong collation of type utf8mb3_general_ci on field filename_real N_kunena_attachments have wrong collation of type utf8mb3_general_ci on field caption N_kunena_categories have wrong collation of type utf8mb3_general_ci on field name N_kunena_categories have wrong collation of type utf8mb3_general_ci on field alias N_kunena_categories have wrong collation of type utf8mb3_general_ci on field icon N_kunena_categories have wrong collation of type utf8mb3_general_ci on field accesstype N_kunena_categories have wrong collation of type utf8mb3_general_ci on field channels N_kunena_categories have wrong collation of type utf8mb3_general_ci on field description N_kunena_categories have wrong collation of type utf8mb3_general_ci on field headerdesc N_kunena_categories have wrong collation of type utf8mb3_general_ci on field class_sfx N_kunena_categories have wrong collation of type utf8mb3_general_ci on field iconset N_kunena_categories have wrong collation of type utf8mb3_general_ci on field params N_kunena_configuration have wrong collation of type utf8mb3_general_ci on field params N_kunena_keywords have wrong collation of type utf8mb3_general_ci on field name N_kunena_logs have wrong collation of type utf8mb3_general_ci on field ip N_kunena_logs have wrong collation of type utf8mb3_general_ci on field operation N_kunena_messages have wrong collation of type utf8mb3_general_ci on field name N_kunena_messages have wrong collation of type utf8mb3_general_ci on field email N_kunena_messages have wrong collation of type utf8mb3_general_ci on field subject N_kunena_messages have wrong collation of type utf8mb3_general_ci on field ip N_kunena_messages have wrong collation of type utf8mb3_general_ci on field modified_reason N_kunena_polls have wrong collation of type utf8mb3_general_ci on field title N_kunena_polls_options have wrong collation of type utf8mb3_general_ci on field text N_kunena_sessions have wrong collation of type utf8mb3_general_ci on field allowed N_kunena_sessions have wrong collation of type utf8mb3_general_ci on field readtopics N_kunena_smileys have wrong collation of type utf8mb3_general_ci on field code N_kunena_smileys have wrong collation of type utf8mb3_general_ci on field location N_kunena_smileys have wrong collation of type utf8mb3_general_ci on field greylocation N_kunena_topics have wrong collation of type utf8mb3_general_ci on field subject N_kunena_topics have wrong collation of type utf8mb3_general_ci on field first_post_message N_kunena_topics have wrong collation of type utf8mb3_general_ci on field first_post_guest_name N_kunena_topics have wrong collation of type utf8mb3_general_ci on field last_post_message N_kunena_topics have wrong collation of type utf8mb3_general_ci on field last_post_guest_name N_kunena_topics have wrong collation of type utf8mb3_general_ci on field params N_kunena_users have wrong collation of type utf8mb3_general_ci on field status_text N_kunena_users have wrong collation of type utf8mb3_general_ci on field view N_kunena_users have wrong collation of type utf8mb3_general_ci on field signature N_kunena_users have wrong collation of type utf8mb3_general_ci on field avatar N_kunena_users have wrong collation of type utf8mb3_general_ci on field personalText N_kunena_users have wrong collation of type utf8mb3_general_ci on field location N_kunena_users have wrong collation of type utf8mb3_general_ci on field icq N_kunena_users have wrong collation of type utf8mb3_general_ci on field yim N_kunena_users have wrong collation of type utf8mb3_general_ci on field microsoft N_kunena_users have wrong collation of type utf8mb3_general_ci on field telegram N_kunena_users have wrong collation of type utf8mb3_general_ci on field vk N_kunena_users have wrong collation of type utf8mb3_general_ci on field skype N_kunena_users have wrong collation of type utf8mb3_general_ci on field twitter N_kunena_users have wrong collation of type utf8mb3_general_ci on field facebook N_kunena_users have wrong collation of type utf8mb3_general_ci on field google N_kunena_users have wrong collation of type utf8mb3_general_ci on field myspace N_kunena_users have wrong collation of type utf8mb3_general_ci on field linkedin N_kunena_users have wrong collation of type utf8mb3_general_ci on field delicious N_kunena_users have wrong collation of type utf8mb3_general_ci on field friendfeed N_kunena_users have wrong collation of type utf8mb3_general_ci on field digg N_kunena_users have wrong collation of type utf8mb3_general_ci on field instagram N_kunena_users have wrong collation of type utf8mb3_general_ci on field qzone N_kunena_users have wrong collation of type utf8mb3_general_ci on field weibo N_kunena_users have wrong collation of type utf8mb3_general_ci on field wechat N_kunena_users have wrong collation of type utf8mb3_general_ci on field apple N_kunena_users have wrong collation of type utf8mb3_general_ci on field blogspot N_kunena_users have wrong collation of type utf8mb3_general_ci on field flickr N_kunena_users have wrong collation of type utf8mb3_general_ci on field bebo N_kunena_users have wrong collation of type utf8mb3_general_ci on field websitename N_kunena_users have wrong collation of type utf8mb3_general_ci on field websiteurl N_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field ip N_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field reason_private N_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field reason_public N_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field comments N_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field params N_kunena_version have wrong collation of type utf8mb3_general_ci on field version N_kunena_version have wrong collation of type utf8mb3_general_ci on field versionname N_kunena_version have wrong collation of type utf8mb3_general_ci on field state
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 5710 Forum mainmenu Itemid=5700 kunena-2023-03-25 No 5700 Forum kunenamenu view=home&defaultmenu=5702 forum No 5701 Sommaire kunenamenu view=category&layout=list&catid=0 forum/index No 5702 Sujets recents kunenamenu view=topics&mode=replies forum/recent No 5703 Non lu kunenamenu view=topics&layout=unread forum/unread No 5704 Nouveau Topic kunenamenu view=topic&layout=create forum/newtopic No 5705 Pas réponse kunenamenu view=topics&mode=noreplies forum/noreplies No 5706 My Topics kunenamenu view=topics&layout=user&mode=default forum/mylatest No 5707 Profil kunenamenu view=user forum/profile No 5709 Search kunenamenu view=search forum/search No
Joomla default template details : tz_jollyany | author: TemPlaza | version: 3.5.13 | creationdate: March 2023
Kunena default template details : Aurelia | author: Kunena Team | version: 6.0.10 | creationdate: 2023-04-02
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 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 1 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.0.10 | 2023-04-02 [ Git Repository ]
| Kunena detailed configuration:| Kunena integration settings:Warning: Spoiler!
Kunena config settings: boardOffline 0 enableRss 0 threadsPerPage 10 messagesPerPage 5 messagesPerPageSearch 10 showHistory 1 historyLimit 5 showNew 1 disableEmoticons 0 template blue_eagle5 showAnnouncement 1 avatarOnCategory 0 showChildCatIcon 1 rteWidth 450 rteHeight 300 enableForumJump 0 reportMsg 1 username 1 askEmail 0 showEmail 0 showUserStats 0 showKarma 0 userEdit 1 userEditTime 0 userEditTimeGrace 600 editMarkup 1 allowSubscriptions 1 subscriptionsChecked 0 allowFavorites 0 maxSig 300 regOnly 0 pubWrite 0 floodProtection 0 mailModerators 0 mailAdministrators 0 captcha -1 mailFull 0 allowAvatarUpload 1 allowAvatarGallery 1 avatarQuality 75 avatarSize 2048 imageHeight 800 imageWidth 800 imageSize 150 fileTypes txt,rtf,pdf,zip,,tgz, fileSize 120 showRanking 1 rankImages 1 userlistRows 30 userlistOnline 1 userlistAvatar 1 userlistPosts 1 userlistKarma 0 userlistEmail 0 userlistJoinDate 0 userlistLastVisitDate 0 userlistUserHits 0 latestCategory 0 showStats 1 showWhoIsOnline 0 showGenStats 1 showPopUserStats 1 popUserCount 20 showPopSubjectStats 1 popSubjectCount 5 showSpoilerTag 1 showVideoTag 1 showEbayTag 1 trimLongUrls 1 trimLongUrlsFront 40 trimLongUrlsBack 20 autoEmbedYoutube 1 autoEmbedEbay 0 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 0 popPollsCount 5 showPopPollStats 0 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 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 0 userlistCountUsers 1 enableThreadedLayouts 0 categorySubscriptions post topicSubscriptions every pubProfile 1 thankYouMax 5 emailRecipientCount 0 emailRecipientPrivacy bcc captchaPostLimit 0 imageUpload registered fileUpload registered topicLayout flat timeToCreatePage 1 showImgFilesManageProfile 0 holdNewUsersPosts 0 holdGuestPosts 0 attachmentLimit 8 pickupCategory 0 articleDisplay intro sendEmails 0 fallbackEnglish 1 cache 1 cacheTime 300 ipTracking 0 rssFeedBurnerUrl autoLink 1 accessComponent 1 statsLinkAllowed 0 superAdminUserlist 0 attachmentProtection 0 categoryIcons 1 avatarCrop 0 userReport 1 searchTime 365 teaser 0 ebayLanguage 0 ebayCertId allowChangeSubject 1 maxLinks 6 readOnly 0 ratingEnabled 0 urlSubjectTopic 0 logModeration 0 attachStart 0 attachEnd 14 attachmentUtf8 1 autoEmbedSoundcloud 0 emailHeader media/kunena/email/ userStatus 1 signature 1 personal 0 social 0 plainEmail 0 moderatorPermDelete 0 avatarTypes gif,jpeg,jpg,png smartLinking 0 defaultAvatar defaultAvatarSmall s_ quickReply 0 avatarEdit 0 activeMenuItem mainMenuId homeId indexId moderatorsId topicListId miscId profileId searchId custom_id avatarType 1 sefRedirect 1 allowEditPoll 1 useSystemEmails 0 autoEmbedInstagram 0 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 0 board_title Forum-concours board_offline 0 offline_message Le forum est temporairement fermé pour des opérations de maintenance nécessaire. L’équipe vous remercie pour votre patience et s’applique à vous rendre le forum le plus rapidement possible.
RDV en fin de soiréeenablerss 0 threads_per_page 20 messages_per_page 6 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 0 reportmsg 1 askemail 0 showemail 0 showuserstats 1 showkarma 0 useredit 1 useredittime 0 useredittimegrace 600 editmarkup 1 allowsubscriptions 0 subscriptionschecked 0 allowfavorites 0 maxsubject 50 maxsig 300 regonly 0 pubwrite 0 floodprotection 0 mailmod 0 mailadmin 0 mailfull 0 allowavatarupload 1 allowavatargallery 0 avatarquality 75 avatarsize 2048 imageheight 800 imagewidth 800 imagesize 300 filetypes txt,rtf,pdf,zip,,tgz, filesize 2000 showranking 1 rankimages 1 userlist_rows 30 userlist_online 1 userlist_avatar 1 userlist_posts 0 userlist_karma 0 userlist_email 0 userlist_joindate 0 userlist_lastvisitdate 0 userlist_userhits 0 latestcategory 0 showstats 0 showwhoisonline 0 showgenstats 0 showpopuserstats 1 popusercount 20 showpopsubjectstats 0 popsubjectcount 5 showspoilertag 1 showvideotag 1 showebaytag 0 trimlongurls 1 trimlongurlsfront 40 trimlongurlsback 20 autoembedyoutube 1 autoembedebay 0 ebaylanguagecode en-us sessiontimeout 172800 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 0 polltimebtvotes 00:15:00 pollnbvotesbyuser 2 pollresultsuserslist 1 allow_user_edit_poll 0 maxpersotext 50 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 1 showthankyou 1 showpopthankyoustats 0 popthankscount 5 mod_see_deleted 0 bbcode_img_secure text listcat_show_moderators 0 show_list_time 720 show_session_type 0 show_session_starttime 0 userlist_allowed 0 userlist_count_users 1 enable_threaded_layouts 0 category_subscriptions post topic_subscriptions first pubprofile 0 thankyou_max 20 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 0 show_imgfiles_manage_profile 1 hold_newusers_posts 0 hold_guest_posts 0 attachment_limit 8 article_display intro send_emails 0 fallback_english 1 cache_time 900 ebay_affiliate_id iptracking 0 rss_feedburner_url autolink 0 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 180 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 0 emailheader /media/kunena/email/ user_status 1 plain_email 0 moderator_permdelete 0 avatartypes gif, jpeg, jpg, png smartlinking 0 defaultavatar defaultavatarsmall s_ 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 6LdBldUSAAAAABKWTeDDZeYHiin0MjMgwCEiE_a9 recaptcha_privatekey 6LdBldUSAAAAAEymTiRzv5E9EzOr3d-50Lhu1LlL recaptcha_theme white keywords 0 userkeywords 0 userlist_name 1 userlist_usertype 0 usernamechange 0 sefutf8 0 version_check 1 changename 0 | Joomla! detailed language files installed:Warning: Spoiler!Kunena - Finder Disabled
Kunena - AltaUserPoints Disabled
Kunena - Community Builder Disabled
Kunena - Easyblog Disabled
Kunena - Easyprofile Disabled
Kunena - Easysocial Enabled: login=1 activity=1 avatar=1 profile=1 private=1 activity_badge_limit=0 activity_points_limit=0
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=1
Kunena - Kunena Enabled: avatar=0 profile=0
Warning: Spoiler!
Joomla! languages installed: fr-FR French (fr-FR) en-GB English (United Kingdom)
Third-party components: None
Third-party SEF components: None
Plugins: Content - Kunena Discuss 6.0.2-DEV
Modules: Kunena Latest 6.0.2
as a new member i cannot put URL or picture
In a post, Rich said:
"Please go to the database and check if the collation is actually utf8_general_ci, or just displayed incorrectly in your configuration report.
Joomla 4.x and also Kunena 6.0 the collation should be utf8mb4.
If this is not the case, you must change the collation to utf8mb4.
You can do this either with phpMyAdmin or with the from Akeeba. With you just have to select UTF-8 Multibyte under "Change Database Collation" (it is already preset) and run it. After that (as recommended) click on "Repair & Optimise Tables".
But first create a database backup."
How can i do ?
A - i have admintool and i did not have Change Database Collation"
But i have that "Repair & Optimise Tables".
(my version is update, i have click on it but nothing change)
B : how can i do using phpmyadmin ?
best regards
best regards
Last edit: 11 months 2 weeks ago by adriendf.
Please Log in or Create an account to join the conversation.
11 months 2 weeks ago - 11 months 2 weeks ago #2
by adriendf
Replied by adriendf on topic have wrong collation of type utf8mb3_general_ci
in phpmyadmin , all the table are with utf8mb4_unicode_ci
Last edit: 11 months 2 weeks ago by adriendf.
Please Log in or Create an account to join the conversation.
11 months 2 weeks ago #3
by rich
.
Replied by rich on topic have wrong collation of type utf8mb3_general_ci
Please upgrade to Kunena 6.0.11, Maybe it really is just the configuration report.In a post, Rich said
"Please go to the database and check if the collation is actually utf8_general_ci, or just displayed incorrectly in your configuration report.
.
Statistics are partially disabled. Go to the configuration -> tab Extra and enable the statistics you want.The forum works but not the statistics, nor the "UNREAD" button
The following user(s) said Thank You: adriendf
Please Log in or Create an account to join the conversation.
11 months 2 weeks ago #4
by adriendf
Replied by adriendf on topic have wrong collation of type utf8mb3_general_ci
thx for you reply
i have updated kunena, but it still here.
I was looking to know the most active members to reward them (those who post the most) I didn't know that the statistics didn't work anymore, I thought it was on site that didn't work anymore. (I started with Joomla 1.5 so there is old stuff in my site)
I'll stop looking
Thank you for your work. and for your dedication
i have updated kunena, but it still here.
I was looking to know the most active members to reward them (those who post the most) I didn't know that the statistics didn't work anymore, I thought it was on site that didn't work anymore. (I started with Joomla 1.5 so there is old stuff in my site)
I'll stop looking
Thank you for your work. and for your dedication
This message contains confidential information
Database collation check: 32_kunena_aliases have wrong collation of type utf8mb3_general_ci on field alias 32_kunena_aliases have wrong collation of type utf8mb3_general_ci on field type 32_kunena_aliases have wrong collation of type utf8mb3_general_ci on field item 32_kunena_announcement have wrong collation of type utf8mb3_general_ci on field title 32_kunena_announcement have wrong collation of type utf8mb3_general_ci on field sdescription 32_kunena_announcement have wrong collation of type utf8mb3_general_ci on field description 32_kunena_attachments have wrong collation of type utf8mb3_general_ci on field hash 32_kunena_attachments have wrong collation of type utf8mb3_general_ci on field folder 32_kunena_attachments have wrong collation of type utf8mb3_general_ci on field filename 32_kunena_attachments have wrong collation of type utf8mb3_general_ci on field filename_real 32_kunena_attachments have wrong collation of type utf8mb3_general_ci on field caption 32_kunena_categories have wrong collation of type utf8mb3_general_ci on field name 32_kunena_categories have wrong collation of type utf8mb3_general_ci on field alias 32_kunena_categories have wrong collation of type utf8mb3_general_ci on field icon 32_kunena_categories have wrong collation of type utf8mb3_general_ci on field accesstype 32_kunena_categories have wrong collation of type utf8mb3_general_ci on field channels 32_kunena_categories have wrong collation of type utf8mb3_general_ci on field description 32_kunena_categories have wrong collation of type utf8mb3_general_ci on field headerdesc 32_kunena_categories have wrong collation of type utf8mb3_general_ci on field class_sfx 32_kunena_categories have wrong collation of type utf8mb3_general_ci on field iconset 32_kunena_categories have wrong collation of type utf8mb3_general_ci on field params 32_kunena_configuration have wrong collation of type utf8mb3_general_ci on field params 32_kunena_keywords have wrong collation of type utf8mb3_general_ci on field name 32_kunena_logs have wrong collation of type utf8mb3_general_ci on field ip 32_kunena_logs have wrong collation of type utf8mb3_general_ci on field operation 32_kunena_messages have wrong collation of type utf8mb3_general_ci on field name 32_kunena_messages have wrong collation of type utf8mb3_general_ci on field email 32_kunena_messages have wrong collation of type utf8mb3_general_ci on field subject 32_kunena_messages have wrong collation of type utf8mb3_general_ci on field ip 32_kunena_messages have wrong collation of type utf8mb3_general_ci on field modified_reason 32_kunena_polls have wrong collation of type utf8mb3_general_ci on field title 32_kunena_polls_options have wrong collation of type utf8mb3_general_ci on field text 32_kunena_sessions have wrong collation of type utf8mb3_general_ci on field allowed 32_kunena_sessions have wrong collation of type utf8mb3_general_ci on field readtopics 32_kunena_smileys have wrong collation of type utf8mb3_general_ci on field code 32_kunena_smileys have wrong collation of type utf8mb3_general_ci on field location 32_kunena_smileys have wrong collation of type utf8mb3_general_ci on field greylocation 32_kunena_topics have wrong collation of type utf8mb3_general_ci on field subject 32_kunena_topics have wrong collation of type utf8mb3_general_ci on field first_post_message 32_kunena_topics have wrong collation of type utf8mb3_general_ci on field first_post_guest_name 32_kunena_topics have wrong collation of type utf8mb3_general_ci on field last_post_message 32_kunena_topics have wrong collation of type utf8mb3_general_ci on field last_post_guest_name 32_kunena_topics have wrong collation of type utf8mb3_general_ci on field params 32_kunena_users have wrong collation of type utf8mb3_general_ci on field status_text 32_kunena_users have wrong collation of type utf8mb3_general_ci on field view 32_kunena_users have wrong collation of type utf8mb3_general_ci on field signature 32_kunena_users have wrong collation of type utf8mb3_general_ci on field avatar 32_kunena_users have wrong collation of type utf8mb3_general_ci on field personalText 32_kunena_users have wrong collation of type utf8mb3_general_ci on field location 32_kunena_users have wrong collation of type utf8mb3_general_ci on field icq 32_kunena_users have wrong collation of type utf8mb3_general_ci on field yim 32_kunena_users have wrong collation of type utf8mb3_general_ci on field microsoft 32_kunena_users have wrong collation of type utf8mb3_general_ci on field telegram 32_kunena_users have wrong collation of type utf8mb3_general_ci on field vk 32_kunena_users have wrong collation of type utf8mb3_general_ci on field skype 32_kunena_users have wrong collation of type utf8mb3_general_ci on field twitter 32_kunena_users have wrong collation of type utf8mb3_general_ci on field facebook 32_kunena_users have wrong collation of type utf8mb3_general_ci on field google 32_kunena_users have wrong collation of type utf8mb3_general_ci on field myspace 32_kunena_users have wrong collation of type utf8mb3_general_ci on field linkedin 32_kunena_users have wrong collation of type utf8mb3_general_ci on field delicious 32_kunena_users have wrong collation of type utf8mb3_general_ci on field friendfeed 32_kunena_users have wrong collation of type utf8mb3_general_ci on field digg 32_kunena_users have wrong collation of type utf8mb3_general_ci on field instagram 32_kunena_users have wrong collation of type utf8mb3_general_ci on field qzone 32_kunena_users have wrong collation of type utf8mb3_general_ci on field weibo 32_kunena_users have wrong collation of type utf8mb3_general_ci on field wechat 32_kunena_users have wrong collation of type utf8mb3_general_ci on field apple 32_kunena_users have wrong collation of type utf8mb3_general_ci on field blogspot 32_kunena_users have wrong collation of type utf8mb3_general_ci on field flickr 32_kunena_users have wrong collation of type utf8mb3_general_ci on field bebo 32_kunena_users have wrong collation of type utf8mb3_general_ci on field websitename 32_kunena_users have wrong collation of type utf8mb3_general_ci on field websiteurl 32_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field ip 32_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field reason_private 32_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field reason_public 32_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field comments 32_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field params 32_kunena_version have wrong collation of type utf8mb3_general_ci on field version 32_kunena_version have wrong collation of type utf8mb3_general_ci on field versionname 32_kunena_version have wrong collation of type utf8mb3_general_ci on field state
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 5710 Forum mainmenu Itemid=5700 kunena-2023-03-25 No 5700 Forum kunenamenu view=home&defaultmenu=5701 forum No 5701 Sommaire kunenamenu view=category&layout=list&catid=0 forum/index No 5702 Sujets recents kunenamenu view=topics&mode=replies forum/recent No 5703 Non lu kunenamenu view=topics&layout=unread forum/unread No 5704 Nouveau Topic kunenamenu view=topic&layout=create forum/newtopic No 5705 Pas réponse kunenamenu view=topics&mode=noreplies forum/noreplies No 5706 My Topics kunenamenu view=topics&layout=user&mode=default forum/mylatest No 5707 Profil kunenamenu view=user forum/profile No 5709 Search kunenamenu view=search forum/search No 5912 statistiques kunenamenu view=statistics forum/statistiques No
Joomla default template details : tz_jollyany | author: TemPlaza | version: 3.5.13 | creationdate: March 2023
Kunena default template details : Aurelia | author: Kunena Team | version: 6.0.11 | creationdate: 2023-05-05
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 0 displayAnnouncement 1 displayFooter 0 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 IconColor inherit IconColorNew #48a348 editorType ckeditor Bold 1 Italic 1 Underline 1 Strike 0 Subscript 0 Superscript 0 RemoveFormat 1 BulletedList 0 NumberedList 0 Blockquote 1 JustifyLeft 1 JustifyCenter 1 JustifyRight 1 JustifyBlock 0 Link_Unlink 0 Image 1 Smiley 1 Confidential 0 Hidetext 1 Spoiler 1 Code 0 Ebay 0 0 0 Soundcloud 0 FontSize 0 TextColor 0 Maximize 0 Map 0 Video 0 editorButtons Strike,Superscript,Subscript,JustifyBlock,Confidential,Ebay,Twitter,Instagram,Soundcloud,Map,FontSize,TextColor,Maximize,Video,Link,Unlink,BulletedList,NumberedList,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.0.11 | 2023-05-05 [ Git Repository ]
| Kunena detailed configuration:| Kunena integration settings:Warning: Spoiler!
Kunena config settings: boardOffline 0 enableRss 0 threadsPerPage 10 messagesPerPage 5 messagesPerPageSearch 10 showHistory 1 historyLimit 5 showNew 0 disableEmoticons 0 template aurelia showAnnouncement 1 avatarOnCategory 0 showChildCatIcon 1 rteWidth 450 rteHeight 300 enableForumJump 0 reportMsg 1 username 1 askEmail 0 showEmail 0 showUserStats 0 showKarma 0 userEdit 1 userEditTime 0 userEditTimeGrace 600 editMarkup 1 allowSubscriptions 0 subscriptionsChecked 0 allowFavorites 0 maxSig 300 regOnly 0 pubWrite 0 floodProtection 0 mailModerators 0 mailAdministrators 0 captcha -1 mailFull 0 allowAvatarUpload 1 allowAvatarGallery 1 avatarQuality 75 avatarSize 2048 imageHeight 800 imageWidth 800 imageSize 150 fileTypes txt,rtf,pdf,zip,,tgz, fileSize 120 showRanking 1 rankImages 1 userlistRows 30 userlistOnline 0 userlistAvatar 1 userlistPosts 1 userlistKarma 0 userlistEmail 0 userlistJoinDate 0 userlistLastVisitDate 0 userlistUserHits 0 latestCategory 0 showStats 1 showWhoIsOnline 0 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 0 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 0 popPollsCount 5 showPopPollStats 0 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 0 debug 0 catsAutoSubscribed 0 showBannedReason 0 showThankYou 1 showPopThankYouStats 1 popThanksCount 5 modSeeDeleted 0 bbcodeImgSecure text listCatShowModerators 0 lightbox 1 showListTime 168 showSessionType 2 showSessionStartTime 1800 userlistAllowed 0 userlistCountUsers 1 enableThreadedLayouts 0 categorySubscriptions post topicSubscriptions every pubProfile 0 thankYouMax 5 emailRecipientCount 0 emailRecipientPrivacy bcc captchaPostLimit 0 imageUpload registered fileUpload registered topicLayout flat timeToCreatePage 1 showImgFilesManageProfile 0 holdNewUsersPosts 0 holdGuestPosts 0 attachmentLimit 8 pickupCategory 0 articleDisplay intro sendEmails 0 fallbackEnglish 1 cache 1 cacheTime 300 ipTracking 0 rssFeedBurnerUrl autoLink 1 accessComponent 1 statsLinkAllowed 0 superAdminUserlist 0 attachmentProtection 0 categoryIcons 1 avatarCrop 0 userReport 1 searchTime 180 teaser 0 ebayLanguage 0 ebayCertId allowChangeSubject 1 maxLinks 6 readOnly 0 ratingEnabled 0 urlSubjectTopic 0 logModeration 0 attachStart 0 attachEnd 14 attachmentUtf8 1 autoEmbedSoundcloud 0 emailHeader media/kunena/email/ userStatus 0 signature 0 personal 0 social 0 plainEmail 0 moderatorPermDelete 0 avatarTypes gif,jpeg,jpg,png smartLinking 0 defaultAvatar defaultAvatarSmall s_ quickReply 0 avatarEdit 0 activeMenuItem mainMenuId homeId indexId moderatorsId topicListId miscId profileId searchId custom_id avatarType 1 sefRedirect 1 allowEditPoll 1 useSystemEmails 0 autoEmbedInstagram 0 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 0 board_title Forum-concours board_offline 0 offline_message Le forum est temporairement fermé pour des opérations de maintenance nécessaire. L’équipe vous remercie pour votre patience et s’applique à vous rendre le forum le plus rapidement possible.
RDV en fin de soiréeenablerss 0 threads_per_page 20 messages_per_page 6 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 0 reportmsg 1 askemail 0 showemail 0 showuserstats 1 showkarma 0 useredit 1 useredittime 0 useredittimegrace 600 editmarkup 1 allowsubscriptions 0 subscriptionschecked 0 allowfavorites 0 maxsubject 50 maxsig 300 regonly 0 pubwrite 0 floodprotection 0 mailmod 0 mailadmin 0 mailfull 0 allowavatarupload 1 allowavatargallery 0 avatarquality 75 avatarsize 2048 imageheight 800 imagewidth 800 imagesize 300 filetypes txt,rtf,pdf,zip,,tgz, filesize 2000 showranking 1 rankimages 1 userlist_rows 30 userlist_online 1 userlist_avatar 1 userlist_posts 0 userlist_karma 0 userlist_email 0 userlist_joindate 0 userlist_lastvisitdate 0 userlist_userhits 0 latestcategory 0 showstats 0 showwhoisonline 0 showgenstats 0 showpopuserstats 1 popusercount 20 showpopsubjectstats 0 popsubjectcount 5 showspoilertag 1 showvideotag 1 showebaytag 0 trimlongurls 1 trimlongurlsfront 40 trimlongurlsback 20 autoembedyoutube 1 autoembedebay 0 ebaylanguagecode en-us sessiontimeout 172800 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 0 polltimebtvotes 00:15:00 pollnbvotesbyuser 2 pollresultsuserslist 1 allow_user_edit_poll 0 maxpersotext 50 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 1 showthankyou 1 showpopthankyoustats 0 popthankscount 5 mod_see_deleted 0 bbcode_img_secure text listcat_show_moderators 0 show_list_time 720 show_session_type 0 show_session_starttime 0 userlist_allowed 0 userlist_count_users 1 enable_threaded_layouts 0 category_subscriptions post topic_subscriptions first pubprofile 0 thankyou_max 20 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 0 show_imgfiles_manage_profile 1 hold_newusers_posts 0 hold_guest_posts 0 attachment_limit 8 article_display intro send_emails 0 fallback_english 1 cache_time 900 ebay_affiliate_id iptracking 0 rss_feedburner_url autolink 0 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 180 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 0 emailheader /media/kunena/email/ user_status 1 plain_email 0 moderator_permdelete 0 avatartypes gif, jpeg, jpg, png smartlinking 0 defaultavatar defaultavatarsmall s_ 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 6LdBldUSAAAAABKWTeDDZeYHiin0MjMgwCEiE_a9 recaptcha_privatekey 6LdBldUSAAAAAEymTiRzv5E9EzOr3d-50Lhu1LlL recaptcha_theme white keywords 0 userkeywords 0 userlist_name 1 userlist_usertype 0 usernamechange 0 sefutf8 0 version_check 1 changename 0 | Joomla! detailed language files installed:Warning: Spoiler!Kunena - Finder Disabled
Kunena - AltaUserPoints Disabled
Kunena - Community Builder Disabled
Kunena - Easyblog Disabled
Kunena - Easyprofile Disabled
Kunena - Easysocial Enabled: login=0 activity=1 avatar=1 profile=1 private=1 activity_badge_limit=0 activity_points_limit=0
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=1
Kunena - Kunena Enabled: avatar=0 profile=0
Warning: Spoiler!
Joomla! languages installed: fr-FR French (fr-FR) en-GB English (United Kingdom)
Third-party components: None
Third-party SEF components: None
Plugins: Content - Kunena Discuss 6.0.2-DEV
Modules: Kunena Latest 6.0.2
Please Log in or Create an account to join the conversation.
11 months 2 weeks ago #5
by rich
Replied by rich on topic have wrong collation of type utf8mb3_general_ci
I have now installed Admintools and saw that the function for adjust the collation is only available for Joomla 3.x versions. So you should have done it before the upgrade.
It can be done with phpMyAdmin, but if you don't know this software, you shouldn't try it on your live page.
.
It can be done with phpMyAdmin, but if you don't know this software, you shouldn't try it on your live page.
.
As I had already written, check the statistics settings in the configuration (tab Extra). According to your configuration report, some statistics are disabled.I was looking to know the most active members to reward them (those who post the most) I didn't know that the statistics didn't work anymore, I thought it was on site that didn't work anymore. (I started with Joomla 1.5 so there is old stuff in my site)
Please Log in or Create an account to join the conversation.
11 months 1 week ago #6
by adriendf
Replied by adriendf on topic have wrong collation of type utf8mb3_general_ci
thx for your answer
Please Log in or Create an account to join the conversation.
Time to create page: 0.715 seconds