1 nitfol Nov 11, 2005 20:16
3 havill Nov 16, 2005 03:38
Thanks for the patch, but I cannot reproduce it.
Shouldn't it show more than 5 posts here then?
The trick is to make a post then mess around with the categories.
Add two categories. Add a post assigning it to two or more. Then add another category. Edit the post, changing one old category for another.
The basically causes a state where the b2evolution database table evo_postcats contains two or more rows where the left side (the post id) is repeated for each category.
4 blueyed Nov 16, 2005 08:47
I still cannot reproduce it.
Additionally there's a PRIMARY/UNIQUE INDEX on those fields in T_postcats (evo_postcats).
Could you take a look if you have this index?
5 blueyed Nov 20, 2005 04:23
I've added a TODO in the code about this, but feedback and the real cause would be very welcome.. :)
6 blueyed Nov 29, 2005 14:15
I've changed it in CVS for Phoenix, because I've just seen it happening for myself.
7 staypuft Jan 05, 2006 16:55
Man, get catch by nitfol.
I've been going crazy trying to figure out why my post/page counts were way off whenever I made a post in multiple categories. I've searched these forums for months looking for the fix, and now finally I've found it, thanks to nitfol.
:D
Thanks for the patch, but I cannot reproduce it.
Shouldn't it show more than 5 posts here then?
http://demo.b2evolution.net/v9/blogs/index.php?blog=1