Joomla 3.0 with K2 2.6.6 on Linux
Upgraded to Joomla 3.1

Now when i try to add a new K2 item I get this:

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 ')}' at line 1 SQL=SELECT `catid` FROM jml_k2_additional_categories WHERE `itemID` = {intval()}

Tried reinstalling K2 but have not been able to get round the error.

Any suggestions please?

TIA
Duncan

Hello Duncan,

This table is from another component ,Additional Categories for K2. You can try downgrading until this issue is fixed.

I have a fix!!! :)

look for this line in plugins\k2\k2additonalcategories\k2additonalcategories.php
line: 278
$query = "SELECT `catid` FROM #__k2_additional_categories WHERE `itemID` = {intval($item->id)}";

replace for this snipet:

if (!empty($item) && !empty($item->id)) {
$query = "SELECT `catid` FROM #__k2_additional_categories WHERE `itemID` = {intval($item->id)}";
} else {
$query = "SELECT `catid` FROM #__k2_additional_categories WHERE 1";
}

this will fix the problem after save and create a new one.

hope it helps

Perfect it works, i had the same problem

ThankS !!

Hi can you help me solve this: I get, Error: 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 'ORDER BY content.created DESC' at line 25 SQL=SELECT content.id AS ID, cats.name AS cat_name, cats.alias AS cat_alias, content.catid AS cat_id, users.name AS author, users.email AS author_email, users.id AS author_id, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count FROM gg1qt_k2_items AS content LEFT JOIN gg1qt_k2_categories AS cats ON cats.id = content.catid LEFT JOIN gg1qt_users AS users ON users.id = content.created_by LEFT JOIN gg1qt_k2_rating AS content_rating ON content.id = content_rating.itemID WHERE ORDER BY content.created DESC

Please upgrade to the latest version of K2.
Also you can try repairing your database tables.

PS. Always backup before doing anything.

Hi, I have the latest K2 which is v2.6.7

Thanks

Have you tried reinstalling K2, or repairing your db's tables?

Yes the database is ok and I have k2 installed in the template i bought. Should I uninstall and reinstall again?

No do not uninstall, you will lose your content. Just reinstall on top.