Solved Illegal mix of collations (latin2_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)

hi

Database collation check: 3jos_kunena_aliases have wrong collation of type latin2_general_ci on field alias 3jos_kunena_aliases have wrong collation of type latin2_general_ci on field type 3jos_kunena_aliases have wrong collation of type latin2_general_ci on field item 3jos_kunena_announcement have wrong collation of type latin2_general_ci on field title 3jos_kunena_announcement have wrong collation of type latin2_general_ci on field sdescription 3jos_kunena_announcement have wrong collation of type latin2_general_ci on field description 3jos_kunena_attachments have wrong collation of type latin2_general_ci on field hash 3jos_kunena_attachments have wrong collation of type latin2_general_ci on field folder 3jos_kunena_attachments have wrong collation of type latin2_general_ci on field filetype 3jos_kunena_attachments have wrong collation of type latin2_general_ci on field filename 3jos_kunena_attachments have wrong collation of type latin2_general_ci on field filename_real 3jos_kunena_attachments have wrong collation of type latin2_general_ci on field caption 3jos_kunena_categories have wrong collation of type latin2_general_ci on field name 3jos_kunena_categories have wrong collation of type latin2_general_ci on field alias 3jos_kunena_categories have wrong collation of type latin2_general_ci on field icon 3jos_kunena_categories have wrong collation of type latin2_general_ci on field accesstype 3jos_kunena_categories have wrong collation of type latin2_general_ci on field channels 3jos_kunena_categories have wrong collation of type latin2_general_ci on field description 3jos_kunena_categories have wrong collation of type latin2_general_ci on field headerdesc 3jos_kunena_categories have wrong collation of type latin2_general_ci on field class_sfx 3jos_kunena_categories have wrong collation of type latin2_general_ci on field topic_ordering 3jos_kunena_categories have wrong collation of type latin2_general_ci on field iconset 3jos_kunena_categories have wrong collation of type latin2_general_ci on field params 3jos_kunena_configuration have wrong collation of type latin2_general_ci on field params 3jos_kunena_keywords have wrong collation of type latin2_general_ci on field name 3jos_kunena_messages have wrong collation of type latin2_general_ci on field name 3jos_kunena_messages have wrong collation of type latin2_general_ci on field email 3jos_kunena_messages have wrong collation of type latin2_general_ci on field subject 3jos_kunena_messages have wrong collation of type latin2_general_ci on field ip 3jos_kunena_messages have wrong collation of type latin2_general_ci on field modified_reason 3jos_kunena_messages_text have wrong collation of type latin2_general_ci on field message 3jos_kunena_polls have wrong collation of type latin2_general_ci on field title 3jos_kunena_polls_options have wrong collation of type latin2_general_ci on field text 3jos_kunena_ranks have wrong collation of type latin2_general_ci on field rank_title 3jos_kunena_ranks have wrong collation of type latin2_general_ci on field rank_image 3jos_kunena_sessions have wrong collation of type latin2_general_ci on field allowed 3jos_kunena_sessions have wrong collation of type latin2_general_ci on field readtopics 3jos_kunena_smileys have wrong collation of type latin2_general_ci on field code 3jos_kunena_smileys have wrong collation of type latin2_general_ci on field location 3jos_kunena_smileys have wrong collation of type latin2_general_ci on field greylocation 3jos_kunena_topics have wrong collation of type latin2_general_ci on field subject 3jos_kunena_topics have wrong collation of type latin2_general_ci on field first_post_message 3jos_kunena_topics have wrong collation of type latin2_general_ci on field first_post_guest_name 3jos_kunena_topics have wrong collation of type latin2_general_ci on field last_post_message 3jos_kunena_topics have wrong collation of type latin2_general_ci on field last_post_guest_name 3jos_kunena_topics have wrong collation of type latin2_general_ci on field params 3jos_kunena_user_categories have wrong collation of type latin2_general_ci on field params 3jos_kunena_user_topics have wrong collation of type latin2_general_ci on field params 3jos_kunena_users have wrong collation of type latin2_general_ci on field status_text 3jos_kunena_users have wrong collation of type latin2_general_ci on field view 3jos_kunena_users have wrong collation of type latin2_general_ci on field signature 3jos_kunena_users have wrong collation of type latin2_general_ci on field avatar 3jos_kunena_users have wrong collation of type latin2_general_ci on field personalText 3jos_kunena_users have wrong collation of type latin2_general_ci on field location 3jos_kunena_users have wrong collation of type latin2_general_ci on field icq 3jos_kunena_users have wrong collation of type latin2_general_ci on field aim 3jos_kunena_users have wrong collation of type latin2_general_ci on field yim 3jos_kunena_users have wrong collation of type latin2_general_ci on field msn 3jos_kunena_users have wrong collation of type latin2_general_ci on field skype 3jos_kunena_users have wrong collation of type latin2_general_ci on field twitter 3jos_kunena_users have wrong collation of type latin2_general_ci on field facebook 3jos_kunena_users have wrong collation of type latin2_general_ci on field gtalk 3jos_kunena_users have wrong collation of type latin2_general_ci on field myspace 3jos_kunena_users have wrong collation of type latin2_general_ci on field linkedin 3jos_kunena_users have wrong collation of type latin2_general_ci on field delicious 3jos_kunena_users have wrong collation of type latin2_general_ci on field friendfeed 3jos_kunena_users have wrong collation of type latin2_general_ci on field digg 3jos_kunena_users have wrong collation of type latin2_general_ci on field blogspot 3jos_kunena_users have wrong collation of type latin2_general_ci on field flickr 3jos_kunena_users have wrong collation of type latin2_general_ci on field bebo 3jos_kunena_users have wrong collation of type latin2_general_ci on field websitename 3jos_kunena_users have wrong collation of type latin2_general_ci on field websiteurl 3jos_kunena_users_banned have wrong collation of type latin2_general_ci on field ip 3jos_kunena_users_banned have wrong collation of type latin2_general_ci on field reason_private 3jos_kunena_users_banned have wrong collation of type latin2_general_ci on field reason_public 3jos_kunena_users_banned have wrong collation of type latin2_general_ci on field comments 3jos_kunena_users_banned have wrong collation of type latin2_general_ci on field params 3jos_kunena_version have wrong collation of type latin2_general_ci on field version 3jos_kunena_version have wrong collation of type latin2_general_ci on field build 3jos_kunena_version have wrong collation of type latin2_general_ci on field versionname 3jos_kunena_version have wrong collation of type latin2_general_ci on field state

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

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 150 seconds | Max execution memory: 128M | Max file upload: 128M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path	In trash
406	Forum dyskusyjne	mainmenu	view=topics&mode=topics	forum-elk	No
478	Napisz na forum	mainmenu	view=topic&layout=create	forum-elk/forum-elczanie-dodaj-post	No
780	Kategorie forum	mainmenu	view=category&layout=list&catid=0	forum-elk/forum-miasto-elk-kategorie	No
777	Najnowsze posty	mainmenu	view=topics&mode=topics	forum-elk/infoserwis-elk	Yes
1107	napisz post	mainmenu	view=topic&layout=create	forum-elk/napisz-post	Yes
888	Rozpocznij dyskusję	top-menu	view=topic&layout=create	rozpocznij-dyskusje	No
778	Moje posty na forum	top-menu	view=topics&layout=user&mode=posted&modetype=	moje-posty	No
1108	Forum	kunenamenu	view=home&defaultmenu=1110	forum	No
1109	Kategorie	kunenamenu	view=category&layout=list	forum/kategorie	No
1110	Ostatnie tematy	kunenamenu	view=topics&mode=replies	forum/ostatnie	No
1111	Nowy temat	kunenamenu	view=topic&layout=create	forum/nowy-temat	No
1112	Bez odpowiedzi	kunenamenu	view=topics&mode=noreplies	forum/bez-odpowiedzi	No
1113	Moje tematy	kunenamenu	view=topics&layout=user&mode=default	forum/moje-najnowsze	No
1114	Profil	kunenamenu	view=user	forum/profil	No
1115	Pomoc	kunenamenu	view=misc	forum/pomoc	No
1116	Szukaj	kunenamenu	view=search	forum/szukaj	No
1117	Forum	mainmenu	Itemid=1108	kunena-2015-09-12	Yes

