Solved Error in msqli.php file: Unknown column 'undefined' in 'where clause'

Hi there,

I installed the 5.1.15 Kunena version on Joomla 3.9.10 and I got the error
as I try to upload any attachment. The result is that the file is not attached.

Does anyone know how to fix it?


Thank you.

I think it's an upgrade not a new installation (I'm right?). Have you tried to insert an emoji? Please check the database collation, it should be utf8mb4_general_ci.
If not, you can adjust it with the Admin Tools (it needs only one click) to change it to UTF-8 multibyte.
Important! Make a database backup before you change somethings in the database.

Hi rich and thank you for your response.

Yes, it is an upgrade and the database collocation is utf8mb4_general_ci. I can also insert emoticons.

I did exactly what you suggested by using the Admin tool, but the collocation didn't change. Plus I've noticed that the "UTF-8 multibyte" is not listed as the attachment shows

Hello,
Can-you start by updating to Joomla! 3.9.14 ?

Before installing Kunena 5.1.15, which Kunena version you had ?

The utf8mb4_general_ci support is present since MySQL 5.5.3 so which MySQL version do-you have ?

Hi,
I updated Joomla but still I can't see the option "UTF-8 multibyte" in the collocation dropdown menu in phpmyadmin.
The previous version of kunena was 4.0.6
Did you mean that the "UTF-8 multibyte" is supported since MySQL 5.5.? Anyway, I know that my host has installed the version 5.5 but I don't know what exactly is. Where can I find this info?

Did you mean that the "UTF-8 multibyte" is supported since MySQL 5.5.? Anyway, I know that my host has installed the version 5.5 but I don't know what exactly is. Where can I find this info?

Don't be irritated, if you use the Admin Tools. With the option multibyte it changes the tables to utf8mb4_general_ci.

You get this error only if you want upload attachments?
Please add a configuration report: docs.kunena.org/en/faq/configuration-report

Yes, I do.

Configuration report attached.

Also, my host just said that all of the utf8 collocation options with "mb4" suffix are multibyte.

mbistato wrote: Hi,
I updated Joomla but still I can't see the option "UTF-8 multibyte" in the collocation dropdown menu in phpmyadmin.
The previous version of kunena was 4.0.6
Did you mean that the "UTF-8 multibyte" is supported since MySQL 5.5.? Anyway, I know that my host has installed the version 5.5 but I don't know what exactly is. Where can I find this info?

From the MySQL doc utf8_mb4 is supported since MySQL 5.5.3 but in your report you have the 5.5.5 version

Can-you please give the results the two following query, your need to paste it one by one in tab SQL under phpmyadmin and run it :

The two results are attached.

Thank you.