Hi

saving and publishing K2 items I get this error in backend:

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=UPDATE `zacw3_finder_taxonomy_map` SET `link_id`='2',`node_id`='5' WHERE


can you help me to fix this?

Thanks

Hello,

Update Joomla!, K2 and make sure your DB structure is up to date.

It is J! 2.5.9 with K2 2.6.6 and I've just done some db maintenance and optimization

Please, other suggestion to fix the issue?

Maybe you should restore a backup, maybe the db maintenance and optimization caused this.

I think this caused from com_finder though not 100% sure though.

I already restored the db table from a clean new installation.
:(

After restored the finder_taxonomy_map table, I get new warning:

Duplicate entry '13-1' for key 'PRIMARY' SQL=INSERT INTO `zacw3_finder_links_termsd` (`link_id`, `term_id`, `weight`) SELECT 13, `term_id`, ROUND(SUM(`context_weight`), 8) FROM `zacw3_finder_tokens_aggregate` WHERE `map_suffix` = 'd' GROUP BY `term` ORDER BY `term` DESC

Hmm, If you can log into the admin try to clear all finder and smart finder terms. (be sure to delete them from the trash as well).

If that doesn't resolve the issue you might want to look for professional assistance or restore a full backup of your db.

Hello!

It's a clash between J2.5 default smart search plugin and K2 smart search plugin respectively.

I've stumbled upon the same problem but the simplest and fastest way to get rid of this issue is to disable default J2.5 'Content - Smart Search' plugin (I reckon You'll b using K2 for publishing articles etc.).

I'm sorry I can't do better at the moment but I'm also new to J2.5 and am still working out all the quirks. If I find a better solution I'll let u know soon enough.

P.S.
Would also b nice if You were to opt Your DB tables and so forth. Especially if You were doing a migration from a previous version of Joomla. Might b u have some 'cracked' tables or entries that've misbehaved. Try turning on Joomla error reporting and debug and see what they have to say about it.

My K2 have An 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 '' at line 1 SQL=UPDATE `xxx_finder_taxonomy_map` SET `link_id`='26',`node_id`='3' WHERE

But no have error when creating new joomla article.

I am using K2 ver 2.6.7 and joomla 3.1.1

my solution is empty xxx_finder_taxonomy_map table :)