[wp-hackers] post2cat bug, WP2.2

[Brian Layman]

Would you like a query to clean that up or have you got that  licked
already?  Assuming you are on MySQL 4.1+ I can give you a 1 liner that
will remove the extras.

BTW I would definitely say log it in Trac so that it at least is
recorded and it can be repaired later.

______________________________________________
Brian Layman
b5media Inc.
www.b5Media.com / www.TheCodeCave.com
Skype: BrianLayman
Cell: (330) 858-3446
Fax: (416) 849-0347
TF: 866-652-7189


-----Original Message-----
From: wp-hackers-bounces at lists.automattic.com
[mailto:wp-hackers-bounces at lists.automattic.com] On Behalf Of Boris
Anthony
Sent: Friday, June 08, 2007 10:36 AM
To: wp-hackers at lists.automattic.com
Subject: [wp-hackers] post2cat bug, WP2.2


Hi gang,

Mysterious thing started happening yesterday afternoon on our site,  
globalvoicesonline.org: a post appeared twice in some but not all of  
the category archives of categories it was assignd to.

pokign my head into the database revealed that 9 of the 11 categories  
the post was associated to, were associated twice!

e.g.:
post2cat:
rel_id	post_id	category_id
145262  	26542  	300
145256 	26542 	300
145259 	26542 	287
145253 	26542 	287
145261 	26542 	282
145255 	26542 	282
145260 	26542 	271
145254 	26542 	271
145258 	26542 	259
145252 	26542 	259
145257 	26542 	256
145251 	26542 	256
145248 	26542 	247
145247 	26542 	247
145250 	26542 	227
145249 	26542 	227
144951 	26542 	221
144953 	26542 	21
144952 	26542 	14
(yeah we're at almost 30,000 posts, 350 categories and almost 150k  
post2cat associations... ouch)

I'm thinking there's something funky happening at posting time? Or on  
auto-save?

[May this be related to some strange behavior some of our authors  
have been experiencing where a draft is no longer editable by them...  
yet to replicate that one myself but it's happened 3 times since we  
upped to 2.2 2 weeks ago. As well as disappearing comments... but I  
digress. :\ ]

Is there somewhere else I need to mention this? Bug tracker? :D

thnx!

B.

_______________________________________________
wp-hackers mailing list
wp-hackers at lists.automattic.com
http://lists.automattic.com/mailman/listinfo/wp-hackers