haroldstreet

Yes
There is a development version available (Ver 1000.03) which can do this.

I designed this for a review site that wanted to use images of different numbers of little stars to represent ratings indicated by tags.

It replaces the tag “5*” with “image 5-star.png”;
tag “4*” with “image 5-star.png”;
tag “3*” with “image 3-star.png”;
tag “2*” with “image 2-star.png”;
tag “1*” with “image 1-star.png”.

Give it a try and tell me how you get on.

OK problem is now solved and update 2.08 released
Thanks

phil

OK i’m still confused

You could try to replace line 182 in the plugin file cat-by-tags-table.php with…

$countsql.=”WHERE col.term_taxonomy_id = “.$col->term_id.” AND col.term_order = 0 “;

and see if that changes anything.

and if that doesn’t work would you consider exporting your entire wordpress MySQL database in to a zip file and emailing it to me at
phil(at)haroldstreet(dot)org(dot)uk
then i can try and experiment on it directly?

Cheers

phil

Hello again
i’ve been experimenting with my own site, and after some effort i managed to reproduce the error that you are seeing by adding different classifications to a post in different combinations and finally deleting it.

Finally the problem went away when i emptied the post trash folder and permanently deleted them all

Can you try empting your trash and see if that helps?

Cheers
phil

Or is it possible that some of the affected posts have been classified differently in earlier versions?

Hi again
Is it possible that you have some deleted or private posts that are being miscounted?

Otherwise i’d suggest you could try running a CHECK TABLES command on your Word Press MySQL database

Sorry i just don’t know what is causing this
phil

Hi – Sorry i’ve only just found your post!

That is really strange – is there anything different about those Categories or Tags from the others? Such as are any sub-cats/tags or have the got different slugs structures? or anything?

Cheers

phil

So i understand you have:

~100 cats and ~1000 tags

from another post elsewhere…

You realise that means the table would have more than 100,000 entries in the cross-tab table!

This is way more than this plugin could be designed to handle, and much more than you could ever display on web page anyway.

What were you thinking to even try it?

I’m not sure that i appreciate a “one star” rating, for an imposible task that no one could hope to succesfully code for, or with no attempt to ask advice first.

Cheers
phil

Hi
Yes i replaced my Blip slide show with a different slideshow once Blip stopped working

But i am a chrome user so i guess that is the problem for me.

Sorry
phil

For that many Cats and Tags the poor thing will have to look up 100,000 possible combinations of cats & tags, and then count each set of posts to generate the results for every view.

No matter how good your server is this is a bit more than the plugin is designed to handle.

I think you will need to un-install it

How many Cats / Tags do you have?
If its a real problem i could upgrade the script to add an index to the mysql tables to speed this up

What do you think?

Thanks

Ok i’ve fixed the problem by adding a fixed width & height to the “cycle-wrap” element through my own stylesheet.

Cheers

phil