Keyword

K2 Tagcloud not working as multilanguage?

  • Pere Castanyer Sardà
  • Pere Castanyer Sardà's Avatar Topic Author
  • Offline
  • New Member
More
11 years 2 months ago #115144 by Pere Castanyer Sardà
K2 Tagcloud not working as multilanguage? was created by Pere Castanyer Sardà
Hi all,

I'm trying to enable the module k2tools as TagCloud in a multilanguage site.
I'm recieving this error when I enable the tagcloud for any language:

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 ') AND tag.published = 1' at line 4 SQL=SELECT tag.name, tag.id FROM cfubg_k2_tags as tag LEFT JOIN cfubg_k2_tags_xref AS xref ON xref.tagID = tag.id WHERE xref.itemID IN () AND tag.published = 1

Any ideas what I'm doing wrong?

Joomla 3.1.1 and k2-svn

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

  • Pere Castanyer Sardà
  • Pere Castanyer Sardà's Avatar Topic Author
  • Offline
  • New Member
More
11 years 2 months ago - 11 years 2 months ago #115145 by Pere Castanyer Sardà
Replied by Pere Castanyer Sardà on topic Re: K2 Tagcloud not working as multilanguage?
More data:

It caught my attention this line of the SQL query:"...WHERE xref.itemID IN () AND..."

In the module helper.php this line whows as:
$query = "SELECT tag.name, tag.id
        FROM #__k2_tags as tag
        LEFT JOIN #__k2_tags_xref AS xref ON xref.tagID = tag.id 
        WHERE xref.itemID IN (".implode(',', $IDs).") 
        AND tag.published = 1";

Now I supose the problem is that sentence that return NIL: ".implode(',', $IDs)."

Sadly I'm a newcomer to php...any help on this?

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

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
11 years 2 months ago #115146 by Krikor Boghossian
Replied by Krikor Boghossian on topic Re: K2 Tagcloud not working as multilanguage?
Hello Pere,

Thank you for reporting this, we wiil look into it.

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

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

  • Pere Castanyer Sardà
  • Pere Castanyer Sardà's Avatar Topic Author
  • Offline
  • New Member
More
11 years 2 months ago - 11 years 2 months ago #115147 by Pere Castanyer Sardà
Replied by Pere Castanyer Sardà on topic Re: K2 Tagcloud not working as multilanguage?
I need to fill a bug with this or you'll handle it from here?

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

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
11 years 2 months ago #115148 by Krikor Boghossian
Replied by Krikor Boghossian on topic Re: K2 Tagcloud not working as multilanguage?
Yes you can also report it and monitor it through getk2.org/bugtracker

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

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

  • Pere Castanyer Sardà
  • Pere Castanyer Sardà's Avatar Topic Author
  • Offline
  • New Member
More
11 years 2 months ago #115149 by Pere Castanyer Sardà

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

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
11 years 2 months ago #115150 by Krikor Boghossian
Replied by Krikor Boghossian on topic [SOLVED] K2 Tagcloud not working as multilanguage?
It has been fixed, thank you for reporting this.

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

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

More
11 years 2 months ago #115151 by JoomlaWorks
The fix is part of version 2.6.7 released today.

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

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


Powered by Kunena Forum