COMMUNITY FORUM

Keyword
  1. Forum
  3. K2 Community Forum
  5. English K2 Community
  7. 1064 SQL syntax error from #_k2_tags_xref

1064 SQL syntax error from #_k2_tags_xref

  • Rumen Georgieff
  • Rumen Georgieff's Avatar Topic Author
  • Offline
  • New Member
More
9 years 10 months ago - 9 years 10 months ago #129753 by Rumen Georgieff
1064 SQL syntax error from #_k2_tags_xref was created by Rumen Georgieff

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=DELETE FROM #_k2_tags_xref WHERE itemID={intval(


Hello,

does anyone know how to fix this? It shows when update to Joomla 3.3.1 when try to add new item. I'm using K2 v2.6.9 (dev build).

Thanks.

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 10 months ago - 9 years 10 months ago #129754 by Krikor Boghossian
Replied by Krikor Boghossian on topic Re: 1064 SQL syntax error from #_k2_tags_xref
Can you try with the latest DEV version (2.7.0) ?
Just in case (a real longshot) take a backup before updating.
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • Rumen Georgieff
  • Rumen Georgieff's Avatar Topic Author
  • Offline
  • New Member
More
9 years 10 months ago #129755 by Rumen Georgieff
Replied by Rumen Georgieff on topic Re: 1064 SQL syntax error from #_k2_tags_xref
From where can I download 2.7 dev?

Thanks.

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 10 months ago #129756 by Krikor Boghossian
Replied by Krikor Boghossian on topic Re: 1064 SQL syntax error from #_k2_tags_xref
Same place where you donwloaded the 2.6.9
getk2.org/assets/get/
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • Rumen Georgieff
  • Rumen Georgieff's Avatar Topic Author
  • Offline
  • New Member
More
9 years 10 months ago #129757 by Rumen Georgieff
Replied by Rumen Georgieff on topic Re: 1064 SQL syntax error from #_k2_tags_xref
I've try it .. but i prefer 2.6.9. Can I download it again, because I save 2.7 over the 2.6.9 on my computer.

Thanks.

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 10 months ago #129758 by Krikor Boghossian
Replied by Krikor Boghossian on topic Re: 1064 SQL syntax error from #_k2_tags_xref
Does it work with 2.7.0 ?
You can download older versions from here: getk2.org/downloads/ but sadly not the DEV ones.
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • Rumen Georgieff
  • Rumen Georgieff's Avatar Topic Author
  • Offline
  • New Member
More
9 years 10 months ago #129759 by Rumen Georgieff
Replied by Rumen Georgieff on topic Re: 1064 SQL syntax error from #_k2_tags_xref
Okay, but in the last stable version 2.6.8 .. there is a problem with publishing time .. always shows 00:00 .. is there any way fix this?

Thanks )

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 10 months ago #129760 by Krikor Boghossian
Replied by Krikor Boghossian on topic Re: 1064 SQL syntax error from #_k2_tags_xref
Of course.

You need to apply this patch. github.com/joomlaworks/k2/commit/9b4c27b60034bc80def73a0c28cd4a15bf81cd38
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  1. Forum
  3. K2 Community Forum
  5. English K2 Community
  7. 1064 SQL syntax error from #_k2_tags_xref

Powered by Kunena Forum