Question K1.6.2, J1.6.0 Error Message when posting.

Hi there,

I have migrated my forum onto a vanilla copy of Joomla 1.6.0, and as Kunena wipes your forums when you upgrade (it was 1.6.1 on J1.5.22 and its now 1.6.2 on J1.6.0 i copied the majority of the tables over (users, posts, categories etc), and all is good in the world.

When i make a new post (in debug mode), i get the following errors message:

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 j16_users AS u LEFT JOIN j16_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=3), 1, 0 ) AS moderator, IF( u.id IN (), 1, 0 ) AS admin FROM j16_users AS u LEFT JOIN j16_kunena_users AS p ON u.id=p.userid LEFT JOIN j16_kunena_categories AS c ON c.id=3 LEFT JOIN j16_kunena_moderation AS m ON u.id=m.userid AND m.catid=c.id LEFT JOIN j16_kunena_subscriptions AS s ON u.id=s.userid AND s.thread=21336 LEFT JOIN j16_kunena_subscriptions_categories AS sc ON u.id=sc.userid AND sc.catid=c.id WHERE u.block=0 AND u.id NOT IN (62) AND ( ( ( (s.thread IS NOT NULL) OR (sc.catid IS NOT NULL) ) ) ) GROUP BY u.id

Should my master Database settings be set to MYSQL or MYSQLi? or does this not make a difference? for reference, its set to mySQL, and PHP is version 5.

When i click "report configuration settings" i get a white page with the menu across the top written with no CSS on the page

Hello,

Kuena 1.6.2 can be installed under Joomla! 1.6 but there are some issues, like this one which prevent to use kunena under Joomla! 1.6

Hi there,

Thanks for the reply, one also thing that i should report is when users are trying to log in using the default Kunena login panel at the top it says username/password incorrect, so i have bypassed this for now by using the Community builder login form (kunena is set in the control panel to use my community builder 1.3.1 users).

Even though i get the error message above, the message still posts to the forum, so im guessing its just a minor error of some sort. Il be looking forward to seeing the next release of kunena which will hopefully be stable with Joomla 1.6.0. Is there any ETA on this or is it just when its done?

Thanks

Colin

PLEASE fix this error! I integrated the forum into my site and spent hours configuring the template and then tried posting and I get the same error. This is an error in the SQL syntax i think, which should be able to be corrected easily yes?

Would installing K1.6.0 fix this?

You need to wait the release of K1.6.3 or downgrade to Joomla 1.5.22

is the process of downgrading joomla hard? im sure it will cause my templates to get mangled wont it? how long until K1.6.2?