Joomla Templates Club 406,261 posts

[rstaniszewski Friend rstaniszewskiJoin date: September 2011Posts: 17Downloads:0Uploads:0 Thanks: 3]

#184617

Hi,

Can anyone help?

I am using Mendozite, with the sample data and quick start for 2.5.8 K2 v2.6.2

Whenever I save or edit a new/exisiting item in K2 I get the following error.

500 – An error has occurred.

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 `tiger_finder_taxonomy_map` SET `link_id`=’5′,`node_id`=’3′ WHERE

I’ve upgraded K2 to the latest version.

Does anyone have any ideas?

Richard

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#482330

Hi,

Did you ever try going to backend and fix the database like this screenshot: http://easycaptures.com/fs/uploaded/535/9946258413.png ?

[rstaniszewski Friend rstaniszewskiJoin date: September 2011Posts: 17Downloads:0Uploads:0 Thanks: 3]

#482728

`Thanks Saguaros,

I’ve done that and it’s not change any thing. It only happens when I create a new K2 item or when I edit a sample item in the quick start template.

Once an item has been created, gone through the error and then re-edited it is OK.

I’m confused. K2 is up to date. And I’ve tried a new install too.

It only happens with this template for me.

Any other ideas anyone?

Richard

[Phill Moderator PhillJoin date: February 2014Posts: 7013Downloads:40Uploads:77 Thanks: 917 Thanked: 2206 times in 1818 posts]

#482730

If you switch to a default Joomla template on the same install do you still get a problem?

[rstaniszewski Friend rstaniszewskiJoin date: September 2011Posts: 17Downloads:0Uploads:0 Thanks: 3]

#482734

Hi Phil,
Thanks for the suggestion, unfortunately I uninstalled the default templates before I realized there was a problem.

I can see a way to reinstall them.

Richard

[Phill Moderator PhillJoin date: February 2014Posts: 7013Downloads:40Uploads:77 Thanks: 917 Thanked: 2206 times in 1818 posts]

#482747

I ask because the saving is a back end function and should not be affected by any front end template. Have a look around for a basic non jat3 based template and install that. Disable the JAT3 plugin and then see if you still get the same problem. I very much doubt you will. I very much doubt you will see a change. What is more likely is that either your database has become corrupt or you have a plugin installed that is causing your issue.

[rstaniszewski Friend rstaniszewskiJoin date: September 2011Posts: 17Downloads:0Uploads:0 Thanks: 3]

#482766

Hi Phil,

I just uploaded a virgin site with the template quickstart. I changed both the admin template and the front end one too. I get the same error.

I think the error is embedded in the quickstart set from the template.

Richard

[Phill Moderator PhillJoin date: February 2014Posts: 7013Downloads:40Uploads:77 Thanks: 917 Thanked: 2206 times in 1818 posts]

#482767

No problem. I will upload the template to my hosting and see what I get. Could you tell me your PHP and MySql versions so I can emulate your setup as best I can?

[rstaniszewski Friend rstaniszewskiJoin date: September 2011Posts: 17Downloads:0Uploads:0 Thanks: 3]

#482768

Thanks Phil,

PHP Version 5.3.8
Joomla! 2.5.9 Stable [ Ember ] 4-February-2013 14:00 GMT
MySQL version 5.1.67-cll

Richard

[Author]

Posts