Keyword

Problem with import of Joomla Content

More
10 years 1 month ago #131270 by Marco
Hello,

i need some help with import Joomla Content to K2.

I get this 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 ' 225)' at line 1 SQL=INSERT INTO jos_k2_tags_xref (`id`, `tagID`, `itemID`) VALUES (NULL, , 225)

It doesnt imort the categories and most of the articles.
website is www.fretties.de

What can i do?

greetings,
Marco

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

More
10 years 1 month ago #131271 by shenkwen
Replied by shenkwen on topic Re: Problem with import of Joomla Content
I encounter the same problem, I hope someone can answer this.

I figure it out that K2's tag system doesn't comply with Joomla's. If you create a K2 item and make a tag for it, it doesn't appear in Joomla's tag list.

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

More
9 years 11 months ago #131272 by Kai Schöning
Replied by Kai Schöning on topic Re: Problem with import of Joomla Content
i have the same problem- any ideas??? 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 ' 6661)' at line 1 SQL=INSERT INTO g3qth_k2_tags_xref (`id`, `tagID`, `itemID`) VALUES (NULL, , 6661)

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

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 11 months ago #131273 by Krikor Boghossian
Replied by Krikor Boghossian on topic Re: Problem with import of Joomla Content
Which version of K2 are you using?

@vincent wen K2 uses its own tagging system.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

More
9 years 11 months ago #131274 by Kai Schöning
Replied by Kai Schöning on topic Re: Problem with import of Joomla Content
using the newest version of joomla and k2 - but i figure out the problem:

it was one content item (id 6661) - after delete this content (including trash) it works

i guess it was "ë"
Log in  or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 11 months ago - 9 years 11 months ago #131275 by Krikor Boghossian
Replied by Krikor Boghossian on topic Re: Problem with import of Joomla Content
Thanks for letting us know Kai.

If you are still having issues you can use the 2.7 DEV version where this issue has been resolved.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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