×
Kunena 5.2.4 and Blue eagle 1.6.4 released (04 Apr 2021)

The Kunena team has announce the arrival of Kunena 5.2.4 [K 5.2.4] 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.2 and issues discovered during the development stages of K 5.2.4

REQUIREMENTS
Blue Eagle 1.6.x requires Kunena 5.2.x to work with, this template isn't designed to works with Bootstrap 4.

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

More
1 year 3 months 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
1 year 3 months 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
1 year 3 months ago - 1 year 3 months 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: 1 year 3 months ago by mbistato.

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

More
1 year 3 months 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
1 year 3 months 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
1 year 3 months ago - 1 year 3 months 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: 1 year 3 months ago by rich.

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

More
1 year 3 months ago - 1 year 3 months ago #7 by mbistato
Yes, I do.

Configuration report attached.

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

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

More
1 year 3 months 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
1 year 3 months ago - 1 year 3 months ago #9 by xillibit

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: 1 year 3 months ago by xillibit.

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

More
1 year 3 months 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.346 seconds