Question ERR ID:36731 & ERR ID: 36728

Hello Folks,
I'm way out of my depth here so I'm asking: Is this a bug in Kunena? I'm running Kunena 5.1.29 in Joomla 3.9.23.

"Exception throw at line 665 in file \/home\/kzride5\/public_html\/libraries\/joomla\/database\/driver\/mysqli.php with message You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1"

"Exception throw at line 665 in file \/home\/kzride5\/public_html\/libraries\/joomla\/database\/driver\/mysqli.php with message Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='"

Thank you

Just realized that those ID numbers are mine not Kunena's. 37K errors. I've got some work to do.
Bill

I checked the character set it's set to UTf-8 multibyte. I actually tried to reset it to UTF-8 multibyte and crashed the database. After I restored the database I used Admin tools to repair and optomize the tables. However I'm still getting the same error in the logs. Somehow this error is also related to some strange notifications about topic subscriptions that, according to Kunena, do not exist.
Any help will be greatly appreciated.
Bill

Here's my configuration report:

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

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path	In trash
161	Profile	mainmenu	view=user	profile	No
329	Forum	kunenamenu	view=home&defaultmenu=329	forum	No
330	Index of Forums	kunenamenu	view=home&defaultmenu=330	forum/forum-index	No
331	Recent Topics	kunenamenu	view=topics&mode=replies	forum/recent	No
332	New Topic	kunenamenu	view=topic&layout=create	forum/newtopic	No
333	No Replies	kunenamenu	view=topics&mode=noreplies	forum/noreplies	No
334	My Topics	kunenamenu	view=topics&layout=user&mode=default	forum/mylatest	No
335	Profile	kunenamenu	view=user	forum/profile	No
162	Help	kunenamenu	view=misc	forum/help	No
336	Search	kunenamenu	view=search	forum/search	No

Joomla default template details : js_wylia2 | author: Joomlashack | version: 2.2.17 | creationdate: November 26 2020

Kunena default template details : Blue Eagle5 | author: Kunena Team | version: 1.5.2 | creationdate: 2018-12-11

Kunena template params:

Warning: Spoiler!

DefaultCategoryicon
profileIconset	default
DefaultIconset	default
editorIconset	default
bootstrap	0
icomoon	1
tooltips	1
borderless	1
SubjectLengthMessage	80
fullactions	1
quick	0
displayMenu	1
displayDropdownMenu	1
displayDropdownContent	1
displayModule	1
displayBreadcrumb	1
displayAnnouncement	1
displayFooter	1
avatarPosition	left
avatarType	none
labels	0
whoisonlineName	default
formRecover	0
topicicontype	image
fontawesome	0
socialshare	0
socialsharetag
socialtheme	classic
optional_username	0
writeaccess	0
localstorage	0
IconColor	inherit
IconColorNew	#48a348
forumHeadercolor
announcementHeadercolor
announcementBoxbgcolor
frontstatsHeadercolor
whoisonlineHeadercolor
inactiveTabcolor
activeTabcolor
hoverTabcolor
topBordercolor
inactiveFontcolor
activeFontcolor
forumLinkcolor
enableSkinner	0
editor	0
video	1
maps	1
emoticons	1
twitter	1
ebay	1
link	1
picture	1
hide	1
spoiler	1
table	1
code	1
quote	1
divider	1
instagram	1
soundcloud	1
confidential	1
hr	1
listitem	1
supscript	1
subscript	1
numericlist	1
bulletedlist	1
alignright	1
alignleft	1
center	1
underline	1
italic	1
bold	1
strikethrough	1
colors	1
size	1
wysibb	bold,italic,underline,strike,sup,sub,justifyleft,justifycenter,justifyright,|,img,video,link,|,bullist,numlist,|,fontcolor,fontsize,fontfamily,|,quote,code,table,removeFormat
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 5.1.19 | 2020-08-15 [ Tethys ]
        | Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	0
