tagcloud plugin?

The place to talk about things that are related to CMS Made simple, but don't fit anywhere else.
Post Reply
Golf Gti

tagcloud plugin?

Post by Golf Gti »

Does the tagcloud plugin work with cmsms 1.8.1
I am trying to setup a tagcloud with the plugin located here
http://dev.cmsmadesimple.org/projects/tagcloud

I follow all instructions and no tags are outputted.
I am using Search module 1.6.5 and cmsms 1.8.1
Did something change in the core and now this plugin wont work.

Any help is greatly appreciated.
Top
User avatar
map_1961
Power Poster
Power Poster
Posts: 410
Joined: Fri Apr 20, 2007 7:26 pm

Re: tagcloud plugin?

Post by map_1961 »

Hi.

We have the same problem. But it seems that it's not version related.

We set up a Geekmoot 2010 conference site in cms mle 1.8.2 (http://geekmoot2010.mp-p.net).
tagcloud is working fine on this page - even in the contentblock or the contend itself.

But on another page cms mle 1.8.2 we don't get any result - like described above. Don't know why. Search module was reinstalled - search index reset - all done - no change.

Who has another idea?

Thankx

map_1961
Top
idistech
New Member
New Member
Posts: 4
Joined: Tue Jan 25, 2011 8:30 pm

Re: tagcloud plugin? Returning No Results

Post by idistech »

Im having the same experience with tagcloud 2.10.1 and cmsms 1.9.2

No results.

With the debug on I get then following ...
SELECT search_index.word AS word, SUM(search_index.count) AS count FROM `cms_module_search_index` AS search_index INNER JOIN `cms_module_search_items` AS search_items ON (search_items.id = search_index.item_id) WHERE (search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '% %' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%¡%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%¢%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%£%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%¤%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%¥%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%¦%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%§%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%¨%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%©%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ª%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%«%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%¬%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%­%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%®%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%¯%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%°%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%±%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%²%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%³%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%´%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%µ%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%¶%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%·%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%¸%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%¹%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%º%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%»%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%¼%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%½%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%¾%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%¿%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%À%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Á%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Â%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ã%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ä%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Å%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Æ%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ç%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%È%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%É%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ê%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ë%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ì%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Í%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Î%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ï%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ð%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ñ%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ò%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ó%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ô%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Õ%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ö%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%×%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ø%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ù%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ú%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Û%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ü%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Ý%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%Þ%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ß%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%à%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%á%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%â%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ã%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ä%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%å%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%æ%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ç%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%è%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%é%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ê%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ë%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ì%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%í%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%î%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ï%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ð%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ñ%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ò%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ó%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ô%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%õ%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ö%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%÷%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ø%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ù%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ú%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%û%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ü%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ý%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%þ%' AND search_index.word NOT LIKE '%�%' AND search_index.word NOT LIKE '%ÿ%' AND search_index.word NOT LIKE '%"%' AND search_index.word NOT LIKE '%"%' AND search_index.word NOT LIKE '%<%' AND search_index.word NOT LIKE '%<%' AND search_index.word NOT LIKE '%>%' AND search_index.word NOT LIKE '%>%' AND search_index.word NOT LIKE '%&%' AND search_index.word NOT LIKE '%&%') AND (search_index.word NOT REGEXP '^[[:digit:]]+$') AND (DATEDIFF(IFNULL(search_items.expires,NOW()),NOW()) >= 0) AND search_items.extra_attr NOT LIKE 'template' GROUP BY word ORDER BY count DESC


When I try and run this query in phpmyadmin I get ...

#1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'

The clue is in the error message, but not sure if this is from one character, or the whole settings...

Any help greatly appreciated...

G
Top
idistech
New Member
New Member
Posts: 4
Joined: Tue Jan 25, 2011 8:30 pm

Re: tagcloud plugin? [SOLVED]

Post by idistech »

My database was a latin_swedish_ci collate...( as it was an upgrade from days gone by }
as woon as I migrated the database to utf8, it started to work again !!!

happy days...;-)
Top
Post Reply

Return to “The Lounge”