Joomla default template details : protostar | author: Kyle Ledbetter | version: 1.0 | creationdate: Unknown

Kunena default template details : Crypsis | author: Kunena Team | version: 4.0.5 | creationdate: 2015-08-17

Kunena version detailed: Kunena 4.0.5 | 2015-08-17 [ Turnau ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	0
threads_per_page	20
messages_per_page	6
messages_per_page_search	15
showhistory	0
historylimit	6
shownew	1
disemoticons	0
template	crypsis
showannouncement	0
avataroncat	1
catimagepath	category_images/
showchildcaticon	0
rtewidth	450
rteheight	300
enableforumjump	0
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	0
showkarma	1
useredit	1
useredittime	360
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	0
allowfavorites	1
maxsubject	70
maxsig	300
regonly	0
pubwrite	1
floodprotection	60
mailmod	-1
mailadmin	1
captcha	1
mailfull	0
allowavatarupload	1
allowavatargallery	0
avatarquality	85
avatarsize	2048
imageheight	2400
imagewidth	2048
imagesize	550
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2,jpg,jpeg,gif,png
filesize	520
showranking	0
rankimages	0
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_joindate	0
userlist_lastvisitdate	0
userlist_userhits	1
latestcategory	0
showstats	0
showwhoisonline	0
showgenstats	0
showpopuserstats	0
popusercount	5
showpopsubjectstats	0
popsubjectcount	5
showspoilertag	0
showvideotag	1
showebaytag	0
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
sessiontimeout	1800
highlightcode	1
rss_type	post
rss_timelimit	year
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	100
rss_old_titles	1
rss_cache	900
defaultpage	recent
default_sort	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
maxpersotext	100
ordering_system	replyid
post_dateformat	ago
post_dateformat_hover	ago
hide_ip	1
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	130
thumbwidth	130
hideuserprofileinfo	put_empty
boxghostmessage	0
userdeletetmessage	1
latestcategory_in	1
topicicons	0
debug	0
catsautosubscribed	0
showbannedreason	1
showthankyou	1
showpopthankyoustats	0
popthankscount	5
mod_see_deleted	1
bbcode_img_secure	text
listcat_show_moderators	0
lightbox	0
show_list_time	8760
show_session_type	0
show_session_starttime	0
userlist_allowed	0
userlist_count_users	0
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	1
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
captcha_post_limit	0
keywords	0
userkeywords	0
image_upload	everybody
file_upload	everybody
topic_layout	flat
time_to_create_page	0
show_imgfiles_manage_profile	1
hold_newusers_posts	0
hold_guest_posts	0
attachment_limit	6
pickup_category	1
article_display	link
send_emails	1
fallback_english	0
cache	0
cache_time	60
iptracking	1
rss_feedburner_url
autolink	1
access_component	0
statslink_allowed	0
superadmin_userlist	0
legacy_urls	1
attachment_protection	0
categoryicons	1
avatarresizemethod	1
avatarcrop	0
user_report	1
searchtime	365
teaser	0
ebay_language	212
twitter_consumer_key
twitter_consumer_secret
max_links	6
userlist_name	0
usernamechange	1
version_check	1
userlist_usertype	0
sefutf8	0
enablepdf	0
jmambot	1
annmodid	67
changename	0
userlist_username	1
rules_infb	1
help_infb	1
onlineusers	1
credits	0

| Kunena integration settings:

Warning: Spoiler!

Kunena - AlphaUserPoints Disabled
Kunena - Community Builder 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:
en-GB	English (en-GB)
pl-PL	Polish (PL)

Third-party components: CommunityBuilder 2.0.10

Third-party SEF components: None

Plugins: Search - Kunena Search 3.1.0 | Content - Kunena Discuss 3.1.0

Modules: Kunena Latest 3.1.1

I have problem because I dont know so much about phpmyadmin and mysql. I hope get answer here.

How shoud I type a query to phpmyadmin, to get good all collation of table?

The best way to change it, is by installing admin tools from akeeba, there you have a button that's fixing that problem for you.

Big thx!!! ))

I fixed it by Admin Tools

Not really a question specifically about K 4.0 —this question can apply to any version of Kunena —but it's useful to know the answer. Thanks, 810.