Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

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

More
6 years 4 months ago - 6 years 4 months ago #211907 by mbistato
Replied by mbistato on topic Error in msqli.php file: Unknown column 'undefined' in 'where clause'
Yes, I do.

Configuration report attached.

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

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

More
6 years 4 months ago #211909 by mbistato
Replied by mbistato on topic Error in msqli.php file: Unknown column 'undefined' in 'where clause'
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 years 4 months ago - 6 years 4 months ago #211910 by xillibit
Replied by xillibit on topic Error in msqli.php file: Unknown column 'undefined' in 'where clause'

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 :
Code:
show variables like "%coll%";
Code:
show variables like "%char%";
I don't provide support by PM, because this can be useful for someone else.
Last edit: 6 years 4 months ago by xillibit.

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

More
6 years 4 months ago #211913 by mbistato
Replied by mbistato on topic Error in msqli.php file: Unknown column 'undefined' in 'where clause'
The two results are attached.

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

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

More
6 years 4 months ago #211914 by rich
Replied by rich on topic Error in msqli.php file: Unknown column 'undefined' in 'where clause'
I've now tested with Maria database MySQL version: 5.5.5-10.1.40 but can't to reproduce this error.
Important! Always create a backup before you make any changes to your website!

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

More
6 years 3 months ago #211940 by xillibit
Replied by xillibit on topic Error in msqli.php file: Unknown column 'undefined' in 'where clause'

mbistato wrote: Hi there,

I installed the 5.1.15 Kunena version on Joomla 3.9.10 and I got the error

Code:
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.

Hello,

I'am restarting from the begining, is-it possible please to have a FTP access to your site to try to figure which query is failing ? Or maybe you can set up a test site like that i can look on FTP ?
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.

Time to create page: 0.254 seconds