- Posts: 6
COMMUNITY FORUM
K2 Tagcloud not working as multilanguage?
- Pere Castanyer Sardà
-
Topic Author
- Offline
- New Member
Less
More
11 years 11 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 11 months ago - 11 years 11 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 11 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.
Thank you for reporting this, we wiil look into it.
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 11 months ago - 11 years 11 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 11 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
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 11 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 11 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.
Please Log in or Create an account to join the conversation.
- JoomlaWorks
-
- Offline
- Admin
Less
More
- Posts: 6229
11 years 11 months ago #115151
by JoomlaWorks
Replied by JoomlaWorks on topic Re: [SOLVED] K2 Tagcloud not working as multilanguage?
The fix is part of version 2.6.7 released today.
Please Log in or Create an account to join the conversation.