Solved 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.

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 ?

Hi xillibit,

here you go



Thank you once again.

Hello,

When i connect to your FTP account, it just goes to an empty but not to the website directory. And in the same is it possible to have an account to you forum ? like that i can try in the same time

xillibit wrote: Hello,

When i connect to your FTP account, it just goes to an empty but not to the website directory. And in the same is it possible to have an account to you forum ? like that i can try in the same time

I fixed the issue so you can now access via FTP.
To create an account on my forum I need your email address.

Thanks

www.kunena.org/team

Account created.

mbistato wrote:

xillibit wrote: Hello,

When i connect to your FTP account, it just goes to an empty but not to the website directory. And in the same is it possible to have an account to you forum ? like that i can try in the same time

I fixed the issue so you can now access via FTP.
To create an account on my forum I need your email address.

Thanks

Hello,

I have just tried to connect to your FTP by it goes not at root of Joomla! directory but at an another place

Hi,

I'm very sorry but I've just realised that the directory path was wrong so I sorted it out. Now it should be ok.
Let me know if not.

Thanks.

Hello,

It fails when submit on this query :

but at this first place it fails because it doesn't get the file size of uploaded file, the file seems to be uploaded in /tmp/uploads with right in 644 but no size is returned. So it could be the default right of file aren't enough, then nothing is moved under media/kunena/attachments/userid, the no id are returned for attachment and it fails at the end with the query above