Kunena 7.0.9 & Kunena 6.4.14 – Security Updates Released

The Kunena team has announce the arrival of Kunena 7.0.9 [K 7.0.9] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x./6.1.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

This category is only for reporting defects or problems with Kunena 1.6 test versions with Joomla 1.6. This is NOT a support forum - there is no support for test versions. Users should NOT install K 1.6 alpha or beta test versions on websites with live production data.

Question Upload images/files results in MySQL error

More
15 years 7 months ago #83651 by Feemac

I've recently installed Kunena 1.6.2 on Joomla 1.6. When I use the upload file features in the forum I receive the below error message. Images (png, gif, jpg) do upload successfully (but still get the error:500 page), but other documents (doc, pdf) are 'not found'. How can I resolve this?

JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), 1, 0 ) AS admin FROM jos_users AS u LEFT JOIN jos_kunena_users AS p' at line 4 SQL=SELECT u.id, u.name, u.username, u.email, IF( (s.thread IS NOT NULL) OR (sc.catid IS NOT NULL), 1, 0 ) AS subscription, IF( c.moderated=1 AND p.moderator=1 AND ( m.catid IS NULL OR m.catid=7), 1, 0 ) AS moderator, IF( u.id IN (), 1, 0 ) AS admin FROM jos_users AS u LEFT JOIN jos_kunena_users AS p ON u.id=p.userid LEFT JOIN jos_kunena_categories AS c ON c.id=7 LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid AND m.catid=c.id LEFT JOIN jos_kunena_subscriptions AS s ON u.id=s.userid AND s.thread=4 LEFT JOIN jos_kunena_subscriptions_categories AS sc ON u.id=sc.userid AND sc.catid=c.id WHERE u.block=0 AND u.id NOT IN (42) AND ( ( ( (s.thread IS NOT NULL) OR (sc.catid IS NOT NULL) ) ) ) GROUP BY u.id

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

More
15 years 7 months ago #83654 by sozzled
Thank you for your report. See our replies to your earlier question: "Report Configuration Settings" not working

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

More
15 years 7 months ago #84145 by xillibit
Hello,

please use Kunena 1.6.3 with Joomla! 1.6

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.324 seconds