an error in your SQL syntax; ..finder_taxonomy_map

General questions relating to Joomla! 2.5. Note: All 1.6 and 1.7 releases have reached end of life and should be updated to 2.5. There are other boards for more specific help on Joomla! features and extensions.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Locked
User avatar
TheAnt
Joomla! Explorer
Joomla! Explorer
Posts: 397
Joined: Wed Aug 31, 2005 7:43 am
Location: Milano - Italy

an error in your SQL syntax; ..finder_taxonomy_map

Post by TheAnt » Fri Apr 19, 2013 8:51 am

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

mercancam
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Apr 24, 2013 2:04 pm

Re: an error in your SQL syntax; ..finder_taxonomy_map

Post by mercancam » Wed Apr 24, 2013 2:11 pm

I'm having the same problem.

Chrome also saves the article. All buttons are working.
Firefox does not save it. None of the buttons (Save, close, cancel) does not work.

Is there a solution to the problem?


Failed to save the specified error due to: 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`='143',`node_id`='3' WHERE

Failed to save the specified error due to: 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`='143',`node_id`='69' WHERE

User avatar
TheAnt
Joomla! Explorer
Joomla! Explorer
Posts: 397
Joined: Wed Aug 31, 2005 7:43 am
Location: Milano - Italy

Re: an error in your SQL syntax; ..finder_taxonomy_map

Post by TheAnt » Thu Apr 25, 2013 8:54 am

Please, no help about this issue?
Can I empty all the _finder tables?

diegoreina
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed May 01, 2013 5:47 pm

Re: an error in your SQL syntax; ..finder_taxonomy_map

Post by diegoreina » Wed May 01, 2013 5:54 pm

Hi

We have the same problem

Please help

Diego R

User avatar
TheAnt
Joomla! Explorer
Joomla! Explorer
Posts: 397
Joined: Wed Aug 31, 2005 7:43 am
Location: Milano - Italy

Re: an error in your SQL syntax; ..finder_taxonomy_map

Post by TheAnt » Wed May 01, 2013 6:07 pm

Try to empty Components / Smart search Indexed Content
It worked for me

User avatar
razor7
Joomla! Explorer
Joomla! Explorer
Posts: 358
Joined: Wed Aug 24, 2005 2:06 pm
Location: Argentina
Contact:

Re: an error in your SQL syntax; ..finder_taxonomy_map

Post by razor7 » Wed May 08, 2013 2:30 pm

TheAnt wrote:Try to empty Components / Smart search Indexed Content
It worked for me
Great!, it fixed it for me too!
Visit http://www.mgscreativa.com

Take a look at our downloads section for VirtueMart payment plugins and mouch more! http://www.mgscreativa.com/contenidos/i ... Itemid=214


Locked

Return to “General Questions/New to Joomla! 2.5”