×
Kunena 5.1.18 Released (30 Jun 2020)

The Kunena team has announce the arrival of Kunena 5.1.18 [K 5.1.18] which is now available for download as a native Joomla extension for J! 3.9.x. This version addresses most of the issues that were discovered in K 5.1 and issues discovered during the development stages of K 5.1.

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

More
6 months 2 weeks ago #1 by mbistato
Hi there,

I installed the 5.1.15 Kunena version on Joomla 3.9.10 and I got the error
Exception throw at line 665 in file /home/usivunqc/public_html/libraries/joomla/database/driver/mysqli.php with message Unknown column 'undefined' in 'where clause'

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.

Please Log in or Create an account to join the conversation.

More
6 months 2 weeks ago #2 by rich
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.

Please Log in or Create an account to join the conversation.

More
6 months 2 weeks ago - 6 months 2 weeks ago #3 by mbistato
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
Attachments:
Last edit: 6 months 2 weeks ago by mbistato.

Please Log in or Create an account to join the conversation.

More
6 months 1 week ago #4 by xillibit
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 ?

I don't provide support by PM, because this can be useful for someone else.

Please Log in or Create an account to join the conversation.

More
6 months 1 week ago #5 by mbistato
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?

Please Log in or Create an account to join the conversation.

More
6 months 1 week ago - 6 months 1 week ago #6 by rich

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
Last edit: 6 months 1 week ago by rich.

Please Log in or Create an account to join the conversation.

More
6 months 1 week ago - 6 months 1 week ago #7 by mbistato
Yes, I do.

Configuration report attached.

This message contains confidential information
Last edit: 6 months 1 week ago by rich. Reason: Configuration text file removed

Please Log in or Create an account to join the conversation.

More
6 months 1 week ago #8 by mbistato
Also, my host just said that all of the utf8 collocation options with "mb4" suffix are multibyte.

Please Log in or Create an account to join the conversation.

More
6 months 1 week ago - 6 months 1 week ago #9 by xillibit

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 :
show variables like "%coll%";
show variables like "%char%";

I don't provide support by PM, because this can be useful for someone else.
Last edit: 6 months 1 week ago by xillibit.

Please Log in or Create an account to join the conversation.

More
6 months 1 week ago #10 by mbistato
The two results are attached.

Thank you.
Attachments:
The following user(s) said Thank You: Maxim Pishnyak

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.500 seconds