threads_per_page	20
messages_per_page	12
messages_per_page_search	10
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	blue_eagle5
showannouncement	0
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
rtewidth	475
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	0
useredit	1
useredittime	86400
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	0
allowfavorites	1
maxsubject	50
maxsig	300
regonly	0
pubwrite	0
floodprotection	0
mailmod	-1
mailadmin	-1
captcha	1
mailfull	1
allowavatarupload	1
allowavatargallery	0
avatarquality	100
avatarsize	2048
imageheight	1200
imagewidth	2400
imagesize	2048
filetypes	wmv,avi,mpg,mov,zip,txt,doc,xls,gz,tgz,pdf
filesize	10240
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	2,3,4,5,6,21,8,10,11,13,17,15,25,14,23,24
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	3600
highlightcode	0
rss_type	post
rss_timelimit	month
rss_limit	100
rss_included_categories
rss_excluded_categories	9,16,19,20
rss_specification	atom1.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	1
rss_word_count	0
rss_old_titles	0
rss_cache	900
defaultpage	categories
default_sort	asc
sef	1
showimgforguest	1
showfileforguest	1
pollnboptions	12
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
allow_user_edit_poll	0
maxpersotext	50
ordering_system	mesid
post_dateformat	datetime_today
post_dateformat_hover	datetime
hide_ip	0
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	80
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	1
bbcode_img_secure	image
listcat_show_moderators	0
lightbox	1
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	topic
topic_subscriptions	first
pubprofile	0
thankyou_max	8
email_recipient_count	0
email_recipient_privacy	bcc
captcha_post_limit	5
image_upload	registered
file_upload	registered
topic_layout	flat
time_to_create_page	0
show_imgfiles_manage_profile	1
hold_newusers_posts	2
hold_guest_posts	0
attachment_limit	20
pickup_category	1
article_display	intro
send_emails	1
fallback_english	1
cache	1
cache_time	60
iptracking	1
rss_feedburner_url
autolink	1
access_component	0
statslink_allowed	1
superadmin_userlist	0
legacy_urls	1
attachment_protection	1
categoryicons	1
avatarresizemethod	1
avatarcrop	0
user_report	1
searchtime	all
teaser	0
ebay_language	0
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
attachment_utf8	1
autoembedsoundcloud	1
emailheader	/media/kunena/email/hero-wide.png
user_status	1
signature	1
personal	1
social	0
plain_email	0
moderator_permdelete	0
avatartypes	gif, jpeg, jpg, png
smartlinking	0
defaultavatar	nophoto.png
defaultavatarsmall	s_nophoto.png
quickreply	0
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
email_sender_name
display_filename_attachment	0
recaptcha_publickey	6LdhnwwUAAAAAHDr2zhIwnhf8XOViU1StCm5UyMa
recaptcha_privatekey	6LdhnwwUAAAAAHwwkuUrxZ6RYoob_crxPmfSY1lP
recaptcha_theme	blackglass
keywords	0
userkeywords	0
userlist_name	0
usernamechange	0
version_check	1
userlist_usertype	0
sefutf8	0
enablepdf	1
jmambot	1
annmodid	62
changename	0
userlist_username	1
rules_infb	1
help_infb	0
onlineusers	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 Enabled:  private=1  

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:
en-GB	English (United Kingdom)

Third-party components: UddeIM 4.0

Third-party SEF components: None

Plugins: None

Modules: None

I checked the character set it's set to UTf-8 multibyte. I actually tried to reset it to UTF-8 multibyte and crashed the database. After I restored the database I used Admin tools to repair and optomize the tables

I'm sorry, but I don't understand this correctly. You have reset to UTF-8 multibyte, but this crashes the database. 
Then you have restored and optimized your database. Which collation has this database now?

"Exception throw at line 665 in file \/home\/kzride5\/public_html\/libraries\/joomla\/database\/driver\/mysqli.php with message You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1"

This error can occur, such as when users add emojis in the messages and the collation is'nt correctly in the table #__kuena_messages_text. But it is not enough if you change the table collation only. The collation must be also changed for the columns in the tables.

Have you read this topic?