- Posts: 6
COMMUNITY FORUM
K2 Tagcloud not working as multilanguage?
- Pere Castanyer Sardà
-
Topic Author
- Offline
- New Member
Less
More
11 years 9 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
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à
-
Topic Author
- Offline
- New Member
Less
More
- Posts: 6
11 years 9 months ago - 11 years 9 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:
Now I supose the problem is that sentence that return NIL: ".implode(',', $IDs)."
Sadly I'm a newcomer to php...any help on this?
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
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
11 years 9 months ago #115146
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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.
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à
-
Topic Author
- Offline
- New Member
Less
More
- Posts: 6
11 years 9 months ago - 11 years 9 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
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
11 years 9 months ago #115148
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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à
-
Topic Author
- Offline
- New Member
Less
More
- Posts: 6
11 years 9 months ago #115149
by Pere Castanyer Sardà
Replied by Pere Castanyer Sardà on topic Re: K2 Tagcloud not working as multilanguage?
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
11 years 9 months ago #115150
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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.
- JoomlaWorks
-
- Offline
- Admin
Less
More
- Posts: 6227
11 years 9 months ago #115151
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Re: [SOLVED] K2 Tagcloud not working as multilanguage?
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.